Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id EBB2323D693
	for <pgsql-hackers@postgresql.org>;
	Mon, 23 Jul 2012 10:05:17 -0300 (ADT)
Received: from mail-pb0-f46.google.com ([209.85.160.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1StIJx-0003fk-M4
	for pgsql-hackers@postgresql.org; Mon, 23 Jul 2012 13:05:16 +0000
Received: by pbbrp8 with SMTP id rp8so10861741pbb.19
	for <pgsql-hackers@postgresql.org>;
	Mon, 23 Jul 2012 06:04:54 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding
	:x-gm-message-state;
	bh=Fbl3PpdEIqBgfYaFwhcDC0d26RvtYcgvuEbxJgFvNSw=;
	b=mx+EkcLSqT2AOAiEyOF7x4uBiiAxbg8yXjhziAIRtPiROVoVHF6MfxnPFe0Y4t1fBi
	XztldaQ5XtMAtKxOg+PY/9hRHK6Oe1DnJFG92YaCVsrdwRqCfwajmmaJHVmsZwOX0Hq9
	/rAjaM0fChkbEGOQcEuzfGTmWocjzHZtccFDOUY2IeYeT+r62am5sIC43yCTsI5/8zNp
	zstb4gqX0L81+qbstIgSf+7Nu/lZ9r0J1tJ0rnU2vHqxFEF8tqWSfEQ6CcJXhwOLcbSV
	5vXkJNpY5b2ESdYDOjFSmK/NtZH1yHidTgAEZUFlOQEYw0nlsbAMf+34s9bgpkzKe9JL
	jiKw==
Received: by 10.68.217.3 with SMTP id ou3mr35190446pbc.117.1343048694780;
	Mon, 23 Jul 2012 06:04:54 -0700 (PDT)
Received: from ayaki.localdomain (124-169-186-146.dyn.iinet.net.au.
	[124.169.186.146])
	by mx.google.com with ESMTPS id iw10sm9355078pbc.55.2012.07.23.06.04.50
	(version=SSLv3 cipher=OTHER); Mon, 23 Jul 2012 06:04:53 -0700 (PDT)
Message-ID: <500D4BEE.7010205@ringerc.id.au>
Date: Mon, 23 Jul 2012 21:04:46 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:14.0) Gecko/20120717 Thunderbird/14.0
MIME-Version: 1.0
To: Andrew Dunstan <andrew@dunslane.net>
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>
In-Reply-To: <500D439C.50608@dunslane.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Gm-Message-State: 
 ALoCoQnYfPkcRi2eAE5cHepS1uBJgKWfvZt+0sjc5g9JA8UiMeYYZL7MPhPbBQKd4AQLRX81zh6Y
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201207/925
X-Sequence-Number: 211608

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.

--
Craig Ringer