Skip site navigation (1) Skip section navigation (2)

Vacuum takes for ever

From: Eildert Groeneveld <eg(at)tzv(dot)fal(dot)de>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Vacuum takes for ever
Date: 1999-05-17 07:45:49
Message-ID: 99051709490504.00692@salo.tzv.fal.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)tzv(dot)fal(dot)de
=========================================

Responses

pgsql-interfaces by date

Next:From: Thomas LockhartDate: 1999-05-17 14:22:47
Subject: Re: [INTERFACES] unixODBC - Beta 1.0.0
Previous:From: Peter HarveyDate: 1999-05-17 01:35:43
Subject: Re: [INTERFACES] ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group