Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> writes: > Tom Lane wrote: >> I'm betting on varying degrees of table bloat. Have you tried vacuum >> full, cluster, etc? > Or, if you have been using VACUUM FULL, try REINDEXing the tables, > because it could easily be index bloat. Clustering the table will take > care of index bloat as well as table bloat. Index bloat wouldn't explain the slow-seqscan behavior the OP was complaining of. Still, you're right that if the tables are bloated then their indexes probably are too ... and that VACUUM FULL alone will not fix that. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
