Jorge Daniel wrote: > Hi guys , I'm dealing with OOM killing on Postgresql 9.4.8 running on docker , What is your statistics target? analyze is supposed to acquire samples of the data, not the whole table ... > pgbench=# analyze verbose pgbench_accounts; > INFO: analyzing "public.pgbench_accounts" > INFO: "pgbench_accounts": scanned 1639345 of 1639345 pages, containing 100000000 live rows and 0 dead rows; 3000000 rows in sample, 100000000 estimated total rows Here it seems to be saying that it reads all 1.6 million pages ... -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
