On Wed, Jan 18, 2017 at 1:04 PM, Ravi Tammineni <rtammineni@xxxxxxxxxxxxxxxxxxxxx> wrote: > Hi Chris, > > Here is the query and execution plan in 9.5 and 9.6. Can you verify tblpuorderstatus and tblpuorderstatushistory have all indexes accounted for on both servers? It seems incredible server would prefer wading through 11M records to 1298 nestloop. I'm curious what plans you get if you try playing around with: set enable_seqscan=false; set enable_hashjoin=false; ...but I think we have two possibilities here: 1. schema mismatch 2. planner bug merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
