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