Re: Small query plan change, big performance difference

From: Adam Brusselback <adambrusselback(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Small query plan change, big performance difference
Date: 2018-06-14 18:24:42
Message-ID: CAMjNa7e2T-n7oAZtsVPDcSrJqEBcCCdo1FPV0dwBPhh1OemO1g@mail.gmail.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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Sacket 2018-06-14 18:49:34 Re: Small query plan change, big performance difference
Previous Message Michael Sacket 2018-06-14 18:02:49 Small query plan change, big performance difference