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 B2E8DD1D880 for ; Thu, 15 Jan 2004 16:38:16 +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 10882-08 for ; Thu, 15 Jan 2004 12:37:45 -0400 (AST) Received: from ctg-msnex01.staff.berbee.com (msn-office1.binc.net [64.73.12.254]) by svr1.postgresql.org (Postfix) with ESMTP id 33874D1D875 for ; Thu, 15 Jan 2004 12:37:44 -0400 (AST) Received: from localhost ([172.30.254.220] RDNS failed) by ctg-msnex01.staff.berbee.com with Microsoft SMTPSVC(5.0.2195.5329); Thu, 15 Jan 2004 10:37:42 -0600 From: "Jeremy M. Guthrie" Reply-To: jeremy.guthrie@berbee.com Organization: Berbee Information Networks To: Subject: Question about space usage: Date: Thu, 15 Jan 2004 10:37:41 -0600 User-Agent: KMail/1.5.4 MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200401151037.42265.jeremy.guthrie@berbee.com> X-OriginalArrivalTime: 15 Jan 2004 16:37:42.0914 (UTC) FILETIME=[E5CE4620:01C3DB85] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/172 X-Sequence-Number: 5346 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I recently upgraded from 7.3.4 to 7.4. Besides the PostGreSQL change I=20 updated my schema to pull out all OIDs and 'set storage external'.=20=20 With PostGreSQL V7.3.4, a completely reindexed and vacuumed(not-full) foot= =20 print was 5.2 gig. Now some of the disk space(probably 10-15 % was waiting= =20 in the FSM to be used). However, 7.4 comes up at 2.3 gig.=20=20 Don't get me wrong, I'm not complaining. I was under the impression that t= ext=20 was compressed by default and that changing from compressed to=20 'non-compressed' would result in a larger foot print. Is there something I= =20 am missing? - --=20 Jeremy M. Guthrie Systems Engineer Berbee 5520 Research Park Dr. Madison, WI 53711 Phone: 608-298-1061 Berbee...Decade 1. 1993-2003 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFABsHVqtjaBHGZBeURAp3tAKCTe9SjnPEU5V25KnxWZHD4ulXIXwCfd45O Cf9lRBReCjv9fKyglR+dSM8=3D =3DGpkI -----END PGP SIGNATURE-----