Postgres Pro
Downloads
Home   >   mailing lists

Re: 9.6 query slower than 9.5.3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: 9.6 query slower than 9.5.3
Date
Msg-id 23002.1466131502@sss.pgh.pa.us
Whole thread Raw
In response to Re: 9.6 query slower than 9.5.3  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: 9.6 query slower than 9.5.3  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-performance
Tree view 
Adam Brusselback <adambrusselback@gmail.com> writes:
> Gah, hit send too soon...

Hm, definitely a lot of foreign keys in there.  Do the estimates get
better (or at least closer to 9.5) if you do
"set enable_fkey_estimates = off"?

            regards, tom lane

pgsql-performance by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: 9.6 query slower than 9.5.3
Next
From: Adam Brusselback
Date:
Subject: Re: 9.6 query slower than 9.5.3