Re: Recovery inconsistencies, standby much larger than primary

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Recovery inconsistencies, standby much larger than primary
Дата
Msg-id CAM-w4HNiRDNWJBZrGmCOGO_eth2yHwqjcuLZwiaf6FDTo0j1KQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recovery inconsistencies, standby much larger than primary  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: Recovery inconsistencies, standby much larger than primary  (Andres Freund <andres@2ndquadrant.com>)
Re: Recovery inconsistencies, standby much larger than primary  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: inherit support for foreign tables
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Recovery inconsistencies, standby much larger than primary