Date: Tue, 11 Feb 2014 18:54:10 +0100
From: Andres Freund <andres@2ndquadrant.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Jim Nasby <jim@nasby.net>,
 Alvaro Herrera <alvherre@2ndquadrant.com>,
 Peter Geoghegan <peter@2ndquadrant.com>,
 Tom Lane <tgl@sss.pgh.pa.us>, Andrew Dunstan <andrew@dunslane.net>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [PERFORM] encouraging index-only scans
Message-ID: <20140211175410.GF31598@awork2.anarazel.de>
References: <20130907002908.GA12753@momjian.us>
 <20130907053449.GE626072@alap2.anarazel.de>
 <5238854F.5040708@nasby.net>
 <20130917231050.GD29545@awork2.anarazel.de>
 <CA+TgmoZQyt253OA_ssD6OVs8o0-RkRz3eK6qZz3Utwp-2QVf6A@mail.gmail.com>
 <20140201032207.GD31141@momjian.us>
 <CA+TgmoYOAzNKWKdkNcq50MFQKdgSt1ESR6zxb8XKCiNO6YBX2A@mail.gmail.com>
 <20140211155607.GB2289@momjian.us>
 <CA+TgmobeczQK0LhgVz_bSs7M4iTbCP=sfK8=6yDuCpwtOiuCCw@mail.gmail.com>
 <20140211171213.GE2289@momjian.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20140211171213.GE2289@momjian.us>
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On 2014-02-11 12:12:13 -0500, Bruce Momjian wrote:
> Yes, that pretty much sums it up.  We introduced index-only scans in 9.2
> (2012) but they still seem to be not usable for insert-only workloads
> two years later.  Based on current progress, it doesn't look like this
> will be corrected until 9.5 (2015).  I am kind of confused why this has
> not generated more urgency.

I think this largely FUD. They are hugely beneficial in some scenarios
and less so in others. Just like lots of other features we have.

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers