Fastest method to insert data.

Поиск
Список
Период
Сортировка
От Sam Varshavchik
Тема Fastest method to insert data.
Дата
Msg-id courier.3CC06C59.0000511D@ny.email-scan.com
обсуждение исходный текст
Список pgsql-jdbc
What would be the fastest way to insert a bunch of data (in 7.1)?
Currently, a bunch of addBatch()es followed by executeBatch() is pretty
fast, but not as fast as COPY TABLE via psql.  I suppose I can use a single
executeBatch() to insert the entire table, but AFAIK addBatch() just buffers
the SQL in memory, and I prefer to have some kind of an upper limit on my
memory footprint.


--
Sam


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

Предыдущее
От: "Marin Dimitrov"
Дата:
Сообщение: Re: BLOB performance test FYI
Следующее
От: Barry Lind
Дата:
Сообщение: Re: Fastest method to insert data.