From: Steven M. Wheeler <swheeler@sabre.com>
To: pgsql-sql@hub.org
Subject: Questions about vacuum analyze
Date: Mon, 30 Aug 1999 07:36:10 -0500
Message-ID: <37CA7ABA.7CFFC6F5@sabre.com> (raw)
System: Compaq ProLiant 3000, dual-336MHz Pentium II, 512MB RAM
O/S: Linux 2.2.6 (Slackware 4.0 dist)
DB: Postgresql 6.5.1
DB on 8GB 4-disk stripe-set using md.
DB with two tables, each with about 1M rows.
Current DB size about 1.5GB
I am having trouble deciding when to run vacuum analyze, how often, and
what state the system should be in when I run it. I have found that if
I run it once a night, on a system that is quiet (no other processes
connected to the DB) it will still take several (4-8) hours.
Does anyone have recommendations regarding vacuum analyze?
Specifically:
1) Should it be run on a system that is quiet or will it run acceptably
with other processes accessing the DB?
2) How often should it be run?
Thanks,
--
Steven Wheeler
UNIX Engineering
(918) 292-4119
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-sql@postgresql.org
Cc: swheeler@sabre.com, pgsql-sql@hub.org
Subject: Re: Questions about vacuum analyze
In-Reply-To: <37CA7ABA.7CFFC6F5@sabre.com>
* 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