X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 55202475EA4 for ; Thu, 27 Feb 2003 15:44: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 38541-08 for ; Thu, 27 Feb 2003 15:43:35 -0500 (EST) Received: from dristor.cabanova.ro (cabanova.ro [213.157.162.113]) by postgresql.org (Postfix) with SMTP id E820F475E31 for ; Thu, 27 Feb 2003 15:19:25 -0500 (EST) Received: (qmail 7751 invoked from network); 27 Feb 2003 20:23:03 -0000 Received: from catalin.dristor.cabanova.ro (HELO catalin) (192.168.1.2) by dristor.cabanova.ro with SMTP; 27 Feb 2003 20:23:03 -0000 Message-ID: <00be01c2de9d$8fd8b150$0201a8c0@catalin> From: "Catalin" To: References: Subject: Re: [Performance] Daily Crash Date: Thu, 27 Feb 2003 22:19:42 +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/237 X-Sequence-Number: 1293 how often should i run VACUUM to keep the thing tunned ? Catalin ----- Original Message ----- From: philip johnson To: Catalin ; pgsql-performance@postgresql.org Sent: Thursday, February 27, 2003 8:51 PM Subject: RE: [PERFORM] [Performance] Daily Crash pgsql-performance-owner@postgresql.org wrote: > 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) > > ---------------------------(end of > broadcast)--------------------------- TIP 5: Have you checked our > extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html you can use no persistent link to database see in php.ini pgsql.allow_persistent = Off