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

On Fri, Jan 31, 2014 at 3:41 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 400 * 400 * 400 / 2000 * 54 + 1F0C0000 / 2000
>> 11073632

Ooops, it's reading 54 in hex there.
> # select ((2^30) * 54.0 + 'x1F0C0000'::bit(32)::int) / 8192;
>  ?column?
> ----------
>   7141472

ibase=16
400 * 400 * 400 / 2000 * 36 + 1F0C0000 / 2000
7141472.00000000000000000000

So now that I've got the arithmetic right:

=# select (page_header(get_raw_page('index_data_id', 'main', 7141472))).* ;   lsn     | tli | flags | lower | upper |
special| pagesize |
 
version | prune_xid
------------+-----+-------+-------+-------+---------+----------+---------+-----------EA1/638988 |   6 |     0 |  1240 |
3312 |    8176 |     8192 |
 
4 |         0


-- 
greg