| From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL 8.4.8 bringing my website down every evening |
| Date: | 2011-05-25 19:54:26 |
| Message-ID: | BANLkTimqnrfcz17URsuaydf=vGr-9nnZCQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thank you for your replies,
I've reverted httpd.conf to
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
and have changed postgresql.conf to:
shared_buffers = 512MB
# for Apache + my game daemon + cron jobs
max_connections = 260
Do you think I need to reconfigure CentOS 5.6
for the bigger shared memory too or
will it adapt by itself?
I'm still studying the docs.
Also I've installed the pgbouncer package and
will read on it too, but I already wonder what is
its behaviour if configured for 100 connections
and a 101st comes in?
; total number of clients that can connect
max_client_conn = 100
default_pool_size = 20
Regards
Alex
# rpm -qa|grep -i pg
perl-DBD-Pg-1.49-2.el5_3.1
pgbouncer-1.3.4-1.rhel5
pgdg-centos-8.4-2
php53-pgsql-5.3.3-1.el5_6.1
postgresql-8.4.8-1PGDG.rhel5
postgresql-devel-8.4.8-1PGDG.rhel5
postgresql-libs-8.4.8-1PGDG.rhel5
postgresql-server-8.4.8-1PGDG.rhel5
# uname -rm
2.6.18-238.9.1.el5 x86_64
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Farber | 2011-05-25 19:59:44 | Re: PostgreSQL 8.4.8 bringing my website down every evening |
| Previous Message | akp geek | 2011-05-25 19:42:15 | Access to postgres conversion |