Question about space usage:

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-----

Responses

Browse pgsql-performance by date

  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