Re: Estimating a table size

http://www.postgresql.org/docs/8.1/static/diskusage.html can help you get
this information.

Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 9/21/06, Guido Barosio <gbarosio(at)gmail(dot)com> wrote:
>
> there used to be a dbsize project, search for it.
>
> g.-
> On 9/21/06, Rodrigo Sakai <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br> wrote:
> >
> >
> >
> >
> > Hello all,
> >
> >
> >
> > I need a tool or something like it, which can give me the estimated
> size
> > of a table considering all fields, constraints, indexes, etc...
> >
> >
> >
> > For example:
> >
> >
> >
> >
> >
> > CREATE TABLE products (
> >
> > product_id INT8,
> >
> > product_name VARCHAR(50),
> >
> > product_vendor VARCHAR(50),
> >
> > price NUMERIC(10,2),
> >
> >
> >
> > CONSTRAINT pk_products PRIMARY KEY (product_id),
> >
> > CONSTRAINT ck_price CHECK (price >= 0)
> >
> > );
> >
> >
> >
> >
> >
> > CREATE INDEX ix_products ON products (product_name);
> >
> >
> >
> >
> >
> > See that in the example above I have, some fields, some constraints
> and
> > one index. I want to know (estimate) how much fisical space (KB, MB) it
> will
> > consume!
> >
> >
> >
> >
> >
> > Thanks in advance!
> >
> >
>
>
> --
> Guido Barosio
> -----------------------
> http://www.globant.com
> guido(dot)barosio(at)globant(dot)com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>