Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: > On 12/28/2016 11:54 PM, Gerhard Wiesinger wrote: >> 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? > I would say because the '3000000 rows in sample' where spread out over > all 2133350 pages. Worth pointing out here is that you must have a custom statistics target set on log_details to make it want a sample so much larger than the default. If you feel ANALYZE is taking too long, you should reconsider whether you need such a large target. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
