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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve | 2004-07-26 01:46:22 | Re: Utilizing multiple disks |
Previous Message | Roberto De Shong | 2004-07-25 23:15:08 | Re: Can't increase max connections |