From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: postgresql performance tuning
Date: Tue, 06 Dec 2005 19:23:07 -0500
Message-ID: <20051207002307.GM7330@mathom.us> (raw)
In-Reply-To: <Pine.LNX.4.58.0512061546120.22753@karadi.cs.wisc.edu>
References: <Pine.LNX.4.58.0512060941090.21795@karadi.cs.wisc.edu>
<F069CC64-C748-4EC1-ADF3-38D2FBC230CD@khera.org>
<Pine.LNX.4.58.0512061546120.22753@karadi.cs.wisc.edu>
On Tue, Dec 06, 2005 at 04:03:22PM -0600, Ameet Kini wrote:
>I'm running postgresql v8.0 and my problem is that running vacuum on my
>indices are blazing fast (upto 10x faster) AFTER running reindex. For a
>table with only 1 index, the time to do a vacuum (without full) went down
>from 45 minutes to under 3 minutes.
I've also noticed a fairly large increase in vacuum speed after a
reindex. (To the point where the reindex + vacuum was faster than just a
vacuum.)
Mike Stone
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mstone+postgres@mathom.us
Subject: Re: postgresql performance tuning
In-Reply-To: <20051207002307.GM7330@mathom.us>
* 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