Re: PostgreSQL with Zabbix - problem of newbe

On Fri, Apr 9, 2010 at 12:03 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> The main problem with this configuration is that work_mem is set to an
> unsafe value--1.6GB.  With potentially 400 connections and about 2GB of RAM
> free after starting the server, work_mem='4MB' is as large as you can safely
> set this.

if you need more work_mem for this or that and also need to serve a
lot of connections, you can always set it locally (1.6GB is still too
high though -- maybe 64mb if you need to do a big sort or something
like that).

Another path to take is to install pgbouncer, which at 400 connections
is worth considering -- but only if your client stack doesn't use
certain features that require a private database session.  zabbix will
_probably_ work because it is db portable software (still should check
however).

merlin