wal_checksum = on (default) | off

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
wal_checksum = on (default) | off
Дата
Msg-id
1167920877.20749.105.camel@silverbirch.site
Список
Дерево обсуждения
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>
In this thread, I outlined an idea for reducing cost of WAL CRC checking
http://archives.postgresql.org/pgsql-hackers/2006-10/msg01299.php

wal_checksum = on (default) | off

Recovery can occur with/without same setting of wal_checksum, to avoid
complications from crashes immediately after turning GUC on.

Patch enclosed here against CVS HEAD, passes make check.

Useful reduction in CPU for both normal operation and recovery.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com

В списке pgsql-patches по дате отправления
От: Bill Moran
Дата:
От: Andrew Dunstan
Дата:
FAQ