Postgres Pro
Downloads
Home   >   mailing lists

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

From Adam Brusselback
Subject Re: Small query plan change, big performance difference
Date
Msg-id CAMjNa7e2T-n7oAZtsVPDcSrJqEBcCCdo1FPV0dwBPhh1OemO1g@mail.gmail.com
Whole thread Raw
In response to Small query plan change, big performance difference  (Michael Sacket <msacket@gammastream.com>)
Responses Re: Small query plan change, big performance difference  (Michael Sacket <msacket@gammastream.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.

pgsql-performance by date:

Previous
From: Michael Sacket
Date:
Subject: Small query plan change, big performance difference
Next
From: Michael Sacket
Date:
Subject: Re: Small query plan change, big performance difference