Re: Bulk-copy?

Поиск
Список
Период
Сортировка
От Alfred Perlstein
Тема Re: Bulk-copy?
Дата
Msg-id 20000602015619.I17973@fw.wintelcom.net
обсуждение исходный текст
Ответ на Bulk-copy?  (Thomas Weholt <Thomas@cintra.no>)
Список pgsql-novice
* Thomas Weholt <Thomas@cintra.no> [000602 01:45] wrote:
> Hi,
>
> I need to insert about 2000-10000 records into a database. I`m using Python
> to do this. Is there a way to use some form of bulk copy that will do this
> faster than plain-old insert for each and every record?

I don't know if there's python bindings for it, but you may want to look
to at the COPY stuff in the manuals, it's helped me quite a bit.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

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

Предыдущее
От: Alfred Perlstein
Дата:
Сообщение: Re: Performance - fsync-off
Следующее
От: "Anthony E. Greene"
Дата:
Сообщение: [OT] How to avoid using Reply-All on this list