pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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-----




view thread (7+ messages)  latest in thread

Message-ID: <432AF30B.9020509@blueyonder.co.uk>
Permalink:  ../432AF30B.9020509@blueyonder.co.uk/
Also on:    postgresql.org/message-id/432AF30B.9020509@blueyonder.co.uk

 · 

reply

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