[GENERAL] vacuumdb --analyze-only scans all pages?

Поиск
Список
Период
Сортировка
Искать
От
Gerhard Wiesinger
Тема
[GENERAL] vacuumdb --analyze-only scans all pages?
Дата
Msg-id
259d15b6-455a-4078-5a64-6560f04ae494@wiesinger.com
Список
Дерево обсуждения
[GENERAL] vacuumdb --analyze-only scans all pages? Gerhard Wiesinger <lists@wiesinger.com>
Re: [GENERAL] vacuumdb --analyze-only scans all pages? Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] vacuumdb --analyze-only scans all pages? Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] vacuumdb --analyze-only scans all pages? Gerhard Wiesinger <lists@wiesinger.com>
Hello,

PostgreSQl  9.6.1: after a pg_dump/restore procedure it scans all pages 
(at least for some of the tables, analyze-only switch is specified).

I would expect that only the sample rows are scanned.

"log_details": scanned 2133350 of 2133350 pages

vacuumdb --analyze-only --all --verbose
INFO:  analyzing "public.log"
INFO:  "log": scanned 30000 of 30851 pages, containing 3599899 live rows 
and 0 dead rows; 30000 rows in sample, 3702016 estimated total rows
INFO:  analyzing "public.log_details"
INFO:  "log_details": scanned 2133350 of 2133350 pages, containing 
334935843 live rows and 0 dead rows; 3000000 rows in sample, 334935843 
estimated total rows
INFO:  analyzing "public.log_details_str"
INFO:  "log_details_str": scanned 30000 of 521126 pages, containing 
3601451 live rows and 0 dead rows; 30000 rows in sample, 62560215 
estimated total rows

Any ideas why?

Thnx.

Ciao,

Gerhard


В списке pgsql-general по дате отправления
От: Clifford Snow
Дата:
От: Tim Uckun
Дата:
FAQ