Re: [BUGS] BUG #14244: wrong suffix for pg_size_pretty()

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [BUGS] BUG #14244: wrong suffix for pg_size_pretty()
Дата
Msg-id CAFj8pRB-AUqz=LTxmNneeEPP1N_8MX1S3ge+MyVY5bUPr2nBQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14244: wrong suffix for pg_size_pretty()  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers


2016-08-01 20:51 GMT+02:00 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
On 7/30/16 1:18 AM, Pavel Stehule wrote:
> We talked about this issue, when I wrote function pg_size_bytes. It is
> hard to fix these functions after years of usage. The new set of
> functions can be better
>
> pg_iso_size_pretty();
> pg_iso_size_bytes();

One thing that would actually be nice for other reasons as well is a
version of pg_size_pretty() that lets you specify the output unit, say,
as a second argument.  Because sometimes you want to compare two tables
or something, and tells you one is 3GB and the other is 783MB, which
doesn't really help.  If I tell it to use 'MB' as the output unit, I
could get comparable output.

It is looks like some convert function

pg_size_to(size, unit, [others ... rounding, truncating]) returns numeric

select pg_size_to(1024*1024, 'KB')

Regards

Pavel


--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: Oddity in EXPLAIN for foreign/custom join pushdown plans
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Increasing timeout of poll_query_until for TAP tests