Re: Tuning 8.3

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

In response to

  • Tuning 8.3 at 2008-02-25 15:47:37 from Roberts, Jon

Browse pgsql-hackers by date

  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