Re: Redo record at high number

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
Cc: Jeff Boes <jboes(at)nexcerpt(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Redo record at high number
Date: 2001-10-05 19:44:01
Message-ID: 21845.1002311041@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> writes:
>> Looks fishy to me too --- the offset shouldn't exceed 24 bits AFAIR.

> Log record ptr is 4 bytes for log file ID and 4 bytes for record offset.
> # of segmets in log file (2^32 - 1) / 2^24 = 255
> Max offset *in segment* is 2^24 , but max offset *in log file*
> is 255 * 2^24 = 4278190080

You're right, I'm wrong, it's a false alarm. Sorry for the noise.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2001-10-05 21:11:51 Re: Slightly off topic - Hardware Question
Previous Message Mikheev, Vadim 2001-10-05 19:38:30 Re: Redo record at high number