Postgres Pro
Downloads
Home   >   mailing lists

Thread: ECPG BUlk insert support using arrays

ECPG BUlk insert support using arrays

From
Haribabu Kommi
Date:
Hi All,


I didn't find any relevant thread about the discussion of Bulk insert
support in ECPG using arrays. Oracle supports the same and details
are available in [1].


I see some performance benefits in supporting the same in ECPG also.
Does any one worked on this area before? Are there any problems in
preparing a patch to support the same?




Regards,
Hari Babu
Fujitsu Australia

Re: ECPG BUlk insert support using arrays

From
"Tsunakawa, Takayuki"
Date:
From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Haribabu Kommi
> I didn't find any relevant thread about the discussion of Bulk insert support
> in ECPG using arrays. Oracle supports the same and details are available
> in [1].
> 
> 
> I see some performance benefits in supporting the same in ECPG also.
> Does any one worked on this area before? Are there any problems in preparing
> a patch to support the same?

Please see "batch/pipelining support for libpq" by Craig.  I said I'll use his API to implement the array insert for
ECPG,but you can feel free to do it.
 

Regards
Takayuki Tsunakawa