> 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
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
In response to
pgsql-performance by date
|Next:||From: Rod Taylor||Date: 2002-11-15 18:48:23|
|Subject: Re: Sort time|
|Previous:||From: Josh Berkus||Date: 2002-11-15 17:22:32|
|Subject: Re: Upgrade to dual processor machine? |