BUG #5756: postgres eat up all memory(2GB memory)
От | amos |
---|---|
Тема | BUG #5756: postgres eat up all memory(2GB memory) |
Дата | |
Msg-id | 201011180318.oAI3IvTE047316@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5756: postgres eat up all memory(2GB memory)
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5756 Logged by: amos Email address: amosleaf@gmail.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!
В списке pgsql-bugs по дате отправления: