X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9F934758F1 for ; Thu, 27 Feb 2003 09:43:19 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 31431-07 for ; Thu, 27 Feb 2003 09:43:00 -0500 (EST) Received: from ndl1mr1-a-fixed (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by postgresql.org (Postfix) with ESMTP id 4B63F47592C for ; Thu, 27 Feb 2003 09:41:59 -0500 (EST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 0.9 (built Jul 29 2002)) id <0HAZ00L011S464@ndl1mr1-a-fixed.sancharnet.in> for pgsql-performance@postgresql.org; Thu, 27 Feb 2003 20:12:01 +0530 (IST) Received: from societykotla ([61.0.95.99]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 0.9 (built Jul 29 2002)) with ESMTPA id <0HAZ00K3824M7L@ndl1mr1-a-fixed.sancharnet.in> for pgsql-performance@postgresql.org; Thu, 27 Feb 2003 20:12:01 +0530 (IST) Date: Thu, 27 Feb 2003 20:14:54 +0530 From: Aspire Something Subject: Re: [Performance] Daily Crash To: pgsql-performance@postgresql.org Reply-To: Aspire Something Message-id: <01c201c2de6e$e9b3aab0$c9c832c0@societykotla> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Mailer: Microsoft Outlook Express 6.00.2600.0000 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT X-Priority: 3 X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/231 X-Sequence-Number: 1287 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. ================================