Re: index-only scans

From: PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: Joshua D(dot) Drake <jd(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: index-only scans
Date: 2011-10-11 14:07:06
Message-ID: 929DCB66-424F-454E-8823-5737277724CE@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Oct 7, 2011, at 8:47 PM, Joshua D. Drake wrote:

>
> On 10/07/2011 11:40 AM, Tom Lane wrote:
>> Robert Haas<robertmhaas(at)gmail(dot)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.

+1 ...
definitely an important thing to do.

regards,

hans

--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-10-11 14:29:51 Re: unite recovery.conf and postgresql.conf
Previous Message Robert Haas 2011-10-11 13:44:08 Re: [v9.2] DROP statement reworks