Re: 16-bit page checksums for 9.2

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: 16-bit page checksums for 9.2
Дата
Msg-id 201201061136.08476.andres@anarazel.de
обсуждение исходный текст
Ответ на Re: 16-bit page checksums for 9.2  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: 16-bit page checksums for 9.2  (Jim Nasby <jim@nasby.net>)
Список pgsql-hackers
On Friday, January 06, 2012 11:30:53 AM Simon Riggs wrote:
> On Fri, Jan 6, 2012 at 1:10 AM, Stephen Frost <sfrost@snowman.net> wrote:
> > * Simon Riggs (simon@2ndQuadrant.com) wrote:
> >> I discover that non-all-zeroes holes are fairly common, just not very
> >> frequent.
> > 
> > Curious, might be interesting to find out why.
> > 
> >> That may or may not be a problem, but not something to be dealt with
> >> here and now.
> > 
> > But I agree that it's not the job of this patch/effort.  It sounds like
> > we have clear indication, however, that those areas, as they are not
> > necessairly all zeros, should be included in the checksum.
> 
> Disagree. Full page writes ignore the hole, so its appropriate to do
> so here also.
Well, ignoriging them in fpw has clear space benefits. Ignoring them while 
checksumming doesn't have that much of a benefit.

Andres


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: 16-bit page checksums for 9.2
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: FATAL: bogus data in lock file "postmaster.pid": ""