Loading lots of data in a SQL command

Поиск
Список
Период
Сортировка
От frank church
Тема Loading lots of data in a SQL command
Дата
Msg-id 1136338331.43bb259b9334f@webmail.adontendev.net
обсуждение исходный текст
Ответы Re: Loading lots of data in a SQL command  (Richard Huxton <dev@archonet.com>)
Список pgsql-sql
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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Dan Tenenbaum
Дата:
Сообщение: getting a query column to return 0 if nothing matches
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: getting a query column to return 0 if nothing matches