Re: how to know the current size of a database
| От | Farhan Mughal |
|---|---|
| Тема | Re: how to know the current size of a database |
| Дата | |
| Msg-id | 271649.58727.qm@web26309.mail.ukl.yahoo.com обсуждение |
| Ответ на | how to know the current size of a database (son@raider.co.nz) |
| Список | pgsql-general |
>>I want to know about the size of my database. For example, I want to know
>>how many Mb of data for current myDatabase database in a postgres server.
>>How I can do that?
Try the following query:
select pg_size_pretty(pg_database_size('<DATABASE NAME>'));
--Farhan
----- Original Message ----
From: "son@raider.co.nz" <son@raider.co.nz>
To: pgsql-general@postgresql.org
Sent: Wednesday, 19 September, 2007 3:36:02 PM
Subject: [GENERAL] how to know the current size of a database
From: "son@raider.co.nz" <son@raider.co.nz>
To: pgsql-general@postgresql.org
Sent: Wednesday, 19 September, 2007 3:36:02 PM
Subject: [GENERAL] how to know the current size of a database
Hello
I want to know about the size of my database. For example, I want to know
how many Mb of data for current myDatabase database in a postgres server.
How I can do that?
Thanks
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
I want to know about the size of my database. For example, I want to know
how many Mb of data for current myDatabase database in a postgres server.
How I can do that?
Thanks
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Yahoo! Answers - Get better answers from someone who knows. Try it now.
В списке pgsql-general по дате отправления: