Re: xlog location arithmetic - Mailing list pgsql-hackers

From Tom Lane
Subject Re: xlog location arithmetic
Date
Msg-id 28804.1331304909@sss.pgh.pa.us
Whole thread Raw
In response to Re: xlog location arithmetic  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: xlog location arithmetic
List pgsql-hackers
I wrote:
> Fujii Masao <masao.fujii@gmail.com> writes:
>> Euler proposed one more patch upthread, which replaces pg_size_pretty(bigint)
>> with pg_size_pretty(numeric) so that pg_size_pretty(pg_xlog_location_diff())
>> succeeds. It's also worth committing this patch?

> Why would it be useful to use pg_size_pretty on xlog locations?
> -1 because of the large expense of bigint->numeric->whatever conversion
> that would be added to existing uses.

Actually ... now that I look at it, isn't it completely bogus to be
using numeric for the result of pg_xlog_location_diff?  There's no way
for the difference of two xlog locations to be anywhere near as wide as
64 bits.  That'd only be possible if XLogFileSize exceeded 1GB, which we
don't let it get anywhere near.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: logging in high performance systems.
Next
From: Tom Lane
Date:
Subject: Re: xlog location arithmetic