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

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
Re: [PATCHES] wal_checksum = on (default) | off
Дата
Msg-id
1168527292.3951.545.camel@silverbirch.site
Ответ на
Список
Дерево обсуждения
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
Re: [PATCHES] wal_checksum = on (default) | off Jim Nasby <decibel@decibel.org>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off "Joshua D. Drake" <jd@commandprompt.com>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off Bruce Momjian <bruce@momjian.us>
Re: [PATCHES] wal_checksum = on (default) | off Bruce Momjian <bruce@momjian.us>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off Gregory Stark <stark@enterprisedb.com>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off Martijn van Oosterhout <kleptog@svana.org>
Re: [PATCHES] wal_checksum = on (default) | off Florian Weimer <fweimer@bfk.de>
Re: [PATCHES] wal_checksum = on (default) | off "Simon Riggs" <simon@2ndquadrant.com>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off Florian Weimer <fw@deneb.enyo.de>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] wal_checksum = on (default) | off Florian Weimer <fw@deneb.enyo.de>
Re: [PATCHES] wal_checksum = on (default) | off Tom Lane <tgl@sss.pgh.pa.us>
On Thu, 2007-01-11 at 09:01 -0500, Tom Lane wrote:
> "Simon Riggs"  writes:
> > COPY		XLogInsert() #1 on oprofile results at 17% CPU
> > 		(full_page_writes = on)
> 
> But what portion of that is actually CRC-related?  XLogInsert does quite
> a lot.
> 
> Anyway, I can't see degrading the reliability of the system for a gain
> in the range of a few percent, which is the most that we'd be likely
> to get here ... for a factor of two or more, maybe people would be
> willing to take a risk.

All I would add is that the loss of reliability was not certain in all
cases, otherwise I myself would have dropped the idea long ago. With the
spectre of doubt surrounding this, I'm happy to drop the idea until we
have proof/greater certainty either way.

Patch revoked.

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


В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
Сообщение: contrib/xml2 and xml type
От: Gregory Stark
Дата:
FAQ