Received: from sunpine.krs.ru (SunPine.krs.ru [195.161.16.37]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA84399 for ; Mon, 3 May 1999 09:29:09 -0400 (EDT) (envelope-from vadim@krs.ru) Received: from krs.ru (dune.krs.ru [195.161.16.38]) by sunpine.krs.ru (8.8.8/8.8.8) with ESMTP id VAA18850; Mon, 3 May 1999 21:29:00 +0800 (KRSS) Sender: root@sunpine.krs.ru Message-ID: <372DA49B.C25EDDD6@krs.ru> Date: Mon, 03 May 1999 21:28:59 +0800 From: Vadim Mikheev Organization: OJSC Rostelecom (Krasnoyarsk) X-Mailer: Mozilla 4.5 [en] (X11; I; FreeBSD 3.0-RELEASE i386) X-Accept-Language: ru, en MIME-Version: 1.0 To: Frank Morton CC: pgsql-sql@hub.org Subject: Re: [SQL] Slow Inserts Again References: <06b501be9567$e5941590$8355e5ce@base2inc.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Frank Morton wrote: > > 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: begin; insert ....; insert ....; ... insert ....; end; Vadim