X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2712BD7FA2 for ; Thu, 25 Aug 2005 09:52:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69425-05 for ; Thu, 25 Aug 2005 12:52:32 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by svr1.postgresql.org (Postfix) with ESMTP id 3DEA5D7FA1 for ; Thu, 25 Aug 2005 09:52:31 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z6so195556nzd for ; Thu, 25 Aug 2005 05:52:35 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=c6732T5h8mGk8KBj/xV09EPAKpQM0eHLH2V8/QmEgh1eU1qYkvNzghtk6hPQJTsBF1FENuVW9nk7DQHsYn4V/xAcRPerfTVRbCdlZkgWPWKY3wR3kNdftHwvjbQRIaS9Xbe4Cl3bHS5XuM3BnxwLNdDC+TTxvx+/gvvMGnDhvxY= Received: by 10.36.36.4 with SMTP id j4mr74779nzj; Thu, 25 Aug 2005 05:52:35 -0700 (PDT) Received: by 10.36.138.5 with HTTP; Thu, 25 Aug 2005 05:52:35 -0700 (PDT) Message-ID: <69f2062a05082505523a9e485a@mail.gmail.com> Date: Thu, 25 Aug 2005 08:52:35 -0400 From: jose fuenmayor To: pgsql-admin@postgresql.org Subject: size of indexes and tables (more than 1GB) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.693 required=5 tests=[AWL=0.153, FROM_ENDS_IN_NUMS=0.516, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/312 X-Sequence-Number: 18631 I read and have seen that when a table has more than 1GB it is divided in several files with the names of inode,inode.1,inode.2,inode.3, etc. I have a table of 1.3 GB (9.618.118 rows,13 fields) it is divided in that way as i see on /PGDATA/base but each file has the same size i mean table inode (1.3GB), inode.1(1.3GB),inode.2(1.3GB) so is this not a waste of space?, are those file sizes reusable by postgresql?. The size of the table is 3 times bigger than, for instance Visual Fox Pro dbf's? since is there fisically three times. I am a little confuse on this. I apreciatte anybody could explain this to me Thanks in advance.