Re: dbsize command

Поиск
Список
Период
Сортировка
От salman
Тема Re: dbsize command
Дата
Msg-id 485FFC1F.3040306@quietcaresystems.com
обсуждение исходный текст
Ответ на Re: dbsize command  (Brad Nicholson <bnichols@ca.afilias.info>)
Ответы Re: dbsize command
Список pgsql-general
Brad Nicholson wrote:
> On Mon, 2008-06-23 at 10:50 -0700, Reynolds, Gregory A wrote:
>> In past versions there was a contrib/dbsize command that would tell
>> you how much storage space was being taken by a table. Is that is
>> still a supported feature in 8.3, and if so what is the syntax or
>> where is the documentation on how to use it?
>
> There are a series of functions in the database core that will tell you
> this now.
>
> http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
>

This is what I use: SELECT
pg_size_pretty(pg_database_size(current_database()));

Found it a while back on pg-general.

-salman

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

Предыдущее
От: "Mike Gould"
Дата:
Сообщение: Re: Data Types
Следующее
От: "Daniel Futerman"
Дата:
Сообщение: Update Join Query