Re: Page Checksums + Double Writes - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Page Checksums + Double Writes
Date
Msg-id 828vm5f14e.fsf@mid.bfk.de
Whole thread Raw
In response to Page Checksums + Double Writes  (David Fetter <david@fetter.org>)
Responses Re: Page Checksums + Double Writes  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Page Checksums + Double Writes  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-hackers
* David Fetter:

> The issue is that double writes needs a checksum to work by itself,
> and page checksums more broadly work better when there are double
> writes, obviating the need to have full_page_writes on.

How desirable is it to disable full_page_writes?  Doesn't it cut down
recovery time significantly because it avoids read-modify-write cycles
with a cold cache?

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99


pgsql-hackers by date:

Previous
From: Leonardo Francalanci
Date:
Subject: Re: Page Checksums
Next
From: Benedikt Grundmann
Date:
Subject: Re: Real-life range datasets