How to know the sizes of all tables & indexes in a database

Поиск
Список
Период
Сортировка
От Sharma;G.S.
Тема How to know the sizes of all tables & indexes in a database
Дата
Msg-id 020e01c6bb00$8e385b50$be05a8c0@ng3024
обсуждение исходный текст
Ответы Re: How to know the sizes of all tables & indexes in a database  (adey <adey11@gmail.com>)
Список pgsql-admin
Hi,
Postgres 7.3
Is there any way to know the size taken up by each table and indexes in postgres .
I am having a 53 GB database which contains tables , indexes, functions etc , how i can distribute these 53 GB's in database objects .
 
Thanks in advance
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable.

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

Предыдущее
От: "Sharma;G.S."
Дата:
Сообщение: Temporary database Size & Transaction Logs
Следующее
От: "Aaron Bono"
Дата:
Сообщение: Re: Strange UTF8 issue with pg_dump/pg_restore