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

Поиск
Список
Период
Сортировка
От btkimurayuzk
Тема Re: Add SQL function to show total block numbers in the relation
Дата
Msg-id 7369fa1cc4d212cbcbd2cdbd6031f0c0@oss.nttdata.com
обсуждение исходный текст
Ответ на Re: Add SQL function to show total block numbers in the relation  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Add SQL function to show total block numbers in the relation  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список 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.

I think it's a little difficult to introduce the block size using two 
values `current block size` and `reference size`
for beginners who are not familiar with the internal structure of 
Postgres,

This is the reason why the existing solution was insufficient.

What do you think?

Regards,
Yu Kimura



В списке pgsql-hackers по дате отправления:

Предыдущее
От: btkimurayuzk
Дата:
Сообщение: Re: pgbench - extend initialization phase control
Следующее
От: Gilles Darold
Дата:
Сообщение: Re: [PATCH][DOC] Fix for PREPARE TRANSACTION doc and postgres_fdwmessage.