From: Dan Langille <dan@langille.org>
To: Brian McCane <bmccane@mccons.net>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: VACUUM FULL
Date: Fri, 10 May 2002 20:38:30 -0400
Message-ID: <20010511204113.21CB03F3F@bast.unixathome.org> (raw)
In-Reply-To: <20020510185436.F62674-100000@fw.mccons.net>
References: <NEBBLAAHGLEEPCGOBHDGKECGEPAA.nickf@ontko.com>
On 10 May 2002 at 19:18, Brian McCane wrote:
> But, a 4% decrease in size should not add up to a 84% increase in
> performance (is that right? I always get the ratio confused :).
Have you tried an ANALYZE as well? It wasn't mentioned.
See http://www.postgresql.org/idocs/index.php?routine-vacuuming.html
PostgreSQL's VACUUM command must be run on a regular basis for several
reasons:
1. To recover disk space occupied by updated or deleted rows.
2. To update data statistics used by the PostgreSQL query planner.
3. To protect against loss of very old data due to transaction ID
wraparound.
Read 8.2.2. Updating planner statistics
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples
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-admin@postgresql.org
Cc: dan@langille.org, bmccane@mccons.net
Subject: Re: VACUUM FULL
In-Reply-To: <20010511204113.21CB03F3F@bast.unixathome.org>
* 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