| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Daniel Farina <daniel(at)heroku(dot)com>, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, "Harold A(dot) Giménez" <harold(dot)gimenez(at)gmail(dot)com> |
| Subject: | Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation) |
| Date: | 2012-07-23 15:02:51 |
| Message-ID: | CAMkU=1weLk1dKC7XUv8kPWKw0FQtE25ztPZLZEXyFUXKhqP1AA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Mon, Jul 23, 2012 at 5:41 AM, David Fetter <david(at)fetter(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2012-07-23 15:04:14 | Re: [PATCH] XLogReader v2 |
| Previous Message | Peter Geoghegan | 2012-07-23 14:37:56 | Re: enhanced error fields |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-07-23 15:07:45 | Re: Shards + hash = forever running queries |
| Previous Message | Jim Vanns | 2012-07-23 14:47:22 | Re: Odd blocking (or massively latent) issue - even with EXPLAIN |