Re: Sort time

Pginfo,

> Yes I have indexes on all this fields.
> Also I vacuumed and that is the result after it.
> Actualy I do not see what bad in query execution. The problem is in
> sort
> time!

Hmmm... I don't understand.  The way I read the EXPLAIN, the sort is
only taking a few seconds.   Am I missing something, here?

And that's "VACUUM FULL ANALYZE", not just "VACUUM", yes?

If all of the above has been tried, what happens to the query when you
set enable_seqscan=off?

-Josh Berkus