Re: Small query plan change, big performance difference

From: Michael Sacket <msacket(at)gammastream(dot)com>
To: Adam Brusselback <adambrusselback(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Small query plan change, big performance difference
Date: 2018-06-14 18:49:34
Message-ID: 162B854F-1B6A-44BC-ABF7-BFA24D632F5B@gammastream.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Brusselback 2018-06-19 19:50:15 Re: [PERFORM] Dissuade the use of exclusion constraint index
Previous Message Adam Brusselback 2018-06-14 18:24:42 Re: Small query plan change, big performance difference