Re: [HACKERS] wal_checksum = on (default) | off
От
Florian Weimer
Тема
Re: [HACKERS] wal_checksum = on (default) | off
Дата
Msg-id
87k602v4xj.fsf@mid.deneb.enyo.de
Ответ на
Список
Дерево обсуждения
wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] wal_checksum = on (default) | off "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: [HACKERS] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] wal_checksum = on (default) | off "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: [HACKERS] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] wal_checksum = on (default) | off "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: [HACKERS] wal_checksum = on (default) | off Jim Nasby <decibel@decibel.org>
Re: [HACKERS] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] wal_checksum = on (default) | off "Joshua D. Drake" <jd@commandprompt.com>
Re: [HACKERS] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] wal_checksum = on (default) | off Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] wal_checksum = on (default) | off Florian Weimer <fweimer@bfk.de>
Re: [HACKERS] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] wal_checksum = on (default) | off Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: [HACKERS] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] wal_checksum = on (default) | off Florian Weimer <fw@deneb.enyo.de>
Re: [HACKERS] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] wal_checksum = on (default) | off Florian Weimer <fw@deneb.enyo.de>
Re: [HACKERS] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
* Tom Lane: > I think short burst errors are fairly likely: the kind of scenario I'm > worried about is a wild store corrupting a word of a WAL entry while > it's waiting around to be written in the WAL buffers. Ah, does this mean that each WAL entry gets its own checksum? In this case, Adler32 is indeed suboptimal because it doesn't use the full 32 bits for short inputs. It might still catch many wild stores, but the statistics are worse than for CRC32. (I had assumed that PostgreSQLs WAL checksumming was justified by the partial write issue. The wild store could easily occur with a heap page, too, and AFAIK, tuples, aren't checksummed. Which would be an interesting option, I guess.)
В списке pgsql-patches по дате отправления