On 29 Apr 2004 at 15:35, Kenneth Marshall wrote:
> Did you try to cluster based on the index?
Yes, This speeds up the index scan a little (12%). This to me just
reinforces the overhead that subsequently having to go and fetch the
data tuple actually has on the performance.
In response to
pgsql-performance by date
|Next:||From: Vitaly Belman||Date: 2004-04-29 21:09:36|
|Subject: Re: Simply join in PostrgeSQL takes too long|
|Previous:||From: Josh Berkus||Date: 2004-04-29 20:54:33|
|Subject: Re: planner/optimizer question|