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

From Tom Lane
Subject Re: Add SQL function to show total block numbers in the relation
Date
Msg-id 19282.1572444587@sss.pgh.pa.us
Whole thread Raw
In response to Add SQL function to show total block numbers in the relation  (btkimurayuzk <btkimurayuzk@oss.nttdata.com>)
Responses Re: Add SQL function to show total block numbers in the relation
Re: Add SQL function to show total block numbers in the relation
List pgsql-hackers
btkimurayuzk <btkimurayuzk@oss.nttdata.com> 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