Re: Patch for removng unused targets

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Patch for removng unused targets
Date: 2013-08-02 21:57:52
Message-ID: 51FC2B60.2070406@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Reading between the lines of the original submission at
> <CAPpHfdtG5qoHoD+w=Tz3wC3fZ=b8i21=V5xandBFM=DTo-Yg=Q(at)mail(dot)gmail(dot)com>,
> I gather that it's the KNNGist-style case that worries you, so maybe
> it's worth applying this type of patch anyway. I'd want to rejigger
> it to be aware of the cost implications though, at least for
> grouping_planner's choices.

Hmm. Can we optimize for the KNN case, without causing the issues which
you warned about earlier in your post? I'm really wary of any
"optimization" which operates completely outside of the cost model; the
ones we have (abort-early plans, for example) are already among our
primary sources of bad plan issues.

>
> Comments?

So, Returned With Feedback, or move it to September?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2013-08-02 22:17:43 Re: 9.3beta2: Failure to pg_upgrade
Previous Message Alvaro Herrera 2013-08-02 21:43:03 Re: how to pass data (tuples) to worker processes?