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

Re: [Admin]To estimate the size of db

From: "Jaime Casanova" <systemguards(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-15 04:27:47
Message-ID: c2d9e70e0805142127t3efb82e3qd7625d207ae9c360@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, May 14, 2008 at 8: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?
>

if pg >= 8.1 then
    http://www.postgresql.org/docs/8.1/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
else
    there is a contrib/dbsize
end if

-- 
Atentamente,
Jaime Casanova
Soporte y capacitaciĆ³n de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 087171157

In response to

pgsql-admin by date

Next:From: ioguixDate: 2008-05-15 08:54:39
Subject: Re: phpgadmin
Previous:From: Duan LigongDate: 2008-05-15 01:33:35
Subject: [Admin]To estimate the size of db

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