From: Eildert Groeneveld <eg@tzv.fal.de>
To: pgsql-interfaces@postgresql.org
Subject: Vacuum takes for ever
Date: Mon, 17 May 1999 09:45:49 +0200
Message-ID: <99051709490504.00692@salo.tzv.fal.de> (raw)
Hello everyone,
in a substantial multi location development project we are using PG to
create a large information system.
After having loaded data in the order of one million records a vaccum took
50h of CPU time on a 350MHz PII (RedHat 5.2, pg 6.4.2). There were no
deletes or anyting like that.
What does vaccum do that takes so long and is there a way to speed this up?
greetings
Eildert Groeneveld
=========================================
Institute for
Animal Science and Animal Behaviour
Mariensee 31535 Neustadt Germany
Tel : (49)(0)5034 871155
Fax : (49)(0)5034 92579
www : http://www.tzv.fal.de/~eg/
e-mail: eg@tzv.fal.de
=========================================
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-interfaces@postgresql.org
Cc: eg@tzv.fal.de
Subject: Re: Vacuum takes for ever
In-Reply-To: <99051709490504.00692@salo.tzv.fal.de>
* 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