Re: [GENERAL] Controlling memory of session

2007-01-17 Thread James Im
ard Huxton wrote: James Im wrote: Richard Huxton wrote: > Is there a particular problem you're trying to solve? yes I'm trying to know how many connections can open to the database without running out of memory. Ideally I would like to optimize stuff so that I can open the maxim

Re: [GENERAL] Controlling memory of session

2007-01-17 Thread James Im
Richard Huxton wrote: > Is there a particular problem you're trying to solve? yes I'm trying to know how many connections can open to the database without running out of memory. Ideally I would like to optimize stuff so that I can open the maximum number of connection/session. In total I can gi

[GENERAL] Controlling memory of session

2007-01-17 Thread James Im
Hi, I'm using Postgresql 8.1 on windows2000 and I have a hard time understanding how to limit the memory of the sessions to 1 MB. What I have right now is that each connection (opened with jdbc) takes about 3MB (some take a little more, some a little less). I think that this is a waste of memory