I am already using pgpool, is it bad have 550 connections, is it much ? Thank you guys for all your help.
Thanks, Dzmitry On 8/19/13 4:43 PM, "Scott Ribe" <[email protected]> wrote: >On Aug 19, 2013, at 7:23 AM, Stéphane Schildknecht ><[email protected]> wrote: > >> As Laurenz said, you should have a look at documentation. >> >> It explains how you can lower the risk OOMKiller kills your PostgreSQL >>processes. >> 1. You can set vm.overcommit_memory to 2 in sysctl.conf >> 2. You can adjust the value of oom_score_adj in startup script to >>prevent OOMKiller to kill Postmaster >> 3. You can lower shared_buffers, work_mem and max_connections. > >4. Use pgbouncer, and radically lower the number of pg connections used. > >-- >Scott Ribe >[email protected] >http://www.elevated-dev.com/ >(303) 722-0567 voice > > > > > > >-- >Sent via pgsql-admin mailing list ([email protected]) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
