On Fri, Jan 31, 2014 at 3:41 PM, Tom Lane <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
