Skip site navigation (1) Skip section navigation (2)

Re: Can't increase max connections

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Roberto De Shong <shong_1(at)yahoo(dot)com>
Subject: Re: Can't increase max connections
Date: 2004-07-25 23:47:45
Message-ID: 410446A1.4010000@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
Roberto De Shong wrote:

 > Actually I got it solved, I recompiled the kernel adding the options below:
 > options        SYSVSHM
 > options        SYSVSEM
 > options        SYSVMSG
 > options        SHMMAXPGS=65536
 > options        SEMMNI=40
 > options        SEMMNS=240
 > options        SEMUME=40
 > options        SEMMNU=120
 >
 > And I made the following modifications to postgresql.conf:
 >
 > shared_buffers = 4096
 > max_fsm_relations = 1024
 > max_fsm_pages = 16384
 > sort_mem = 4096
 >
 > I was tthen able to increase it, I only set maxconnections to 200,
 > because I'm using database pooling to manage connections which I'm only
 > using 80 connections max.
 >
 > Thanks.

So if you need 80 connections why did you use 200 on the postgres side ?
You waste shared memory if you have 120 connections more then necessary.

Are you using pgpoll ?


Regards
Gaetano Mendola




In response to

pgsql-admin by date

Next:From: SteveDate: 2004-07-26 01:46:22
Subject: Re: Utilizing multiple disks
Previous:From: Roberto De ShongDate: 2004-07-25 23:15:08
Subject: Re: Can't increase max connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group