X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 62B1E9DC83E for ; Tue, 3 Jan 2006 21:33:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80197-07 for ; Tue, 3 Jan 2006 21:33:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from kiwi.adonten.net (kiwi.adonten.net [204.157.14.138]) by postgresql.org (Postfix) with ESMTP id 0C9BA9DC824 for ; Tue, 3 Jan 2006 21:33:07 -0400 (AST) Received: (qmail 417 invoked from network); 4 Jan 2006 01:32:11 -0000 Received: from localhost (127.0.0.1) by localhost with SMTP; 4 Jan 2006 01:32:11 -0000 Received: from 82-70-183-14.dsl.in-addr.zen.co.uk (82-70-183-14.dsl.in-addr.zen.co.uk [82.70.183.14]) by webmail.adontendev.net (IMP) with HTTP for ; Wed, 04 Jan 2006 01:32:11 +0000 Message-ID: <1136338331.43bb259b9334f@webmail.adontendev.net> Date: Wed, 04 Jan 2006 01:32:11 +0000 From: frank church To: pgsql-sql@postgresql.org Subject: Loading lots of data in a SQL command MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 82.70.183.14 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/11 X-Sequence-Number: 23800 I am load lots of data via SQL into a database and wrapping it into transactions speeds it up. However this fails a number of times. The queries results are logged so it is easy for me to find problem records. However a single failure causes the whole transaction to fail. Is there a setting or feature that allows which allows the same performance as transactions, without causing the whole process to fail, like a delayed updates or write mechanism of some sort. It is something I would like to set in that particular data looad. Frank ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.