Re: Block-level CRC checks - Mailing list pgsql-hackers

From Massa, Harald Armin
Subject Re: Block-level CRC checks
Date
Msg-id e3e180dc0912040151x4b6e60d2p85efdc0dc0eb1cb9@mail.gmail.com
Whole thread Raw
In response to Re: Block-level CRC checks  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Block-level CRC checks  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Kevin,

> md5sum of each tuple?  As an optional system column (a la oid)?

I am mainly an application programmer working with PostgreSQL. And I
want to point out an additional usefullness of an md5sum of each
tuple: it makes comparing table-contents in replicated / related
databases MUCH more feasible.

I am in the process of adding a user-space "myhash" column to all my
applications tables, filled by a trigger on insert / update. It really
speeds up table comparison across databases; and it is very helpfull
in debugging replications.

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Block-level CRC checks
Next
From: Andrew Gierth
Date:
Subject: Re: [GENERAL] Installing PL/pgSQL by default