From: | "Jeremy M(dot) Guthrie" <jeremy(dot)guthrie(at)berbee(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Question about space usage: |
Date: | 2004-01-15 16:37:41 |
Message-ID: | 200401151037.42265.jeremy.guthrie@berbee.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-01-15 16:40:46 | Re: Weird query speed |
Previous Message | Richard Huxton | 2004-01-15 16:10:38 | Re: Trigger question |