Re: 9.6 query slower than 9.5.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Brusselback <adambrusselback(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 9.6 query slower than 9.5.3
Date: 2016-06-17 15:22:08
Message-ID: 21830.1466176928@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Adam Brusselback <adambrusselback(at)gmail(dot)com> writes:
> I finally managed to get it compiled, patched, and working. It gave the
> same plan with the same estimates as when I turned fkey_estimates off.

OK, well, at least it's not making things worse ;-). But I think that
this estimation method isn't very helpful for antijoin cases anyway.

> I was wondering if I did things properly though, as i don't see the
> enable_fkey_estimates GUC any more. Was it removed?

Yes, that was only intended for debugging, and the consensus was that
it probably shouldn't have been committed in the first place.

Thanks for taking the trouble to check this!

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message meike.talbach 2016-06-19 09:59:26 Re: Index not used
Previous Message e.ratnakar.shetty 2016-06-17 15:19:34 Savepoint and Releasepoint in Logs