Re: [GENERAL] Performance issue during multiple insertions

2011-11-03 Thread Alex Lai
Siva Palanisamy wrote: Hi All. I basically have 3 tables. One being the core table and the other 2 depend on the 1st. I have the requirement to add upto 7 records in all the tables. I do have constraints (primary & foreign keys, index, unique etc) set for the tables. I can't go for bulk

[GENERAL] Performance issue during multiple insertions

2011-11-03 Thread Siva Palanisamy
Hi All. I basically have 3 tables. One being the core table and the other 2 depend on the 1st. I have the requirement to add upto 7 records in all the tables. I do have constraints (primary & foreign keys, index, unique etc) set for the tables. I can't go for bulk import (using COPY command)