X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2E62B474E5C for ; Thu, 27 Feb 2003 07:19:18 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 05201-09 for ; Thu, 27 Feb 2003 07:19:07 -0500 (EST) Received: from dristor.cabanova.ro (cabanova.ro [213.157.162.113]) by postgresql.org (Postfix) with SMTP id 2BA2E474E4F for ; Thu, 27 Feb 2003 07:19:06 -0500 (EST) Received: (qmail 4506 invoked from network); 27 Feb 2003 12:22:38 -0000 Received: from catalin.dristor.cabanova.ro (HELO catalin) (192.168.1.2) by dristor.cabanova.ro with SMTP; 27 Feb 2003 12:22:38 -0000 Message-ID: <00c801c2de5a$76cb40d0$0201a8c0@catalin> From: "Catalin" To: Subject: Daily crash Date: Thu, 27 Feb 2003 14:19:23 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" 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/224 X-Sequence-Number: 1280 Hi there, Is there any performance tunning that i can make to the postgresql server to make the server more stable. In my case the main usage of the DB is from an website which has quite lots of visitors. In the last weeks the SQL server crashes every day ! Before complete crash the transaction start to work slower. I would appreciate any suggestion regarding this issue ! Thank you ! Catalin www.xclub.ro