Re: Add SQL function to show total block numbers in the relation - Mailing list pgsql-hackers

btkimurayuzk <[email protected]> writes:
> I propose new simple sql query, which shows total block numbers in the 
> relation.
> ...
> Of cource, we can know this value such as
> select (pg_relation_size('t') / 
> current_setting('block_size')::bigint)::int;

I don't really see why the existing solution isn't sufficient.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Binary support for pgoutput plugin
Next
From: Tom Lane
Date:
Subject: Re: Proposal: Global Index