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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
=========================================
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-05-17 14:22:47 | Re: [INTERFACES] unixODBC - Beta 1.0.0 |
Previous Message | Peter Harvey | 1999-05-17 01:35:43 | Re: [INTERFACES] ODBC |