On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]> thought 
long, then sat down and wrote:

> im using RH9
> 
> postgres 7.3.4

Maybe you ran into the same problem I had about a year ago. See 
http://archives.postgresql.org/pgsql-general/2004-03/msg00810.php and thread. 
My database became extremely slow, vacuum itself needed several hours instead 
of several minutes, after doing some weeks of heavy inserting.

Vaccum obviously does not release all unused memory in 7.3.x. 
-- 
Frank Finner

Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606    Mail: [EMAIL PROTECTED]
Telefax: 0271 231 8608    Web:  http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF  6E6A A74E 67E4 E788 2651

Attachment: pgpBY3fiCkaVm.pgp
Description: PGP signature

Reply via email to