[GENERAL] COPY performance...

hello,

still with my copy problem.....

i've analysed the problem and noticed that it's the after Trigger that
takes long to execute...
this trigger call a plpgsql function.....
if this function is coded in C, will it be really faster?

this function update (or insert if not exist) a linked table with data
from the table being copied...

i tried to add an index on the referenced column in the updated table
but performance are not improved.....
why?

is there another way to make it work faster?

(i'm using Postgres 6.5.2 on Debian)
thanks
--
______________________________
Arnaud FLORENT
IRIS Technologies

phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90

mailto:aflorent(at)iris-tech(dot)fr
______________________________