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.
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 ?
In response to
pgsql-admin by date
|Next:||From: Steve||Date: 2004-07-26 01:46:22|
|Subject: Re: Utilizing multiple disks|
|Previous:||From: Roberto De Shong||Date: 2004-07-25 23:15:08|
|Subject: Re: Can't increase max connections|