Better way to load data to table - Mailing list pgsql-hackers

From Wenjin Zheng
Subject Better way to load data to table
Date
Msg-id E3E65B3C4E12D311BE6900A0C9EC2FA1277AD8@GENOMICS1
Whole thread Raw
List pgsql-hackers
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres fe/be protocol
Next
From: eisentrp@csis.gvsu.edu
Date:
Subject: Re: Templates