X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 36660D1C9F3 for ; Wed, 7 Apr 2004 07:41:17 -0300 (ADT) 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 28071-04 for ; Wed, 7 Apr 2004 07:41:13 -0300 (ADT) Received: from gizmo08bw.bigpond.com (gizmo08bw.bigpond.com [144.140.70.18]) by svr1.postgresql.org (Postfix) with SMTP id 8F672D1BCB8 for ; Wed, 7 Apr 2004 07:41:09 -0300 (ADT) Received: (qmail 17836 invoked from network); 7 Apr 2004 10:31:59 -0000 Received: from unknown (HELO bwmam08.bigpond.com) (144.135.24.91) by gizmo08bw.bigpond.com with SMTP; 7 Apr 2004 10:31:59 -0000 Received: from cpe-203-45-197-156.qld.bigpond.net.au ([203.45.197.156]) by bwmam08.bigpond.com(MAM REL_3_4_2 135/13709782) with SMTP id 13709782; Wed, 07 Apr 2004 20:41:09 +1000 Message-ID: <001c01c41c8c$993eded0$fd08a8c0@steve> From: "Steven Butler" To: "huang yaqin" Cc: References: <0HVS00G7FMQO35@mail.gthome.com> Subject: Re: good pc but bad performance,why? Date: Wed, 7 Apr 2004 20:39:25 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/80 X-Sequence-Number: 6380 It sounds almost like you're doing one insert per transaction. Try wrapping multiple inserts into a single transaction and see if that helps. This may not be appropriate for your application, but it does guarantee that committed transactions will not be lost. My apologies if you are already doing this. :) BEGIN; insert ... insert ... insert ... COMMIT; Regards, Steve Butler ----- Original Message ----- From: "huang yaqin" To: "Richard Huxton" Cc: Sent: Wednesday, April 07, 2004 6:56 PM Subject: Re: [PERFORM] good pc but bad performance,why? Hello, Richard Huxton, You said turning fsync off may cause losing data, that's terrible. I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't get any improvement. So what can I do? Does SCSI disk and IDE disk have difference? Regards, Huang yaqin