Re: [PERFORM] Optimization required for multiple insertions in PostgreSQL

2011-11-03 Thread Kevin Grittner
[Please keep the list copied.] siva palanisamy wrote: > Could you pls guide me on how to minimize time consumption? I've > postgresql 8.1.4; Linux OS. Well, the first thing to do is to use a supported version of PostgreSQL. More recent releases perform better, for starters. http://wiki.pos

Re: [PERFORM] Optimization required for multiple insertions in PostgreSQL

2011-11-03 Thread Tomas Vondra
On 3 Listopad 2011, 16:52, siva palanisamy wrote: > 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 the > tables. > I do have constraints (primary & foreign keys, index, unique etc) set for > the tables. I

Re: [PERFORM] Optimization required for multiple insertions in PostgreSQL

2011-11-03 Thread Kevin Grittner
siva palanisamy wrote: > 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 the tables. I do have constraints (primary & foreign > keys, index, unique etc) set for the tables. I can't go for bulk > import

[PERFORM] Optimization required for multiple insertions in PostgreSQL

2011-11-03 Thread siva palanisamy
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 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) as there is no