Skip site navigation (1) Skip section navigation (2)

Re: Loose Index Scans by Planner?

From: Shaun Thomas <sthomas(at)optionshouse(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Loose Index Scans by Planner?
Date: 2012-08-24 21:22:12
Message-ID: 5037F084.3080401@optionshouse.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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(at)optionshouse(dot)com

______________________________________________

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


In response to

pgsql-performance by date

Next:From: Jeff JanesDate: 2012-08-25 03:42:40
Subject: Re: Loose Index Scans by Planner?
Previous:From: Artur ZajÄ…cDate: 2012-08-24 21:11:08
Subject: Re: NOTIFY performance

pgsql-hackers by date

Next:From: Tomas VondraDate: 2012-08-24 21:25:18
Subject: PATCH: pgbench - aggregation of info written into log
Previous:From: Tomas VondraDate: 2012-08-24 21:16:15
Subject: PATCH: pgbench - random sampling of transaction written into log

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group