Fast Insert and Update (through COPY)

[Yan Cheng CHEOK <yccheok@xxxxxxxxx>]

Previously, I am inserting a bulk of data by using the following way.

for each item
    update item into table
    if row count is 0
        insert items into table

I realize I am suffering performance problem.

Later, I realize it is much fast by using 

COPY

I am very happy with the speed.

Later, I realize that COPY doesn't work well, if I already have a row with same unique key. What I did is

# Try to remove old rows first
delete row where <condition>
# And perform really fast insertion
COPY

I was wondering, is this a common technique being use for fast bulk data insertion? Is there other techniques.

Thanks and Regards
Yan Cheng CHEOK


      

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general