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

Re: [HACKERS] wal_checksum = on (default) | off

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: pgsql-patches(at)postgreSQL(dot)org
Subject: Re: [HACKERS] wal_checksum = on (default) | off
Date: 2007-01-04 19:43:11
Message-ID: 24772.1167939791@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> Quoting wikipedia:
> "Adler-32 has a weakness for short messages with few hundred bytes,
>  because the checksums for these messages have a poor coverage of
>  the 32 available bits...Jonathan Stone discovered in 2001 that Adler-32
>  has a weakness...An extended explanation can be found in RFC 3309,
>  which mandates the use of CRC32 instead of Adler-32...."

[ looks at the RFC... ]  Yeah, so that pretty much kills it for WAL
entries, which are mostly short.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Florian WeimerDate: 2007-01-04 20:16:02
Subject: Re: [HACKERS] wal_checksum = on (default) | off
Previous:From: markwkmDate: 2007-01-04 19:38:01
Subject: ideas for auto-processing patches

pgsql-patches by date

Next:From: Florian WeimerDate: 2007-01-04 20:16:02
Subject: Re: [HACKERS] wal_checksum = on (default) | off
Previous:From: Ron MayerDate: 2007-01-04 19:18:12
Subject: Re: [HACKERS] wal_checksum = on (default) | off

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