| From: | Alex Shulgin <alex(dot)shulgin(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | David Steele <david(at)pgmasters(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Subject: | Re: More stable query plans via more predictable column statistics |
| Date: | 2016-04-03 18:51:04 |
| Message-ID: | CAM-UEKT3UF=CFPym5WfzjOyaQLCJiP991PjfUP1GbDmhiyifng@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, Apr 3, 2016, 18:40 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Alex Shulgin <alex(dot)shulgin(at)gmail(dot)com> writes:
>
> > Well, if it's the only value it will be accepted simply because we are
> > checking that special case already and don't even bother to loop through
> > the track list.
>
> That was demonstrably not the case in the failing regression test.
> I forget what aspect of the test case allowed it to get past the short
> circuit, but it definitely got into the scan-the-track-list code.
>
Hm, I'll have to see that for myself, probably there was something more to
it.
--
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2016-04-03 19:35:27 | Re: Proposal: RETURNING primary_key() |
| Previous Message | Alex Shulgin | 2016-04-03 18:41:13 | Re: Add schema-qualified relnames in constraint error messages. |