Re: [GENERAL] SPACE FOR POSTGRESQL DATABASE

2008-07-14 Thread Bruce Momjian
Scott Marlowe wrote:
 On Thu, Jul 10, 2008 at 8:18 AM, aravind chandu [EMAIL PROTECTED] wrote:
  Hello,
 
  Can you please how much space does postgresql database occupies?
 
 A good rule of thumb is that it will take about 1.5 times as much
 space in the db as it does in a flat file.  that's just an
 approximation.  The actual size of each type etc is defined in the
 other links in this thread.

Folks, we have an FAQ about this:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.5

-- 
  Bruce Momjian  [EMAIL PROTECTED]http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] SPACE FOR POSTGRESQL DATABASE

2008-07-10 Thread aravind chandu
Hello,



    Can
you please how much space does postgresql database occupies?



Thank You,

Aviansh




  

Re: [GENERAL] SPACE FOR POSTGRESQL DATABASE

2008-07-10 Thread Lennin Caro
in this link have information about database size

http://www.postgresql.org/docs/8.1/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE


--- On Thu, 7/10/08, aravind chandu [EMAIL PROTECTED] wrote:

 From: aravind chandu [EMAIL PROTECTED]
 Subject: [GENERAL] SPACE FOR POSTGRESQL DATABASE
 To: postgresql Forums pgsql-general@postgresql.org
 Date: Thursday, July 10, 2008, 2:18 PM
 Hello,
 
 
 
 Can
 you please how much space does postgresql database
 occupies?
 
 
 
 Thank You,
 
 Aviansh


  


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] SPACE FOR POSTGRESQL DATABASE

2008-07-10 Thread A. Kretschmer
am  Thu, dem 10.07.2008, um  7:18:39 -0700 mailte aravind chandu folgendes:
 Hello,
 
 Can you please how much space does postgresql database occupies?
 
 Thank You,

Depends on the amount of data stored in the database.


Regards, Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: - Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] SPACE FOR POSTGRESQL DATABASE

2008-07-10 Thread Scott Marlowe
On Thu, Jul 10, 2008 at 8:18 AM, aravind chandu [EMAIL PROTECTED] wrote:
 Hello,

 Can you please how much space does postgresql database occupies?

A good rule of thumb is that it will take about 1.5 times as much
space in the db as it does in a flat file.  that's just an
approximation.  The actual size of each type etc is defined in the
other links in this thread.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general