Re: planner/optimizer question

From: "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: planner/optimizer question
Date: 2004-04-29 21:08:28
Message-ID: 40917CDC.3078.14EE7897@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 29 Apr 2004 at 15:35, Kenneth Marshall wrote:

> Did you try to cluster based on the index?
>
> --Ken

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.

Cheers,
Gary.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vitaly Belman 2004-04-29 21:09:36 Re: Simply join in PostrgeSQL takes too long
Previous Message Josh Berkus 2004-04-29 20:54:33 Re: planner/optimizer question