Question about space usage: - Mailing list pgsql-performance

From Jeremy M. Guthrie
Subject Question about space usage:
Date
Msg-id 200401151037.42265.jeremy.guthrie@berbee.com
Whole thread Raw
Responses Re: Question about space usage:
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I recently upgraded from 7.3.4 to 7.4.  Besides the PostGreSQL change I
updated my schema to pull out all OIDs and 'set storage external'.

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.

Don't get me wrong, I'm not complaining.  I was under the impression that text
was compressed by default and that changing from compressed to
'non-compressed' would result in a larger foot print.  Is there something I
am missing?

- --
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=
=GpkI
-----END PGP SIGNATURE-----


pgsql-performance by date:

Previous
From: CoL
Date:
Subject: subquery and table join, index not use for table
Next
From: Ceri Storey
Date:
Subject: Join optimisation Quandry