Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sthomas@optionshouse.com>) id 1T51Kf-0008QX-1m
	for pgsql-performance@postgresql.org; Fri, 24 Aug 2012 21:22:21 +0000
Received: from smtp2.peak6.com ([38.98.137.9])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sthomas@optionshouse.com>) id 1T51Ka-0007wM-0S
	for pgsql-performance@postgresql.org; Fri, 24 Aug 2012 21:22:20 +0000
X-AuditID: 0a02cb1e-b7f4b6d000000b27-75-5037f0278213
Message-ID: <5037F084.3080401@optionshouse.com>
Date: Fri, 24 Aug 2012 16:22:12 -0500
From: Shaun Thomas <sthomas@optionshouse.com>
Reply-To: <sthomas@optionshouse.com>
Organization: Peak6
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:14.0) Gecko/20120714 Thunderbird/14.0
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Loose Index Scans by Planner?
References: <5037A9C5.4030701@optionshouse.com>
	<503792790200002500049B56@gw.wicourts.gov>
In-Reply-To: <503792790200002500049B56@gw.wicourts.gov>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
content-transfer-encoding: 7bit
X-Originating-IP: [10.10.201.64]
X-Brightmail-Tracker: 
 H4sIAAAAAAAAA+NgFrrHIsWRmVeSWpSXmKPExsXClcIroav+wTzAoPW8lcWj88tZLK7PPMfs
	wORxYd80do9XEzazBDBFNTDaJObl5ZcklqQqpKQWJ9sq+ReUZObnFXvklxanKrhkFifnJGbm
	phYpKWSm2CqZKykU5CQmp+am5pXYKiUWFKTmpSjZcSlgABugssw8hdS85PyUzLx0WyXPYH9d
	CwtTS11DJbt4ZJDQyZLxYlYre0Ezc8XHk41sDYzrmLoYOTkkBEwklv55ywxhi0lcuLeeDcTm
	FdCX+DlhNpjNIqAqMaFrGlgNm4CuxKT+FWBxIQEVib6zN8Dm8AsIS+z70ARUw8EhKhAksW8j
	M8QYQYmTM5+wgNgiAgYSN1asYAWxmQU8JTpOrWIEsYWBTug9eJAVYmSURFvzFLDxnALmEtv/
	bmWHqLeVuDDnOguELS+x/e0cZoh6VYkVzRPZIM5XkPh/5R3TBEahWUhWz0LSPgtJ+wJG5lWM
	4sVlickZmWYFxbklBYZ6BamJ2WZ6eaklmxhBcct0Wm4H44oLiocYBTgYlXh4Dc6bBwixJpYV
	V+YeYpTgYFYS4RXwAwrxpiRWVqUW5ccXleakFh9iNAUG2URmKdHkfGBKySuJNzQ2tDS1NDGz
	NDc2NlAS51XoUwoQEkgHpobs1NSC1CKYPiYOTqkGxmqNd+L/D0zIfSXKJJD7tYD/lfD0H5NM
	nFilV2SdX1ikvlelddcM+5kys/62Xg1VONdu9y9590n3tVd3Hs4/Zmza+v+bYOSGQKPV8X+z
	bIK3T9kbciuU1ZnrrwETS/Wej5++CV3ZEpYec/fqDekV8eednhxcbvL6R/iM4OXPsoqMf69g
	6njdb6DEUpyRaKjFXFScCACpRznN8QIAAA==
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201208/159
X-Sequence-Number: 47697

On 08/24/2012 02:40 PM, Kevin Grittner wrote:

> Well, that'd be the icing on the cake.  I'd be overjoyed to get the
> cake.  :-)

Yes indeed. The "cake" would fix the DISTINCT case, which I see way more 
often in the wild than my index column-skip.

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email