Re: Index only scans wiki page

https://wiki.postgresql.org/wiki/Index-only_scans

This page is seriously out of date. It suggests they are not yet
implemented, but only being talked about.

Would someone who knows a lot about the subject (which is why I'm
sending this hackers, not web) like to take a whack at updating this?
Otherwise, I'd like to just replace the whole page with a discussion
of the limitations and trade-offs involved in using them as they
currently exist

Thanks,

Jeff

On 13 November 2012 01:03, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> https://wiki.postgresql.org/wiki/Index-only_scans
>
> This page is seriously out of date. It suggests they are not yet
> implemented, but only being talked about.

Attached is a piece I wrote on the feature. That might form the basis
of a new wiki page. Feel free to incorporate this material as you see
fit.

--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

On Mon, Nov 12, 2012 at 8:25 PM, Peter Geoghegan <peter(at)2ndquadrant(dot)com> wrote:
> On 13 November 2012 01:03, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>> https://wiki.postgresql.org/wiki/Index-only_scans
>>
>> This page is seriously out of date. It suggests they are not yet
>> implemented, but only being talked about.
>
> Attached is a piece I wrote on the feature. That might form the basis
> of a new wiki page. Feel free to incorporate this material as you see
> fit.

I found this an interesting read. As one of the people who worked on
the feature, I'm sort of curious whether people have any experience
yet with how this actually shakes out in the field. Are you (or is
anyone) aware of positive/negative field experiences with this
feature?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On 13 November 2012 16:37, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> I found this an interesting read. As one of the people who worked on
> the feature, I'm sort of curious whether people have any experience
> yet with how this actually shakes out in the field. Are you (or is
> anyone) aware of positive/negative field experiences with this
> feature?

Unfortunately, I don't think that I have any original insight about
the problems with index-only scans in the field right now.

--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

On 13 November 2012 16:37, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> I found this an interesting read. As one of the people who worked on
> the feature, I'm sort of curious whether people have any experience
> yet with how this actually shakes out in the field. Are you (or is
> anyone) aware of positive/negative field experiences with this
> feature?

Unfortunately, I don't think that I have any original insight about
the problems with index-only scans in the field right now.

--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

On 13 November 2012 01:25, Peter Geoghegan <peter(at)2ndquadrant(dot)com> wrote:
> Attached is a piece I wrote on the feature. That might form the basis
> of a new wiki page.

Since no one else moved on this, I've completely replaced the existing
page with the contents of the user-orientated document I posted. I
don't believe that any of the information that has been removed was of
general interest, since it only existed as a developer-orientated
page. If anyone thinks that I shouldn't have removed everything that
was there, or indeed who would like to change what I've added, well,
it's a wiki.

--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services