Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 92F4E133616B for ; Thu, 17 Mar 2011 11:55:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 67260-01 for ; Thu, 17 Mar 2011 14:55:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10]) by mail.postgresql.org (Postfix) with ESMTP id 8BD331337BEA for ; Thu, 17 Mar 2011 11:55:30 -0300 (ADT) Received: from mh3.mail.rice.edu (localhost.localdomain [127.0.0.1]) by mh3.mail.rice.edu (Postfix) with ESMTP id 6480828F83C; Thu, 17 Mar 2011 09:55:30 -0500 (CDT) X-Virus-Scanned: by amavis-2.6.4 at mh3.mail.rice.edu, auth channel Received: from mh3.mail.rice.edu ([127.0.0.1]) by mh3.mail.rice.edu (mh3.mail.rice.edu [127.0.0.1]) (amavis, port 10026) with ESMTP id q4skJEXgEQnp; Thu, 17 Mar 2011 09:55:30 -0500 (CDT) X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.is.rice.edu (aart.is.rice.edu [168.7.56.48]) by mh3.mail.rice.edu (Postfix) with ESMTP id 1EDC528F835; Thu, 17 Mar 2011 09:55:30 -0500 (CDT) Received: by aart.is.rice.edu (Postfix, from userid 18612) id EE39D2D5A6; Thu, 17 Mar 2011 09:55:29 -0500 (CDT) Date: Thu, 17 Mar 2011 09:55:29 -0500 From: Kenneth Marshall To: Kevin Grittner Cc: Derrick Rice , pgsql-performance@postgresql.org Subject: Re: Updating histogram_bounds after a delete Message-ID: <20110317145529.GK11541@aart.is.rice.edu> References: <4D80EBAB020000250003B9DE@gw.wicourts.gov> <4D81D939020000250003BA22@gw.wicourts.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4D81D939020000250003BA22@gw.wicourts.gov> User-Agent: Mutt/1.5.16 (2007-06-09) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/184 X-Sequence-Number: 42863 On Thu, Mar 17, 2011 at 09:49:45AM -0500, Kevin Grittner wrote: > Derrick Rice wrote: > > Kevin Grittner > > >> there is a feature to probe the end of an index's range in > >> situations where data skew was often causing less than optimal > >> plans to be chosen. > > > > Was this introduced in 9.0 or was it earlier? > > I don't remember when it was added. I took a stab at searching for > it, but didn't get it figured out; if nobody who knows off-hand > jumps in, I'll try again when I have more time. > I think this is it: http://archives.postgresql.org/pgsql-committers/2010-01/msg00021.php Regards, Ken