On 8/28/08, Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> 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?
