Skip site navigation (1) Skip section navigation (2)

Re: 16-bit page checksums for 9.2

From: David Fetter <david(at)fetter(dot)org>
To: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Noah Misch <noah(at)leadboat(dot)com>,Simon Riggs <simon(at)2ndquadrant(dot)com>,Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,Andres Freund <andres(at)anarazel(dot)de>,Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, aidan(at)highrise(dot)ca,stark(at)mit(dot)edu, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: 16-bit page checksums for 9.2
Date: 2012-02-22 23:51:00
Message-ID: 20120222235100.GB10850@fetter.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Feb 22, 2012 at 11:17:53PM +0000, Peter Geoghegan wrote:
> I decided that it would be worth benchmarking this patch.
> Specifically, I tested:
> 
> master, as a basis of comparison
> 
> checksum16_with_wallogged_hint_bits.v10.patch, page_checksums = 'on'
> 
> checksum16_with_wallogged_hint_bits.v10.patch, page_checksums = 'off'
> 
> This test was performed using pgbench-tools. At different client
> counts and scaling factors "1,10,100", performance of an update.sql
> workload was tested.

Looks interesting.  Could you get some error bars around the numbers
plotted, and possibly some scaling factors between 10 and 100?

For the former, I'm looking for whether those changes are within
ordinary variation, and in the latter, some better idea of what the
curve looks like.

Cheers,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

pgsql-hackers by date

Next:From: Affan SalmanDate: 2012-02-23 00:26:43
Subject: Commit a445cb92 not tested without OpenSSL support?
Previous:From: Bruce MomjianDate: 2012-02-22 23:40:25
Subject: Re: pg_upgrade --logfile option documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group