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?
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/
pgsql-interfaces by date
|Next:||From: Thomas Lockhart||Date: 1999-05-17 14:22:47|
|Subject: Re: [INTERFACES] unixODBC - Beta 1.0.0|
|Previous:||From: Peter Harvey||Date: 1999-05-17 01:35:43|
|Subject: Re: [INTERFACES] ODBC|