Re: Small query plan change, big performance difference

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Small query plan change, big performance difference
From: Michael Sacket <msacket@xxxxxxxxxxxxxxx>
Date: Thu, 14 Jun 2018 13:49:34 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAMjNa7e2T-n7oAZtsVPDcSrJqEBcCCdo1FPV0dwBPhh1OemO1g@mail.gmail.com>
References: <A7884576-3F24-4291-A4F0-345BFF384FAC@gammastream.com> <CAMjNa7e2T-n7oAZtsVPDcSrJqEBcCCdo1FPV0dwBPhh1OemO1g@mail.gmail.com>

> 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 run analyze.

References:
- Small query plan change, big performance difference
  - From: Michael Sacket
- Re: Small query plan change, big performance difference
  - From: Adam Brusselback

Prev by Date: Re: Small query plan change, big performance difference
Next by Date: Re: Dissuade the use of exclusion constraint index
Previous by thread: Re: Small query plan change, big performance difference
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux