William Yu wrote:
Yes , vacuumdb daily.

Do you vacuum table by table or the entire DB? I find over time, the system tables can get very bloated and cause a lot of slowdowns just due to schema queries/updates. You might want to try a VACUUM FULL ANALYZE just on the system tables.

A REINDEX of the system tables in stand-alone mode might also be in order, even for a 7.4.x database:


If a dump-reload-analyze cycle yields significant performance improvements then we know it's due to dead-tuple bloat - either heap tuples or index tuples.

Mike Mascari

---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to