From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Jorge Daniel <elgaita@hotmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: dyuryeva@medallia.com <dyuryeva@medallia.com>
Subject: Re: OOM Killing on Docker while ANALYZE running
Date: Thu, 25 Jan 2018 16:47:20 -0300
Message-ID: <20180125194720.ammwkya3dvj23rjc@alvherre.pgsql> (raw)
In-Reply-To: <CP2P152MB03563AA07394B591FD640158BCE10@CP2P152MB0356.LAMP152.PROD.OUTLOOK.COM>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@alvh.no-ip.org, elgaita@hotmail.com, pgsql-admin@lists.postgresql.org, dyuryeva@medallia.com
Subject: Re: OOM Killing on Docker while ANALYZE running
In-Reply-To: <20180125194720.ammwkya3dvj23rjc@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox