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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2012-08-25 03:42:40 Re: Loose Index Scans by Planner?
Previous Message Artur Zając 2012-08-24 21:11:08 Re: NOTIFY performance