Re: Queries are taking way longer in 9.6 than 9.5

On Wed, Jan 18, 2017 at 3:06 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> On Wed, Jan 18, 2017 at 1:04 PM, Ravi Tammineni
> <rtammineni(at)partner(dot)aligntech(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

*I never got an answer to my question.*

*Have you verified that postgresql.conf is the same of both 9.5 & 9.6?*

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.