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

Re: [Performance] Daily Crash

From: "Catalin" <catalin(at)cyber(dot)ro>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [Performance] Daily Crash
Date: 2003-02-27 14:53:22
Message-ID: 000701c2de6f$f96f1ce0$0201a8c0@catalin (view raw or flat)
Thread:
Lists: pgsql-performance
i have php 4.2.3
i use pg_pConnect and no pg_Close.

thanks for yours advices.
i will upgrade to postgresql 7.2.3 asap 
and see if there are improvments !

thanks again !

Catalin

----- Original Message ----- 
From: Aspire Something 
To: pgsql-performance(at)postgresql(dot)org 
Sent: Thursday, February 27, 2003 4:44 PM
Subject: Re: [PERFORM] [Performance] Daily Crash


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.
================================



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-02-27 16:53:08
Subject: Re: [Performance] Daily Crash
Previous:From: Aspire SomethingDate: 2003-02-27 14:44:54
Subject: Re: [Performance] Daily Crash

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