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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
