X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 331439FB369 for ; Thu, 21 Sep 2006 14:50:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32041-03 for ; Thu, 21 Sep 2006 14:50:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by postgresql.org (Postfix) with ESMTP id 165AC9FB365 for ; Thu, 21 Sep 2006 14:50:14 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 55so433040wri for ; Thu, 21 Sep 2006 10:50:14 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=knKjDv+hVMJvhXUsne5rpd2cdNVQQB12Y6TpZsTbNdgc0K4Pak4lPAhlfzzvxtDCCepSse3bLVD7/Y4ImN9xdG8XAmThImJIh1FofRkg2wqHomJ9U/X4Vryp9CXw6k+6PtSc4wKkWi/fmTOT2JTBChEN+E2DZcRIirPiqIJzPGQ= Received: by 10.90.79.6 with SMTP id c6mr7609894agb; Thu, 21 Sep 2006 10:50:14 -0700 (PDT) Received: by 10.90.81.4 with HTTP; Thu, 21 Sep 2006 10:50:14 -0700 (PDT) Message-ID: Date: Thu, 21 Sep 2006 22:50:14 +0500 From: "Shoaib Mir" To: "Guido Barosio" Subject: Re: Estimating a table size Cc: rodrigo.sakai@zanthus.com.br, pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13078_15218472.1158861014143" References: <001b01c6dda0$723b90d0$4700a8c0@TREEZANTHUS> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.605 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/233 X-Sequence-Number: 23147 ------=_Part_13078_15218472.1158861014143 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 wrote: > > there used to be a dbsize project, search for it. > > g.- > On 9/21/06, Rodrigo Sakai 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.barosio@globant.com > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ------=_Part_13078_15218472.1158861014143 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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@gmail.com> wrote:
there used to be a dbsize project, search for it.

g.-
On 9/21/06, Rodrigo Sakai <rodrigo.sakai@zanthus.com.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.barosio@globant.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings




------=_Part_13078_15218472.1158861014143--