[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 обсуждение исходный текст |
Ответы |
Re: [GENERAL] vacuumdb --analyze-only scans all pages?
|
Список | pgsql-general |
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 по дате отправления: