From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Tuning 8.3 |
Date: | 2008-02-25 16:10:57 |
Message-ID: | 47C2E891.5060001@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2008-02-25 16:14:19 | Re: Questions about indexes with text_pattern_ops |
Previous Message | Peter Eisentraut | 2008-02-25 16:04:26 | Re: [PATCHES] Avahi support for Postgresql |