Are the estimates made for number of pages accurate

Поиск
Список
Период
Сортировка
От Sai Sadashiva Kundurmutt
Тема Are the estimates made for number of pages accurate
Дата
Msg-id CAH6hFGLT-58qZfPQRkOEt52qrU9iM-pw3DLi8UhwRsm7dO-V0g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Are the estimates made for number of pages accurate
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: S Hoffman
Дата:
Сообщение: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Are the estimates made for number of pages accurate