Re: Sort time

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sort time
Date: 2002-11-15 17:33:47
Message-ID: web-1827511@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2002-11-15 18:48:23 Re: Sort time
Previous Message Josh Berkus 2002-11-15 17:22:32 Re: Upgrade to dual processor machine?