From: Peter Childs <bluedragon@blueyonder.co.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: 7.4 <-> 8.0
Date: Fri, 16 Sep 2005 17:30:03 +0100
Message-ID: <432AF30B.9020509@blueyonder.co.uk> (raw)
In-Reply-To: <1126886236.12350.106.camel@localhost>
References: <1126811405.12350.29.camel@localhost>
<f7f6b4c7050915133528861ce5@mail.gmail.com>
<f7f6b4c705091513473b7def79@mail.gmail.com>
<1126886236.12350.106.camel@localhost>
-----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-----
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bluedragon@blueyonder.co.uk
Subject: Re: 7.4 <-> 8.0
In-Reply-To: <432AF30B.9020509@blueyonder.co.uk>
References: <1126811405.12350.29.camel@localhost> <f7f6b4c7050915133528861ce5@mail.gmail.com> <f7f6b4c705091513473b7def79@mail.gmail.com> <1126886236.12350.106.camel@localhost> <432AF30B.9020509@blueyonder.co.uk>
* 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