Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group