Postgres Pro
Downloads
Home   >   mailing lists

Re: Need input on postgres used for phpBB - Mailing list pgsql-general

From Frank Finner
Subject Re: Need input on postgres used for phpBB
Date
Msg-id 20050510083336.658dc9cf.postgresql@finner.de
Whole thread Raw
In response to Re: Need input on postgres used for phpBB  (Jerome Macaranas <jerome@gmanmi.tv>)
Responses Re: Need input on postgres used for phpBB  (Jerome Macaranas <jerome@gmanmi.tv>)
Re: Need input on postgres used for phpBB - addtional note  (Jerome Macaranas <jerome@gmanmi.tv>)
List pgsql-general
Tree view 
On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <jerome@gmanmi.tv> 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.phpand thread. My database became extremely slow, vacuum
itselfneeded 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@invenius.de
Telefax: 0271 231 8608    Web:  http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF  6E6A A74E 67E4 E788 2651
Attachment

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
Next
From: Jerome Macaranas
Date:
Subject: Re: Need input on postgres used for phpBB