Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Daniel Farina <daniel(at)heroku(dot)com>, "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 13:47:16
Message-ID: 500D55E4.40002@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance


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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2012-07-23 13:58:47 Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous Message Craig Ringer 2012-07-23 13:04:46 Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Dunstan 2012-07-23 13:53:25 Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Previous Message Martin French 2012-07-23 13:46:28 Re: Odd blocking (or massively latent) issue - even with EXPLAIN