pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question about space usage:
2+ messages / 2 participants
[nested] [flat]

* Question about space usage:
@ 2004-01-15 16:37  Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Jeremy M. Guthrie @ 2004-01-15 16:37 UTC (permalink / raw)
  To: 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-----




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Question about space usage:
@ 2004-01-16 19:26  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-01-16 19:26 UTC (permalink / raw)
  To: jeremy.guthrie@berbee.com; +Cc: pgsql-performance

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-01-16 19:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-15 16:37 Question about space usage: Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
2004-01-16 19:26 ` Tom Lane <tgl@sss.pgh.pa.us>

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