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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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