X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2527CD1B4D0 for ; Fri, 16 Jan 2004 19:26:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75057-05 for ; Fri, 16 Jan 2004 15:26:25 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id AD953D1D8AE for ; Fri, 16 Jan 2004 15:26:23 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0GJQIpH005935; Fri, 16 Jan 2004 14:26:18 -0500 (EST) To: jeremy.guthrie@berbee.com Cc: pgsql-performance@postgresql.org Subject: Re: Question about space usage: In-reply-to: <200401151037.42265.jeremy.guthrie@berbee.com> References: <200401151037.42265.jeremy.guthrie@berbee.com> Comments: In-reply-to "Jeremy M. Guthrie" message dated "Thu, 15 Jan 2004 10:37:41 -0600" Date: Fri, 16 Jan 2004 14:26:18 -0500 Message-ID: <5934.1074281178@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/179 X-Sequence-Number: 5353 "Jeremy M. Guthrie" writes: > With PostGreSQL V7.3.4, a completely reindexed and vacuumed(not-full) foot > print was 5.2 gig. Now some of the disk space(probably 10-15 % was waiting > in the FSM to be used). However, 7.4 comes up at 2.3 gig. First thought is that your 7.3 DB was suffering from index bloat (I know you said you reindexed, but did you get everything including system indexes?). The only material space savings in 7.4 over 7.3 as far as raw data size goes is Manfred's row header size reduction (8 bytes per row), which wouldn't account for that kind of difference unless you had a huge number of very narrow rows ... > Besides the PostGreSQL change I updated my schema to pull out all OIDs > and 'set storage external'. Removing OIDs would save another 4 or 8 bytes per row (depending on what hardware you're on). regards, tom lane