From: Aspire Something <sank89@sancharnet.in>
To: pgsql-performance@postgresql.org
Subject: Re: [Performance] Daily Crash
Date: Thu, 27 Feb 2003 20:14:54 +0530
Message-ID: <01c201c2de6e$e9b3aab0$c9c832c0@societykotla> (raw)
Dear Catalin,
What I understand from ur post is,
1. U are using PHP for connection. what version ??? assuming u are on PHP
version >4.2.X
2. Ur Postgresql server is not tuned to handle loads.
What U can try is ......
1.Make sure that ur PHP scripts close the connection when transaction is
complete (HOW??? see after pg_connect
U see a pg_close function of PHP)
a. Use pg_pconnect and forget about pg_connect and pg_close
2. Increse the limit of connection to be made to PostgreSQL this can be
done as said by Shridhar the default is 32
3. For God sake Upgrade to PostgreSQL 7.3.2 and PHP 4.3.1 you are missing a
lot with that old versions.
Regards,
V Kashyap
================================
Some people think it's holding on that makes one strong;
sometimes it's letting go.
================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: sank89@sancharnet.in
Subject: Re: [Performance] Daily Crash
In-Reply-To: <01c201c2de6e$e9b3aab0$c9c832c0@societykotla>
References: <01c201c2de6e$e9b3aab0$c9c832c0@societykotla>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox