postgres_dynamic_partitions_dropper runs midday
postgres_dynamic_partitions_dropper cron "45 12 * * *"
This seems to me to be scheduling a process that requires an exclusive lock on the database to run at a quarter to 1:00pm everyday. It basically makes a bottleneck for 2 minutes or so.
I've tried to figure out how to change the cron entry through my gitlab.rb file, guessing at formats for the key value - postgres_dynamic_partitions_dropper_cron, dynamic_partitions_dropper_worker_cron
Just for fun I forced it to run after I checked the contents of the detached_partitions table and found it to have 14 entries, all to be dropped in the future. The job ran very quickly so I think the lock isn't taken unless there are partitions for it drop.
Edited by 🤖 GitLab Bot 🤖