Re: [WIP] Double-write with Fast Checksums
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-01-11T23:13:20Z
Lists: pgsql-hackers
On Wed, Jan 11, 2012 at 11:07 PM, Josh Berkus <josh@agliodbs.com> wrote: > On 1/11/12 1:25 PM, Dan Scales wrote: >> And just wanted to reiterate one other benefit of double writes -- it greatly reduces the size of the WAL logs. > > Even if you're replicating? Yes, but it will increase random I/O on the standby when we replay if we don't have FPWs. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services