| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | Andreas Karlsson <andreas(at)proxel(dot)se>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Ignored join clause |
| Date: | 2018-04-19 15:20:39 |
| Message-ID: | 21505.1524151239@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I wrote:
> I've not got to the bottom of it yet either, but I notice that if you
> replace the VALUES thingy with a plain table, the bug goes away:
Oh, scratch that --- if you "ANALYZE q1", it goes right back to the
bogus plan. So knowing that q1 is small is part of the triggering
condition for picking the bogus plan, but VALUES per se isn't.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-04-19 16:58:47 | Re: Ignored join clause |
| Previous Message | Tom Lane | 2018-04-19 15:11:32 | Re: Ignored join clause |