| From: | Frank Finner <postgresql(at)finner(dot)de> |
|---|---|
| To: | Jerome Macaranas <jerome(at)gmanmi(dot)tv> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need input on postgres used for phpBB |
| Date: | 2005-05-10 06:33:36 |
| Message-ID: | 20050510083336.658dc9cf.postgresql@finner.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <jerome(at)gmanmi(dot)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.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(dot)finner(at)invenius(dot)de
Telefax: 0271 231 8608 Web: http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerome Macaranas | 2005-05-10 06:45:43 | Re: Need input on postgres used for phpBB |
| Previous Message | Sim Zacks | 2005-05-10 06:15:34 | Re: Data Modelling Tools |