The following bug has been logged online:
Bug reference: 5756
Logged by: amos
Email address: amosleaf(at)gmail(dot)com
PostgreSQL version: 8.3
Operating system: windows server 2008
Description: postgres eat up all memory(2GB memory)
I am sorry for not good at english, so please be patient with what i write,
I really need your help,thank you in advance.
(1)Our server use postgres8.3 database.
(2)The server would receive 500-1500 http request, and for each request,
server would operate the database once, so may it would use one database
(3)then I modify the configuration in "postgresql.conf".
What I changed is:
(1)max_connections = 2000
(2)shared_buffers = 32MB
(3)statement_timeout = 1800000 //this is 30 minutes
So the result is: when the server is working with more than 500 request, the
postgres eat up the memory.
BTW, our server is running java program, use a database pool whose name is
So which configuration should I change to avoid this?
pgsql-bugs by date
|Next:||From: Craig Ringer||Date: 2010-11-18 07:37:51|
|Subject: Re: BUG #5756: postgres eat up all memory(2GB memory)|
|Previous:||From: Robert Haas||Date: 2010-11-18 02:57:09|
|Subject: Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"|