Re: Recovery inconsistencies, standby much larger than primary - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Recovery inconsistencies, standby much larger than primary
Date
Msg-id CAM-w4HNiRDNWJBZrGmCOGO_eth2yHwqjcuLZwiaf6FDTo0j1KQ@mail.gmail.com
Whole thread Raw
In response to Re: Recovery inconsistencies, standby much larger than primary  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Recovery inconsistencies, standby much larger than primary
Re: Recovery inconsistencies, standby much larger than primary
List pgsql-hackers
On Fri, Jan 31, 2014 at 3:19 PM, Andres Freund <andres@2ndquadrant.com> wrote:
>> =# select get_raw_page('data_pkey', 'main', 11073632) ;
>> ERROR:  block number 11073632 is out of range for relation "data_pkey"
>
> Isn't the page 3634978?

The page in the record is.

But the page on disk is in the 54th segment at offset 1F0C0000

So unless my arithmetic is wrong:

bc -l
ibase=16
400 * 400 * 400 / 2000 * 54 + 1F0C0000 / 2000
11073632


-- 
greg



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: inherit support for foreign tables
Next
From: Andres Freund
Date:
Subject: Re: Recovery inconsistencies, standby much larger than primary