| 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> |
| Subject: | MAX_CONNECTIONS ?? |
| Date: | 2008-11-12 16:05:19 |
| Message-ID: | 234747.33153.qm@web52501.mail.re2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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 -
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.
http://br.new.mail.yahoo.com/addresses
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naomi Walker | 2008-11-12 17:06:01 | Upgrade in Place |
| Previous Message | Sean Brown | 2008-11-12 14:30:47 | Re: function executes sql 100 times longer it should |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2008-11-12 16:06:54 | Re: merge 2 dumps |
| Previous Message | Ivan Sergio Borgonovo | 2008-11-12 16:01:19 | sequence not restarting in a for loop (actually semi-random numbers) |