Re: Tuning 8.3

Roberts, Jon wrote:
>
> I need to run about 1000 PostgreSQL connections on a server that I can 
> use about 4 GB of the total 16 GB of total RAM. It seems that each 
> session creates a process that uses about 15 MB of RAM just for 
> connecting so I’m running out of RAM rather quickly.
>
> I have these non-default settings:
>
> shared_buffers = 30MB
>
> max_connections = 1000
>
> I tried decreasing the work_mem but the db wouldn’t start then.
>
> I’m running version 8.3 on Windows 2003 Server.
>
> Any tips for reducing the memory footprint per session? There is 
> pgBouncer but is there anything I can do in the configuration before I 
> go with a connection pooler?
>
>

Please ask usage questions on the appropriate list (in this case one of: 
pgsql-general, pgsql-performance or pgsql-admin). pgsql-hackers is for 
discussion of development of features, not for usage issues.

cheers

andrew