Are the estimates made for number of pages accurate

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Are the estimates made for number of pages accurate
From: Sai Sadashiva Kundurmutt <saisadashiva2000@xxxxxxxxx>
Date: Sun, 25 Feb 2024 14:10:05 +0530

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

Follow-Ups:
- Re: Are the estimates made for number of pages accurate
  - From: Tom Lane

Prev by Date: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Next by Date: Re: Are the estimates made for number of pages accurate
Previous by thread: Two different database in RDS access table.
Next by thread: Re: Are the estimates made for number of pages accurate
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux