From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Nick <t32@2thebatcave.com>
Cc: Kevin Grittner <kevin.grittner@wicourts.gov>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: autovacuum launcher process eating up 17G+ of ram?
Date: Mon, 08 Nov 2010 19:09:31 -0300
Message-ID: <1289253773-sup-7048@alvh.no-ip.org> (raw)
In-Reply-To: <24906.1289229302@sss.pgh.pa.us>
References: <AANLkTimGvWugpjwN1Ki=qmd56nsc4gXH6yKT5765nFPK@mail.gmail.com>
<4CC071670200002500036C8A@gw.wicourts.gov>
<AANLkTimKs23hytr6oj1Kco53rbaPF2mKTZZYofr0Cr0+@mail.gmail.com>
<4CC18EF60200002500036CF3@gw.wicourts.gov>
<AANLkTi=Mh=pv7Ai+L17cbjgsExMbncHG5fMTvj5_wCAe@mail.gmail.com>
<4232.1288036630@sss.pgh.pa.us>
<1289227352-sup-6579@alvh.no-ip.org>
<24906.1289229302@sss.pgh.pa.us>
Excerpts from Tom Lane's message of lun nov 08 12:15:02 -0300 2010:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Patch for this is attached (applies cleanly to 9.0 and HEAD; 8.4 doesn't
> > need to be patched, but I'll run the test case now just to be sure.)
>
> Possibly s/cxt/resultcxt/, or some other less-generic name. Seems
> pretty sane other than that cosmetic issue.
Thanks, committed that way and pushed. I verified that 8.4 doesn't have
this problem.
Oops, I just noticed that I forgot to credit everyone for the report and
diagnosis in the commit message. Too late to fix :-(
So: thanks Nick for the report and Tom for the diagnosis.
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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@commandprompt.com, tgl@sss.pgh.pa.us, t32@2thebatcave.com, kevin.grittner@wicourts.gov
Subject: Re: autovacuum launcher process eating up 17G+ of ram?
In-Reply-To: <1289253773-sup-7048@alvh.no-ip.org>
* 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