Re: your mail

From: Zalman Stern <zalman(at)netcom(dot)com>
To: lists(at)mne(dot)de (Martin Neumann)
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: your mail
Date: 1999-09-02 06:44:40
Message-ID: 199909020644.XAA18312@netcom15.netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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-

In response to

  • at 1999-09-02 06:04:24 from Martin Neumann

Browse pgsql-sql by date

  From Date Subject
Next Message Anatoly K. Lasareff 1999-09-02 07:59:11 Re: none
Previous Message Martin Neumann 1999-09-02 06:04:24