Re: SPACE FOR POSTGRESQL DATABASE - Mailing list pgsql-general

From Bruce Momjian
Subject Re: SPACE FOR POSTGRESQL DATABASE
Date
Msg-id 200807142021.m6EKL0301249@momjian.us
Whole thread Raw
In response to Re: SPACE FOR POSTGRESQL DATABASE  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
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. +

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: optimizer ignoring primary key and doing sequence scan
Next
From: "Mason Hale"
Date:
Subject: vacuum taking an unusually long time