Loading large amounts of data in a SQL command - Mailing list pgsql-general

From frank church
Subject Loading large amounts of data in a SQL command
Date
Msg-id 1136467890.43bd1fb254e81@webmail.adontendev.net
Whole thread Raw
Responses Re: Loading large amounts of data in a SQL command  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-general

I am loading lots of data via SQL into a database and wrapping it into
transactions to speed it up.

This fails a number of times and causes the whole transaction to fail. The
queries results are logged so it is easy for me to find problem records.

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?

Frank

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


pgsql-general by date:

Previous
From: |N_E_O|
Date:
Subject: Problem with Starting server 7.4.10_1 on FreeBSD
Next
From: marcelo Cortez
Date:
Subject: Re: copy from error