I have been looking for such a function. Having Just upgraded to 8.2,
this function is a very welcome addition to my arsenal of tools.
Many thanks!
- Naz.
Reece Hart wrote:
On Sun, 2007-03-18 at 00:40 +0530, Mageshwaran wrote:
how to find the size of a particular database in postg
On Sun, 2007-03-18 at 00:40 +0530, Mageshwaran wrote:
> how to find the size of a particular database in postgres...
The old way was to use du or similar. Recent versions (I believe >=8.1,
but check the release notes to be sure) provide several useful functions
for this:
pg_column_size
pg_databa
For small and moderate size databases, I find that the simplest way to
estimate the database size is to do:
du -ks /var/lib/postgresql/data
...create a new database, restore a backup of the database in whose
size you're interested in
du -ks /var/lib/postgresql/data
Compare the first and second "
Mageshwaran schrieb:
Hi all,
how to find the size of a particular database in postgres...
You look there:
http://www.postgresql.org/docs/8.2/static/storage-file-layout.html
and use OS commands to calculate space used on disk (e.g. du)
please do reply
Well, thats a mailinglist, why would
Hi all,
how to find the size of a particular database in postgres...
please do reply
Regards
J Mageshwaran
DBA
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
w
