Re: 7.4 <-> 8.0

From: Peter Childs <bluedragon(at)blueyonder(dot)co(dot)uk>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 7.4 <-> 8.0
Date: 2005-09-16 16:30:03
Message-ID: 432AF30B.9020509@blueyonder.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Warren Snelling wrote:

>
>
> Would you suggest scripting the vacuum full / reindex process to
> run periodically (once a week or so)? Right now disk space on this
> machine is not an issue, but vacuuming and reindexing occasionally
> should keep the db from consuming too much excess space.
>
7.4 has a problem with vacuuming indexes I seam to remember. I
think thats this is one of the fixes in 8.0. Apart from anything a
large index is going to slow your database down as the database has to
scan past junk everytime it does an index lookup.

Peter Childs
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDKvMKJWgkOaNnHdMRAsBEAKCv3ZWdy1a4+qQG0U9Ov85TPCembQCfazPH
QVPj5xEDPSumy1Z4FUSTgf4=
=As1l
-----END PGP SIGNATURE-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-09-16 16:59:16 Re: 7.4 <-> 8.0
Previous Message Guido Barosio 2005-09-16 16:26:56 Re: 7.4 <-> 8.0