From: Tom Lane <tgl@sss.pgh.pa.us>
To: jeremy.guthrie@berbee.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Question about space usage:
Date: Fri, 16 Jan 2004 14:26:18 -0500
Message-ID: <5934.1074281178@sss.pgh.pa.us> (raw)
In-Reply-To: <200401151037.42265.jeremy.guthrie@berbee.com>
References: <200401151037.42265.jeremy.guthrie@berbee.com>
"Jeremy M. Guthrie" <jeremy.guthrie@berbee.com> writes:
> 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.
First thought is that your 7.3 DB was suffering from index bloat (I know
you said you reindexed, but did you get everything including system
indexes?). The only material space savings in 7.4 over 7.3 as far as
raw data size goes is Manfred's row header size reduction (8 bytes per
row), which wouldn't account for that kind of difference unless you had
a huge number of very narrow rows ...
> Besides the PostGreSQL change I updated my schema to pull out all OIDs
> and 'set storage external'.
Removing OIDs would save another 4 or 8 bytes per row (depending on what
hardware you're on).
regards, tom lane
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: tgl@sss.pgh.pa.us, jeremy.guthrie@berbee.com
Subject: Re: Question about space usage:
In-Reply-To: <5934.1074281178@sss.pgh.pa.us>
* 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