Re: Ignored join clause - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Ignored join clause
Date
Msg-id 21505.1524151239@sss.pgh.pa.us
Whole thread Raw
In response to Re: Ignored join clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Ignored join clause
Next
From: Tom Lane
Date:
Subject: Re: Ignored join clause