Horton

Re: 16-bit page checksums for 9.2

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, david@fetter.org, andres@anarazel.de, aidan@highrise.ca, stark@mit.edu, pgsql-hackers@postgresql.org
Date: 2012-01-06T19:45:45Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Wakeup WALWriter as needed for asynchronous commit performance.

On 06.01.2012 20:26, Simon Riggs wrote:
> The following patch (v4) introduces a new WAL record type that writes
> backup blocks for the first hint on a block in any checkpoint that has
> not previously been changed. IMHO this fixes the torn page problem
> correctly, though at some additional loss of performance but not the
> total catastrophe some people had imagined. Specifically we don't need
> to log anywhere near 100% of hint bit settings, much more like 20-30%
> (estimated not measured).

How's that going to work during recovery? Like in hot standby.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com