Re: Accounting for between table correlation - Mailing list pgsql-general

From Michael Lewis
Subject Re: Accounting for between table correlation
Date
Msg-id CAHOFxGqA_cRbJWXPLOzzrmTE4NwBGy-zWpx-JE0vH4OdJi90RQ@mail.gmail.com
Whole thread Raw
In response to Re: Accounting for between table correlation  (Alexander Stoddard <alexander.stoddard@gmail.com>)
Responses Re: Accounting for between table correlation
List pgsql-general
On Fri, Jan 15, 2021 at 10:22 AM Alexander Stoddard <alexander.stoddard@gmail.com> wrote:
The 'fast plans' use parallel seq scans. The 'slow plans' is using index scans. It appears a good query plan correctly predicts it should be bulk processing the tables but bad ones get fooled into trashing (hard disk, not SSD) by mispredicting too few rows to join between the tables. 

How many tables are involved? Are you sure it is stats getting updated causing the change in behavior? Are you hitting the genetic optimizer?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Best tools to monitor and fine tune postgres
Next
From: Michael Lewis
Date:
Subject: Re: Accounting for between table correlation