[EMAIL PROTECTED] 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:
http://www.postgresql.org/docs/7.4/interactive/sql-reindex.html
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
