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 1814C9FB321 for ; Thu, 21 Sep 2006 14:42:06 -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 29056-05 for ; Thu, 21 Sep 2006 14:41:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 3C2229FB319 for ; Thu, 21 Sep 2006 14:41:58 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so756164wxc for ; Thu, 21 Sep 2006 10:41:57 -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:content-transfer-encoding:content-disposition:references; b=P7nmcXU1gGBTL3YfL089FCwPP2ziJBR+M9Zh/EN5KYHHKTnhufayJme+Vzef6mlCXOg6xk14kNBMOUrg+Eolp0Q1OuuILNW0O+bq5bx8h8qF5YyUyGJLj5Tp+r2/tP6CQcTBnDVdsRuo9gAufKS22Rj9h0rIaZeVP21y6VU35Gc= Received: by 10.90.113.18 with SMTP id l18mr7597050agc; Thu, 21 Sep 2006 10:41:56 -0700 (PDT) Received: by 10.90.71.14 with HTTP; Thu, 21 Sep 2006 10:41:56 -0700 (PDT) Message-ID: Date: Thu, 21 Sep 2006 14:41:56 -0300 From: "Guido Barosio" To: rodrigo.sakai@zanthus.com.br Subject: Re: Estimating a table size Cc: pgsql-admin@postgresql.org In-Reply-To: <001b01c6dda0$723b90d0$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <001b01c6dda0$723b90d0$4700a8c0@TREEZANTHUS> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/231 X-Sequence-Number: 23145 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