Better way to load data to table

Поиск
Список
Период
Сортировка
Искать
От
Wenjin Zheng
Тема
Better way to load data to table
Дата
Msg-id
E3E65B3C4E12D311BE6900A0C9EC2FA1277AD8@GENOMICS1
Список
Hi;

I have a table that has four fields as float8[].  I have a serial new data
for each array.  Each time I have new data I have to update more than 6000
rows for all four field.  But using "update (ta ble)" to load in the new
data is just too slow.  Does anybody know a more efficient way to update
large data set in an array?

Thanks for help.

Wenjin Zheng, Ph.D.
Bioinformatic Analyst
Large Scale Biology, Corp.
Vacaville, CA 95688
wenjin.zheng@lsbc.com 

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: postgres fe/be protocol
От: eisentrp@csis.gvsu.edu
Дата:
Сообщение: Re: Templates
FAQ