MAX_CONNECTIONS ?? - Mailing list pgsql-admin

From paulo matadr
Subject MAX_CONNECTIONS ??
Date
Msg-id 234747.33153.qm@web52501.mail.re2.yahoo.com
Whole thread Raw
Responses Re: [GENERAL] MAX_CONNECTIONS ??  (Richard Huxton <dev@archonet.com>)
List pgsql-admin
I need help to alter max_connections em my database, this parameter stay in defalt  MAX_CONNECTIONS=100
I want to change for MAX_CONNECTIONS=300.
about parameters below, need to change anything?

1 -sysctl.conf

kernel.shmmax = 68719476736
kernel.shmall = 4294967296
# - Memory -

2-Postgresql.conf
shared_buffers = 2048MB                                         
temp_buffers = 12MB                                                   
work_mem = 12MB                    
maintenance_work_mem = 128MB                         
max_fsm_pages =   4000000                              
max_fsm_relations = 5000           
                                 
Thanks for help


Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.

pgsql-admin by date:

Previous
From: "Sean Brown"
Date:
Subject: Re: function executes sql 100 times longer it should
Next
From: Richard Huxton
Date:
Subject: Re: [GENERAL] MAX_CONNECTIONS ??