Re: Sync Rep v17

Greg Smith <greg@2ndquadrant.com>

From: Greg Smith <greg@2ndquadrant.com>
To: Daniel Farina <daniel@heroku.com>
Cc: Tatsuo Ishii <ishii@postgresql.org>, simon@2ndquadrant.com, heikki.linnakangas@enterprisedb.com, pgsql-hackers@postgresql.org
Date: 2011-02-22T13:04:08Z
Lists: pgsql-hackers
Daniel Farina wrote:
> As it will be somewhat hard to prove the durability guarantees of
> commit without special heroics, unless someone can suggest a
> mechanism.

Could you introduce a hack creating deterministic server side crashes in 
order to test this out?  The simplest thing that comes to mind is a rule 
like "kick shared memory in the teeth to force a crash after every 100 
commits", then see if #100 shows up as expected.  Pick two different 
small numbers for the interval and you could probably put that on both 
sides to simulate all sorts of badness.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books