On 8/28/08, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> 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?