Postgres Pro
Downloads
Home   >   mailing lists

Thread: SPACE FOR POSTGRESQL DATABASE

SPACE FOR POSTGRESQL DATABASE

From
aravind chandu
Date:
Hello,

            Can you please how much space does postgresql database occupies?

Thank You,
Aviansh

Re: SPACE FOR POSTGRESQL DATABASE

From
Lennin Caro
Date:
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 <avin_friends@yahoo.com> wrote:

> From: aravind chandu <avin_friends@yahoo.com>
> 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

Re: SPACE FOR POSTGRESQL DATABASE

From
"A. Kretschmer"
Date:
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

Re: SPACE FOR POSTGRESQL DATABASE

From
"Scott Marlowe"
Date:
On Thu, Jul 10, 2008 at 8:18 AM, aravind chandu <avin_friends@yahoo.com> 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.

Re: SPACE FOR POSTGRESQL DATABASE

From
Bruce Momjian
Date:
Scott Marlowe wrote:
> On Thu, Jul 10, 2008 at 8:18 AM, aravind chandu <avin_friends@yahoo.com> 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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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