Better way to load data to table

From: Wenjin Zheng <wenjin(dot)zheng(at)lsbc(dot)com>
To: hackers(at)postgresql(dot)org
Subject: Better way to load data to table
Date: 2000-07-10 15:49:11
Message-ID: E3E65B3C4E12D311BE6900A0C9EC2FA1277AD8@GENOMICS1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)zheng(at)lsbc(dot)com

Browse pgsql-hackers by date

  From Date Subject
Next Message eisentrp 2000-07-10 16:08:24 Re: Templates
Previous Message Tom Lane 2000-07-10 15:44:45 Re: postgres fe/be protocol