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

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

pgsql-performance by date

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

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