On 8/28/08, Andreas Kretschmer <[EMAIL PROTECTED]> wrote: > > Please show us a EXPLAIN ANALYSE for this query. Btw, why > random_page_cost=2? (your other post)
The EXPLAIN ANALYZE shows that it's using an INDEX and getting one row! So I know the SQL is right. Could it be that the SQL queries become slow because some other background operation is running, like pg_dumpall or vaccuum? How would I test this hypothesis if the log does have mentioned of "vaccuum analyze" being slow? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
