Postgres Pro
Downloads
Home   >   mailing lists

Re: Small query plan change, big performance difference - Mailing list pgsql-performance

From Michael Sacket
Subject Re: Small query plan change, big performance difference
Date
Msg-id 162B854F-1B6A-44BC-ABF7-BFA24D632F5B@gammastream.com
Whole thread Raw
In response to Re: Small query plan change, big performance difference  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-performance
Tree view 
> Have you run an analyze on all your tables after the upgrade to 10? The estimates are way off.

Thank you.  I embarrassingly missed that step.  That fixed the problem.  In the future, if estimates are way off… I’ll
runanalyze.

pgsql-performance by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Small query plan change, big performance difference
Next
From: Adam Brusselback
Date:
Subject: Re: [PERFORM] Dissuade the use of exclusion constraint index