| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Thomas Kellerer <shammat(at)gmx(dot)net>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL does not choose my indexes well |
| Date: | 2020-04-23 20:33:07 |
| Message-ID: | 12000.1587673987@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Stephen Frost <sfrost(at)snowman(dot)net> writes:
> I'm pretty suspicious that they've made some odd planner configuration
> changes or something along those lines to end up with the plan they got,
> or there's some reason we don't think we can use the partial index.
Yeah, the latter is definitely a possibility. I find the apparently
unnecessary cast in the partial-index predicate to be suspicious ---
maybe that's blocking matching to the WHERE clause? In principle
the useless cast should have gotten thrown away, but maybe what we
were shown isn't quite exactly the real DDL.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-04-23 20:36:15 | Re: PostgreSQL does not choose my indexes well |
| Previous Message | Stephen Frost | 2020-04-23 20:01:43 | Re: PostgreSQL does not choose my indexes well |