Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: Page Checksums + Double Writes
Date
Msg-id 4F045BD90200002500044391@gw.wicourts.gov
Whole thread Raw
In response to Re: Page Checksums + Double Writes  (Jim Nasby <jim@nasby.net>)
Responses Re: Page Checksums + Double Writes  (Robert Haas <robertmhaas@gmail.com>)
Re: Page Checksums + Double Writes  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
Tree view 
Jim Nasby <jim@nasby.net> wrote:
> Here's output from our largest OLTP system... not sure exactly how
> to interpret it, so I'm just providing the raw data. This spans
> almost exactly 1 month.
Those number wind up meaning that 18% of the 256-byte blocks (1024
transactions each) were all commits.  Yikes.  That pretty much
shoots down Robert's idea of summarized CLOG data, I think.
-Kevin

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Setting -Werror in CFLAGS
Next
From: Robert Haas
Date:
Subject: Re: 16-bit page checksums for 9.2