Re: Optimizer choosing the wrong plan

2018-12-29 Thread Jeff Janes
On Sat, Dec 29, 2018 at 7:17 AM Jim Finnerty wrote: > Jeff, can you describe the changes that were made to ANALYZE in v11, > please? > > I've found that running ANALYZE on v10 on the Join Order Benchmark, using > the default statistics target of 100, produces quite unstable results, so > I'd be

Re: Optimizer choosing the wrong plan

2018-11-26 Thread Jeff Janes
On Mon, Nov 26, 2018 at 5:11 AM Viswanath wrote: > *Postgres server version - 9.5.10* > *RAM - 128 GB* > *WorkMem 64 MB* > > *Problematic query with explain :* > *Query 1 (original):* > explain analyse SELECT myTable1.ID FROM myTable1 LEFT JOIN myTable2 ON > myTable1.ID=myTable2.ID WHERE my

Optimizer choosing the wrong plan

2018-11-26 Thread Viswanath
*Postgres server version - 9.5.10* *RAM - 128 GB* *WorkMem 64 MB* *Problematic query with explain :* *Query 1 (original):* explain analyse SELECT myTable1.ID FROM myTable1 LEFT JOIN myTable2 ON myTable1.ID=myTable2.ID WHERE myTable1.bool_val = true) AND (myTable1.small_intval IN (1,2,3))) AN