Postgres Pro
Downloads
Home   >   mailing lists

Re: OOM Killing on Docker while ANALYZE running - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: OOM Killing on Docker while ANALYZE running
Date
Msg-id 20180125194720.ammwkya3dvj23rjc@alvherre.pgsql
Whole thread Raw
In response to OOM Killing on Docker while ANALYZE running  (Jorge Daniel <elgaita@hotmail.com>)
Responses Re: OOM Killing on Docker while ANALYZE running  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: OOM Killing on Docker while ANALYZE running  (Jorge Daniel <elgaita@hotmail.com>)
List pgsql-admin
Tree view 
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
rowsin 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

pgsql-admin by date:

Previous
From: Jorge Daniel
Date:
Subject: OOM Killing on Docker while ANALYZE running
Next
From: Tom Lane
Date:
Subject: Re: OOM Killing on Docker while ANALYZE running