Re: index-only scans - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: index-only scans
Date
Msg-id 4E8F495E.9040807@commandprompt.com
Whole thread Raw
In response to Re: index-only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: index-only scans
List pgsql-hackers
On 10/07/2011 11:40 AM, Tom Lane wrote:
> Robert Haas<robertmhaas@gmail.com>  writes:
>> Please find attached a patch implementing a basic version of
>> index-only scans.
>
> I'm making some progress with this, but I notice what seems like a
> missing feature: there needs to be a way to turn it off.  Otherwise
> performance comparisons will be difficult to impossible.
>
> The most obvious solution is a planner control GUC, perhaps
> "enable_indexonlyscan".  Anyone object, or want to bikeshed the name?

enable_onlyindexscan

I'm kidding.

+1 on Tom's proposed name.

>
>             regards, tom lane
>


-- 
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: index-only scans
Next
From: Robert Haas
Date:
Subject: Re: index-only scans