SPACE FOR POSTGRESQL DATABASE

Started by aravind chanduover 17 years ago5 messagesgeneral
Jump to latest
#1aravind chandu
avin_friends@yahoo.com

Hello,

            Can
you please how much space does postgresql database occupies?

Thank You,

Aviansh

#2Lennin Caro
lennin.caro@yahoo.com
In reply to: aravind chandu (#1)
Re: SPACE FOR POSTGRESQL DATABASE

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:
Show quoted text

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

#3A. Kretschmer
andreas.kretschmer@schollglas.com
In reply to: aravind chandu (#1)
Re: SPACE FOR POSTGRESQL DATABASE

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

#4Scott Marlowe
scott.marlowe@gmail.com
In reply to: aravind chandu (#1)
Re: SPACE FOR POSTGRESQL DATABASE

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.

#5Bruce Momjian
bruce@momjian.us
In reply to: Scott Marlowe (#4)
Re: SPACE FOR POSTGRESQL DATABASE

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. +