X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 75527D1B4E4 for ; Mon, 20 Oct 2003 14:44:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36736-04 for ; Mon, 20 Oct 2003 11:44:06 -0300 (ADT) Received: from dhcp-7-248.ma.lycos.com (waltham-nat.ma.lycos.com [209.202.205.1]) by svr1.postgresql.org (Postfix) with SMTP id DABBBD1B4E1 for ; Mon, 20 Oct 2003 11:44:00 -0300 (ADT) Received: (qmail 5845 invoked from network); 20 Oct 2003 14:50:03 -0000 Received: from dhcp-7-41.ma.lycos.com (HELO squeegit) (10.124.7.41) by dhcp-7-248.ma.lycos.com with SMTP; 20 Oct 2003 14:50:03 -0000 Date: Mon, 20 Oct 2003 10:49:46 -0400 From: Jeff To: Rhaoni Chiu Pereira Cc: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] Low Insert/Update Performance Message-Id: <20031020104946.575c5845.threshar@torgo.978.org> In-Reply-To: <1066659206.3f93ed86b9907@sistemica.info> References: <1066659206.3f93ed86b9907@sistemica.info> X-Mailer: Sylpheed version 0.9.7 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/230 X-Sequence-Number: 10791 On Mon, 20 Oct 2003 12:13:26 -0200 Rhaoni Chiu Pereira wrote: > Hi List, > > I got a P4 1.7Ghz , 512MB RAM , HD 7200 RPM, on RED HAT 9 running > PostgreSQL > 7.3.2-3 Database. [clip] Please send schema & queries or we will not be able to help you. Also, if you could provide explain analyze of each query it would be even more helpful! -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/