Re: dbsize contrib
От | Bruce Momjian |
---|---|
Тема | Re: dbsize contrib |
Дата | |
Msg-id | 200409020055.i820tZg04676@candle.pha.pa.us обсуждение исходный текст |
Ответ на | dbsize contrib (Andreas Pflug <pgadmin@pse-consulting.de>) |
Ответы |
Re: dbsize contrib
|
Список | pgsql-patches |
Patch applied. Thanks. Can I get some documentation in the README for all the new functionality. --------------------------------------------------------------------------- Andreas Pflug wrote: > The current implementation of dbsize doesn't handle tables in > tablespaces correctly, and is quite restricted on objects covered (only > tables and databases, but not tablespaces and indexes). > > The attached patch contributes: > > - database_size(name) > - relation_size(text) > These are the well-known functions, tablespace-aware. > > - pg_tablespace_size(oid) > - pg_database_size(oid) > - pg_relation_size(oid) > Tablespace-aware implementations, used by the upper functions. > pg_relation_size will report sizes of indexes as well. > > - pg_size_pretty(bigint) > Formatting of sizes, to display '146MB' instead of '152885668' > > Regards, > Andreas > > > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-patches по дате отправления: