Re: 7.4 <-> 8.0

-----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-----


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org