From: Zalman Stern <zalman@netcom.com>
To: lists@mne.de
Cc: pgsql-sql@postgreSQL.org
Subject: Re: your mail
Date: Wed, 1 Sep 1999 23:44:40 -0700 (PDT)
Message-ID: <199909020644.XAA18312@netcom15.netcom.com> (raw)
In-Reply-To: <m11MPyy-000DMVC@darwin.oche.de>
I would either validate the data in the script, or batch the records into
bunches of 100 or 1000 or whatever inserts. If one of the batches fails,
then reprocess only that batch using individual inserts.
I believe using transactions of moderate size will be faster than using
really really huge ones. There are of course also transactional semantics
issues if you have concurrent access going on.
-Z-
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: zalman@netcom.com, lists@mne.de
Subject: Re: your mail
In-Reply-To: <199909020644.XAA18312@netcom15.netcom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox