On Fri, Jan 31, 2014 at 3:41 PM, Tom Lane <t...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers