Re: the big picture for index-only scans

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Simon Riggs" <simon(at)2ndQuadrant(dot)com>
Cc: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: the big picture for index-only scans
Date: 2011-05-10 23:14:40
Message-ID: 4DC98090020000250003D534@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndQuadrant(dot)com> wrote:

> Normally, others come forward with the why? when? questions and it
> feels like there's a bit of groupthink going on here. This looks
> to me like its being approached like it was a feature, but it
> looks to me like a possible optimisation, so suggest we treat it
> that way.

This issue has come up a great many times over the years, and there
has been much discussion around it. The Wiki page is here:

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

This currently references 11 threads on the topic. I'd bet that by
spending a couple hours at it I could quadruple that number of
threads. (I'd really rather not, though.)

The problem is that there are regular and fairly frequent complaints
on the list about queries which run slower than people expect
because the heap must be checked for visibility information when
matching index entries are found. It has become enough of a
conspicuous issue that a lot of people are interested in seeing if
something can be done about it. After much discussion, people are
trying to advance a plan to find an answer. I'm sure nobody
involved would ignore any suggestion on how it might be done better;
but at this point, I don't think it's fair to suggest that this is
not being pursued in response to a real problem, or that no serious
thought has been given to direction before people started moving.

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-05-10 23:44:35 Re: Re: [BUGS] BUG #5957: createdb with description and md5 auth forces to provide password twice
Previous Message Tom Lane 2011-05-10 23:10:02 Re: Infinity bsearch crash on Windows