| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: 9.5alpha1: Partial index not used |
| Date: | 2015-08-01 18:33:50 |
| Message-ID: | 8852.1438454030@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Peter J. Holzer" <hjp-pgsql(at)hjp(dot)at> writes:
> On 2015-07-31 20:03:41 -0400, Tom Lane wrote:
>> Only the last case produces use of the index. I agree that it'd be better
>> if they all did, but I'm disinclined to consider it a bug fix unless you
>> can show a specific case in which there's a performance regression from
>> older releases.
> "grossly incorrect plan choices are cause for a bug report" (from
> http://www.postgresql.org/docs/9.5/static/indexes-partial.html) ;-)
Sorry, I phrased that poorly. I meant that I'm disinclined to change
this behavior in stable branches unless it's a regression. I agree
that it's reasonable to fix it in 9.5/HEAD, and I've now done so.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2015-08-01 20:41:02 | Re: 9.5alpha1: Partial index not used |
| Previous Message | Tom Lane | 2015-08-01 17:55:53 | Re: BUG #13530: sort receives "unexpected out-of-memory situation during sort" |