Loading large amounts of data in a SQL command

Поиск
Список
Период
Сортировка
От frank church
Тема Loading large amounts of data in a SQL command
Дата
Msg-id 1136467890.43bd1fb254e81@webmail.adontendev.net
обсуждение исходный текст
Ответы Re: Loading large amounts of data in a SQL command  (Sean Davis <sdavis2@mail.nih.gov>)
Список 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 по дате отправления:

Предыдущее
От: |N_E_O|
Дата:
Сообщение: Problem with Starting server 7.4.10_1 on FreeBSD
Следующее
От: marcelo Cortez
Дата:
Сообщение: Re: copy from error