From: Michael Paesold <mpaesold@gmx.at>
To: R. Willmington <willmington@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: Update and some verbose output
Date: Sat, 18 Sep 2004 16:09:47 +0200
Message-ID: <008a01c49d89$27eb02d0$d604460a@zaphod> (raw)
References: <e6568d.0409160835.392a4b1b@posting.google.com>
R. Willmington wrote:
> In fact, it seems to perform well and removes the deleted records.
> The problem is that the performance of queries against the table is
> as low as it was before i ran VACUUM FULL for the first time in a
> year,
> whereas performance on the staging system with the SAME database and
> the exact same data was dramatically increased.
Have you tried to reindex the table? (\help REINDEX)
If table indexes have grown very big, I think just vacuum full is not
enough. At least you could try and see, if it makes a difference.
Regards,
Michael Paesold
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: mpaesold@gmx.at, willmington@gmx.net
Subject: Re: Update and some verbose output
In-Reply-To: <008a01c49d89$27eb02d0$d604460a@zaphod>
References: <e6568d.0409160835.392a4b1b@posting.google.com> <008a01c49d89$27eb02d0$d604460a@zaphod>
* 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