Re: Ignored join clause

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

In response to

Browse pgsql-bugs by date

  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