Douglas McNaught wrote: > You need to ANALYZE the tables after you load them, and make sure you > have indexes on the column you're querying (which it sounds like you > do, but they're not being used because the statistics for the table > are inaccurate).
I've seen discussion here that made it sound like a REINDEX might also be required on tables with really high data churn (ie when VACUUM / VACUUM FULL are run a lot) - if you're not dropping and re-creating the indexes for better bulk load performance anyway, of course. Am I just confused, or can this sometimes be necessary? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
