Re: [PERFORM] encouraging index-only scans

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jim Nasby <jim(at)nasby(dot)net>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Peter Geoghegan <peter(at)2ndquadrant(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PERFORM] encouraging index-only scans
Date: 2014-02-11 19:04:35
Message-ID: 20140211190435.GH2289@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Tue, Feb 11, 2014 at 01:54:48PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > On Tue, Feb 11, 2014 at 07:31:03PM +0100, Andres Freund wrote:
> >> I am not saying it shouldn't be improved, I just don't see the point of
> >> bringing it up while everyone is busy with the last CF and claiming it
> >> is unusable and that stating that it is surprisising that nobody really
> >> cares.
>
> > Well, I brought it up in September too. My point was not that it is a
> > new issue but that it has been such an ignored issue for two years. I
> > am not asking for a fix, but right now we don't even have a plan on how
> > to improve this.
>
> Indeed, and considering that we're all busy with the CF, I think it's
> quite unreasonable of you to expect that we'll drop everything else
> to think about this problem right now. The reason it's like it is
> is that it's not easy to see how to make it better; so even if we did
> drop everything else, it's not clear to me that any plan would emerge
> anytime soon.

Well, documenting the VACUUM requirement and adding it to the TODO list
are things we should consider for 9.4. If you think doing that after
the commit-fest is best, I can do that.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Janes 2014-02-11 19:13:00 Re: [PERFORM] encouraging index-only scans
Previous Message Andres Freund 2014-02-11 19:03:47 Re: [PERFORM] encouraging index-only scans

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2014-02-11 19:13:00 Re: [PERFORM] encouraging index-only scans
Previous Message Andres Freund 2014-02-11 19:03:47 Re: [PERFORM] encouraging index-only scans