Re: How to deal with analyze gathering irrelevant stats

From: Adam Brusselback <adambrusselback(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Rémi Chatenay <remi(dot)chatenay(at)doctolib(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: How to deal with analyze gathering irrelevant stats
Date: 2021-01-11 16:37:33
Message-ID: CAMjNa7fjhScBU_H2y_SC6s1D0gzM+jd2N0g=+q2ksMJgU1Srrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'd personally bake an analyze call on that table (column) into whatever
job is responsible for changing the state of the table that much, if it's
possible to do it as a last step.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Lewis 2021-01-11 16:47:36 Re: How to deal with analyze gathering irrelevant stats
Previous Message Justin Pryzby 2021-01-11 16:29:04 Re: How to deal with analyze gathering irrelevant stats