cybertec-postgresql / pg_squeeze

A PostgreSQL extension for automatic bloat cleanup
Other
470 stars 31 forks source link

Processing starting immedietly when starting worker, regardless of squeeze.tables.schedule #26

Closed airlocksniffer closed 4 years ago

airlocksniffer commented 4 years ago

Testing on some non-prod instances I'm finding as soon as I start the worker tables are processed immediately, even though I've specified in squeeze.tables.schedule to start at midnight. Is this expected?

ahouska commented 4 years ago

Did you specify midnight as 0:00? I think it's o.k. to start processing because 0:00 is in the past at the moment the worker is launched. Does it help if you schedule the squeeze to run at 23:59?

airlocksniffer commented 4 years ago

Thanks @ahouska that seemed to do the trick.