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 EB35B9FB1E8 for ; Thu, 21 Sep 2006 14:24:03 -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 28054-05 for ; Thu, 21 Sep 2006 14:23:54 -0300 (ADT) X-Greylist: delayed 00:17:43.499913 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B02089FB1F0 for ; Thu, 21 Sep 2006 14:23:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.zanthus.com.br (mail.zanthus.com.br [200.212.65.85]) by svr4.postgresql.org (Postfix) with ESMTP id AA3A85AFA2A for ; Thu, 21 Sep 2006 17:06:02 +0000 (GMT) Received: from cprsakai (unknown [192.168.0.71]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mail.zanthus.com.br (Postfix) with ESMTP id DBE9A248E1 for ; Thu, 21 Sep 2006 14:13:59 -0300 (BRT) Reply-To: From: "Rodrigo Sakai" To: Subject: Estimating a table size Date: Thu, 21 Sep 2006 14:07:40 -0300 Organization: Zanthus Message-ID: <001b01c6dda0$723b90d0$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001C_01C6DD87.4CEE58D0" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 Thread-Index: AcbdoHGzSbpYcoQ8THaM/GkHW6bnVw== X-Zanthus-MailScanner: Found to be clean X-Zanthus-MailScanner-From: rodrigo.sakai@zanthus.com.br X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200609/229 X-Sequence-Number: 23143 This is a multi-part message in MIME format. ------=_NextPart_000_001C_01C6DD87.4CEE58D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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! ------=_NextPart_000_001C_01C6DD87.4CEE58D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

  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 >=3D 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!

    =

------=_NextPart_000_001C_01C6DD87.4CEE58D0--