Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id EB6D923D694
	for <pgsql-hackers@postgresql.org>;
	Mon, 23 Jul 2012 10:47:45 -0300 (ADT)
Received: from relay4-d.mail.gandi.net ([217.70.183.196])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <andrew@dunslane.net>) id 1StIzA-00030F-Us
	for pgsql-hackers@postgresql.org; Mon, 23 Jul 2012 13:47:45 +0000
X-Originating-IP: 217.70.178.146
Received: from mfilter18-d.gandi.net (mfilter18-d.gandi.net [217.70.178.146])
	by relay4-d.mail.gandi.net (Postfix) with ESMTP id 67E5C1720B4;
	Mon, 23 Jul 2012 15:47:21 +0200 (CEST)
X-Virus-Scanned: Debian amavisd-new at mfilter18-d.gandi.net
Received: from relay4-d.mail.gandi.net ([217.70.183.196])
	by mfilter18-d.gandi.net (mfilter18-d.gandi.net [10.0.15.180])
	(amavisd-new, port 10024)
	with ESMTP id uyKRjwRsoQuO; Mon, 23 Jul 2012 15:47:19 +0200 (CEST)
X-Originating-IP: 98.27.54.176
Received: from [192.168.10.146] (cpe-098-027-054-176.nc.res.rr.com
	[98.27.54.176]) (Authenticated sender: adsend@dunslane.net)
	by relay4-d.mail.gandi.net (Postfix) with ESMTPSA id 03A99172090;
	Mon, 23 Jul 2012 15:47:17 +0200 (CEST)
Message-ID: <500D55E4.40002@dunslane.net>
Date: Mon, 23 Jul 2012 09:47:16 -0400
From: Andrew Dunstan <andrew@dunslane.net>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: Craig Ringer <ringerc@ringerc.id.au>
CC: David Fetter <david@fetter.org>, Tom Lane <tgl@sss.pgh.pa.us>,
	Robert Haas <robertmhaas@gmail.com>, Jeff Janes <jeff.janes@gmail.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>,
	Daniel Farina <daniel@heroku.com>, =?ISO-8859-1?Q?=22Harold_A=2E_Gim?=
	=?ISO-8859-1?Q?=E9nez=22?= <harold.gimenez@gmail.com>
Subject: Re: Checkpointer split has broken things dramatically (was
	Re: DELETE vs TRUNCATE explanation)
References: 
 <CA+TgmoaTf=zjP37-oG7fr1VbGfuvHSfpajgLZ65EeSJX2mmquA@mail.gmail.com>
	<9603.1342454919@sss.pgh.pa.us>
	<CA+Tgmoa4ta60Y-rZpEPDRCQKJV8-Uqe0P610Jgj2q7e+fondig@mail.gmail.com>
	<11952.1342456591@sss.pgh.pa.us>
	<CA+TgmoYRXMWQ_DGmmqu3Zp8oW3Lt-9Lc1q3EHaV_ZmjWqaPkuA@mail.gmail.com>
	<13011.1342457859@sss.pgh.pa.us>
	<CA+TgmoaEPLo5fmBX1JSkGK3umAamFVghwY7qDb4_QqzteZgUPA@mail.gmail.com>
	<15955.1342466333@sss.pgh.pa.us>
	<CA+TgmoYnqP!f03rYJo3G6dMrqShQF2iMtfpYBPgWdxtEdacaX-w@mail.gmail.com>
	<9247.1342565810@sss.pgh.pa.us> <20120723043733.GA13020@fetter.org>
	<500D439C.50608@dunslane.net> <500D4BEE.7010205@ringerc.id.au>
In-Reply-To: <500D4BEE.7010205@ringerc.id.au>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201207/926
X-Sequence-Number: 211609


On 07/23/2012 09:04 AM, Craig Ringer wrote:
> On 07/23/2012 08:29 PM, Andrew Dunstan wrote:
>
>> I'm not sure how you automate testing a pull-the-plug scenario.
>
> fire up kvm or qemu instances, then kill 'em.
>
>

Yeah, maybe. Knowing just when to kill them might be an interesting 
question.

I'm also unsure how much nice cleanup the host supervisor does in such 
cases. VMs are wonderful things, but they aren't always the answer. I'm 
not saying they aren't here, just wondering.

cheers

andrew