Skip site navigation (1) Skip section navigation (2)

Re: Database Size Limits

From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: "Q Beukes" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Database Size Limits
Date: 2006-05-18 15:18:29
Message-ID: CB0FB369FF86E248A884BCC002562BCB010C0E09@pisgsna01sxch01.ana.firstamdata.com (view raw or flat)
Thread:
Lists: pgsql-novice
 
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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)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 contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************


pgsql-novice by date

Next:From: Oscar Rodriguez FonsecaDate: 2006-05-18 15:33:19
Subject: Re: select count(*) and limit
Previous:From: Tomeh, HusamDate: 2006-05-18 15:13:58
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group