Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id JAA87580 for ; Mon, 3 May 1999 09:49:03 -0400 (EDT) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@hub.org id m10eJ8l-000EBPC; Mon, 3 May 99 15:52 MET DST Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] Slow Inserts Again To: fmorton@base2inc.com (Frank Morton) Date: Mon, 3 May 1999 15:52:11 +0200 (MET DST) Cc: vadim@krs.ru, pgsql-sql@hub.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: <06c001be956b$e35db0c0$8355e5ce@base2inc.com> from "Frank Morton" at May 3, 99 08:50:21 am X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > >> This last attempt, I bracket each insert statement with > > ^^^^^^^^^^^^^^^^^^^^^ > >> "begin;" and "end;". > > > >Why _each_? > >Enclose ALL statements by begin; & end; to insert ALL data > >in SINGLE transaction: > > This was suggested by someone on the list so that all > 150,000 inserts would not be treated as one large transaction. > > Like I said before, I have tried all suggestions without success. For huge amounts of data I usually group the inserts into chunks of 1000 or so and enclose the chunks by BEGIN/END. Have you tried that already? Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #