Add SQL function to show total block numbers in the relation

Поиск
Список
Период
Сортировка
От btkimurayuzk
Тема Add SQL function to show total block numbers in the relation
Дата
Msg-id 00d0b21ebbd42f22e118fe9afa47713e@oss.nttdata.com
обсуждение исходный текст
Ответы Re: Add SQL function to show total block numbers in the relation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello,


I propose new simple sql query, which shows total block numbers in the 
relation.

I now reviewing this patch (https://commitfest.postgresql.org/25/2211/) 
and I think,
it is usefull for knowing how many blocks there are in the relation to 
determine whether we use VACUUM RESUME or not.

Of cource, we can know this value such as

select (pg_relation_size('t') / 
current_setting('block_size')::bigint)::int;


but I think it is a litte bit complex.



Comment and feedback are very welcome.

Regards ,


Yu Kimura
Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: RFC: split OBJS lines to one object per line
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions