BUG #5756: postgres eat up all memory(2GB memory)

From: "amos" <amosleaf(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5756: postgres eat up all memory(2GB memory)
Date: 2010-11-18 03:18:57
Message-ID: 201011180318.oAI3IvTE047316@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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)
Details:

Hi:
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.

Current situration:
(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
connection.
(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
"c3p0".

So which configuration should I change to avoid this?
Thanks again!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2010-11-18 07:37:51 Re: BUG #5756: postgres eat up all memory(2GB memory)
Previous Message Robert Haas 2010-11-18 02:57:09 Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"