From: Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
To: pgsql-performance@postgresql.org
Subject: Question about space usage:
Date: Thu, 15 Jan 2004 10:37:41 -0600
Message-ID: <200401151037.42265.jeremy.guthrie@berbee.com> (raw)
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jeremy.guthrie@berbee.com
Subject: Re: Question about space usage:
In-Reply-To: <200401151037.42265.jeremy.guthrie@berbee.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox