Are the estimates made for number of pages accurate

From: Sai Sadashiva Kundurmutt <saisadashiva2000(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Are the estimates made for number of pages accurate
Date: 2024-02-25 08:40:05
Message-ID: CAH6hFGLT-58qZfPQRkOEt52qrU9iM-pw3DLi8UhwRsm7dO-V0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I wanted to know whether the numbers calculated by ANALYZE for number of
pages are exact(the relpages field in pg_class). I had the impression that
it is exact because during random sampling the number of pages is assumed
to be known. Is this true ??
Thank you,
Warm regards,
Sai Sadashiva JK

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2024-02-25 16:41:54 Re: Are the estimates made for number of pages accurate
Previous Message S Hoffman 2024-02-23 19:35:04 Re: Another way to do audit in DML operations in PostgreSQL >= 14