On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <jerome@xxxxxxxxx> 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: frank.finner@xxxxxxxxxxx Telefax: 0271 231 8608 Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
Attachment:
pgpG7m6Y0C8Jw.pgp
Description: PGP signature
