Content-Type: text/plain; charset=UTF-8
Cc: Nick <t32@2thebatcave.com>, Kevin Grittner <kevin.grittner@wicourts.gov>,
	pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: autovacuum launcher process eating up 17G+ of ram?
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
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>
Date: Mon, 08 Nov 2010 19:09:31 -0300
Message-Id: <1289253773-sup-7048@alvh.no-ip.org>
User-Agent: Sup/git
Content-Transfer-Encoding: 8bit

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