Re: Add SQL function to show total block numbers in the relation

From: btkimurayuzk <btkimurayuzk(at)oss(dot)nttdata(dot)com>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add SQL function to show total block numbers in the relation
Date: 2019-11-13 01:55:36
Message-ID: eb5d9cdb1b470c687df85c3f932f66d6@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Size in block number is useless for those who doesn't understand the
> notion of block, or block size. Those who understands the notion
> should come up with the simple formula (except the annoying
> casts). Anyone can find the clue to the base values by searching the
> document in the Web with the keywords "block size" and "relation size"
> or even with "table size". (FWIW, I would even do the same for the new
> function if any...) If they need it so frequently, a user-defined
> function is easily made up.
>
> regards.

I didn't know about the existence of the user-defined function .
I fully understood , Thanks .

Regards,

Yu Kimura

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Wood 2019-11-13 02:23:33 Re: 'Invalid lp' during heap_xlog_delete
Previous Message Amit Langote 2019-11-13 01:52:52 Re: [PATCH] Do not use StdRdOptions in Access Methods