From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: 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 15:48:26 -0500
Message-ID: <29102.1516913306@sss.pgh.pa.us> (raw)
In-Reply-To: <20180125194720.ammwkya3dvj23rjc@alvherre.pgsql>
References: <20180125194720.ammwkya3dvj23rjc@alvherre.pgsql>
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> 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
The standard setting of default_statistics_target would only result in
trying to acquire a 30000-row sample, so the problem here is having
cranked that up beyond what the machine can sustain. AFAIR we do not
consider maintenance_work_mem as imposing a limit on the sample size.
regards, tom lane
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: tgl@sss.pgh.pa.us, 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: <29102.1516913306@sss.pgh.pa.us>
* 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