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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Дата
Msg-id CAMkU=1weLk1dKC7XUv8kPWKw0FQtE25ztPZLZEXyFUXKhqP1AA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)  (David Fetter <david@fetter.org>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: enhanced error fields
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [PATCH] XLogReader v2