Question about space usage:

Поиск
Список
Период
Сортировка
От Jeremy M. Guthrie
Тема Question about space usage:
Дата
Msg-id 200401151037.42265.jeremy.guthrie@berbee.com
обсуждение исходный текст
Ответы Re: Question about space usage:  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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-----


В списке pgsql-performance по дате отправления:

Предыдущее
От: CoL
Дата:
Сообщение: subquery and table join, index not use for table
Следующее
От: Ceri Storey
Дата:
Сообщение: Join optimisation Quandry