2 ms·

I love Postgres as much as the next guy but there are three things that really annoy me: Postgres is still laid out for for 9 to 5 workloads, accumulating garb

by aeyes 7y ago

I love Postgres as much as the next guy but there are three things that really annoy me: Postgres is still laid out for for 9 to 5 workloads, accumulating garbage during the day and running vacuum at night. Autovacuum just doesn't cut it in a 24/7 operation and it is by far what has caused the most problems in production. No query hints and no plan to ever implement it. Making the planner better only takes you so far when everything depends on table statistics which can be easily skewed. pg_hint_plan or using CTEs is not extensive enough. Partial indexes are not well supported in the query planner, thanks to no query hints I can't even force the planner to use them.

patrec 7y ago
Do you have a good Postgres DBA? Autovacuum can indeed ruin your day if you have a 24/7 DB that is delete or update heavy (the default setting are not very aggressive and once it falls behind badly it will never catch up and you'll need to do some emergency manual vacuuming). But I can assure you it's possible to run 24/7 DBs fine without running into autovacuming problems by making sure things are configured right. I've experienced both regular problems due to bad config and their complete disappearance.