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


From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: GENERAL <pgsql-general(at)postgresql(dot)org>, admin <pgsql-admin(at)postgresql(dot)org>
Date: 2008-11-12 16:05:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-general
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 -

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 ou


pgsql-admin by date

Next:From: Naomi WalkerDate: 2008-11-12 17:06:01
Subject: Upgrade in Place
Previous:From: Sean BrownDate: 2008-11-12 14:30:47
Subject: Re: function executes sql 100 times longer it should

pgsql-general by date

Next:From: Alan HodgsonDate: 2008-11-12 16:06:54
Subject: Re: merge 2 dumps
Previous:From: Ivan Sergio BorgonovoDate: 2008-11-12 16:01:19
Subject: sequence not restarting in a for loop (actually semi-random numbers)

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