Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation) - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Date
Msg-id CAMkU=1weLk1dKC7XUv8kPWKw0FQtE25ztPZLZEXyFUXKhqP1AA@mail.gmail.com
Whole thread Raw
In response to Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)  (David Fetter <david@fetter.org>)
List pgsql-hackers
On Mon, Jul 23, 2012 at 5:41 AM, David Fetter <david@fetter.org> wrote:
> On Mon, Jul 23, 2012 at 08:29:16AM -0400, Andrew Dunstan wrote:
>>
>>
>> I'm not sure how you automate testing a pull-the-plug scenario.
>
> I have a dim memory of how the FreeBSD project was alleged to have
> done it, namely by rigging a serial port (yes, it was that long ago)
> to the power supply of another machine and randomly cycling the power.

On Linux,

echo b > /proc/sysrq-trigger

Is supposed to take it down instantly, with no flushing of dirty buffers.

Cheers,

Jeff


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: enhanced error fields
Next
From: Andres Freund
Date:
Subject: Re: [PATCH] XLogReader v2