The following bug has been logged online: Bug reference: 5756 Logged by: amos Email address: amosl...@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! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
