Received: from double.nlr.ru (double.nlr.ru [212.193.3.3]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA20815 for ; Sat, 22 Jan 2000 16:13:34 -0500 (EST) (envelope-from gav@nlr.ru) Received: from 212.193.3.34 ([212.193.3.34]) by double.nlr.ru (8.9.3/8.9.3) with ESMTP id AAA18482 for ; Sun, 23 Jan 2000 00:04:38 +0300 Date: Sun, 23 Jan 2000 00:15:52 +0300 From: gav X-Mailer: The Bat! (v1.34a) UNREG / CD5BF9353B3B7091 Reply-To: gav X-Priority: 3 (Normal) Message-ID: <1611.000123@nlr.ru> To: pgsql-sql@postgresql.org Subject: how many inserts in one transaction? Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I have a database created in postgres 6.5.3 and need insert huge number (~10-100 thousands) of rows in one of tables. To do that quickly I put this part of work in transaction. My question is such: should I split this block of insertings into many transaction to raise the speed? And exists the limit of INSERT-commands that I can do in one transaction? Best regards, Alex