X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 59D8847595A for ; Thu, 27 Feb 2003 09:54:12 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 35470-04 for ; Thu, 27 Feb 2003 09:54:01 -0500 (EST) Received: from dristor.cabanova.ro (cabanova.ro [213.157.162.113]) by postgresql.org (Postfix) with SMTP id 6E16D4759BD for ; Thu, 27 Feb 2003 09:53:03 -0500 (EST) Received: (qmail 5792 invoked from network); 27 Feb 2003 14:56:39 -0000 Received: from catalin.dristor.cabanova.ro (HELO catalin) (192.168.1.2) by dristor.cabanova.ro with SMTP; 27 Feb 2003 14:56:39 -0000 Message-ID: <000701c2de6f$f96f1ce0$0201a8c0@catalin> From: "Catalin" To: References: <01c201c2de6e$e9b3aab0$c9c832c0@societykotla> Subject: Re: [Performance] Daily Crash Date: Thu, 27 Feb 2003 16:53:22 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Rating: dristor.cabanova.ro 1.6.2 0/1000/N X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/232 X-Sequence-Number: 1288 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@postgresql.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@postgresql.org)