To find out the size of a particular postgres database, use the system
function: pg_database_size(db_name). The function returns the db size
in bytes.
For example: select pg_database_size('mydb') ;
I don't believe user quota is implemented in postgres yet to
restrict/control user usage of tablespace.
----
Husam
http://firstdba.googlepages.com
----
Husam Tomeh
Sr. DBA , Database Management & Infrastructure
First American Corporation - RES
Direct: 714.250-6643
Fax: 714.250-6928
2 MacArthur Place, Tower 2, 5Th Floor.
Santa Ana, CA 92707
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Q Beukes
Sent: Wednesday, May 17, 2006 1:01 AM
To: Postgresql Novice
Subject: [NOVICE] Database Size Limits
Hey,
How can I determine and limit the size of a database.
If I can determine it only through sql, how can I prevent a user from
further inserting data.
regards
Q Beukes
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may
containinformation that is legally privileged. If you are not the addressee, or the person responsible for delivering
itto the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is
strictlyprohibited. If you have received this message by mistake, please immediately notify us by replying to the
messageand delete the original message immediately thereafter.
Thank you.
FADLD Tag
**********************************************************************