dbTalk Databases Forums  

Disk usage

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Disk usage in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Hampl
 
Posts: n/a

Default Disk usage - 01-06-2004 , 05:37 AM






Hi,

I really don't understand the part of the docmentation about
determining the disk usage of a database (section 24.1).

The bit that puzzles me is:

"contrib/dbsize loads functions into your database that allow you to
find the size of a table or database from inside psqlwithout the need
for VACUUM or ANALYZE.

You can also use contrib/oid2name to show disk usage. See
README.oid2name in that directory for examples. It includes a script
that shows disk usage for each database."

What is contrib? I am shure it's a directory, but where is it?

Thanks,
Martin.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


Reply With Quote
  #2  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: Disk usage - 01-06-2004 , 11:56 AM






Martin Hampl wrote:
Quote:
Hi,

I really don't understand the part of the docmentation about
determining the disk usage of a database (section 24.1).

The bit that puzzles me is:

"contrib/dbsize loads functions into your database that allow you to
find the size of a table or database from inside psqlwithout the need
for VACUUM or ANALYZE.

You can also use contrib/oid2name to show disk usage. See
README.oid2name in that directory for examples. It includes a script
that shows disk usage for each database."

What is contrib? I am shure it's a directory, but where is it?
In the source tree under /pgsql/contrib/oid2name.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.