X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D9C68D1C4B8 for ; Wed, 13 Aug 2003 06:39:24 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 77730-09 for ; Wed, 13 Aug 2003 03:37:48 -0300 (ADT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id BF3D3D1C47A for ; Wed, 13 Aug 2003 03:39:10 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h7D6cwLt028010; Wed, 13 Aug 2003 14:38:58 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <1f8901c36166$b50cf6b0$2800a8c0@mars> From: "Christopher Kings-Lynne" To: =?iso-8859-1?Q?Dennis_Bj=F6rklund?= , "mixo" Cc: "Bjoern Metzdorf" , References: Subject: Re: Perfomance Tuning Date: Wed, 13 Aug 2003 14:47:03 +0800 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.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/229 X-Sequence-Number: 3046 > So, group the inserts in transactions with maybe 1000 commands each. It > will go much faster. It can then cache the rows and in the end just make > sure all 1000 have been written out on disk. More than that, he should be using COPY - it's 10x faster than even grouped inserts. Chris