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

Re: [Admin]To estimate the size of db

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Duan Ligong" <l-duan(at)zd(dot)cnes(dot)jp(dot)nec(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [Admin]To estimate the size of db
Date: 2008-05-21 19:08:29
Message-ID: dcc563d10805211208l27b6cb1as5951112bf504ffaa@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, May 14, 2008 at 7:33 PM, Duan Ligong <l-duan(at)zd(dot)cnes(dot)jp(dot)nec(dot)com> wrote:
>
> Hi, all
>
> Is there a way to estimate the size of the space which a postgresql database
> occupies? or the max size of db?
>
> I know there are a lot of factors, such as the frequency
> of updating, data size, which affects the size of db and it seems difficult
> to estimate it precisely.

There's also the old fashioned way:

sudo su - postgres
cd $PGDATA  # or wherever you point with -D on startup
du -sh .

In response to

Responses

pgsql-admin by date

Next:From: Duan LigongDate: 2008-05-22 01:08:33
Subject: Re: ]To estimate the size of db
Previous:From: Scott MarloweDate: 2008-05-21 19:07:07
Subject: Re: Trouble with recovering disc space

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