Postgres Pro
Downloads
Home   >   mailing lists

Are the estimates made for number of pages accurate - Mailing list pgsql-admin

From Sai Sadashiva Kundurmutt
Subject Are the estimates made for number of pages accurate
Date
Msg-id CAH6hFGLT-58qZfPQRkOEt52qrU9iM-pw3DLi8UhwRsm7dO-V0g@mail.gmail.com
Whole thread Raw
Responses Re: Are the estimates made for number of pages accurate
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: S Hoffman
Date:
Subject: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Next
From: Tom Lane
Date:
Subject: Re: Are the estimates made for number of pages accurate