If you can batch the inserts into groups (of say 10 to 100) it might
help performance - i.e:
Instead of
INSERT INTO table VALUES(...);
INSERT INTO table VALUES(...);
...
INSERT INTO table VALUES(...);
do
INSERT INTO table VALUES(...),(...),...,(...);
This reduces the actual number of INSERT calls, which can be quite a win.
Regards
Mark
On 28/01/12 07:30, Jayashankar K B wrote:
Hi Heikki Linnakangas: We are using series of Insert statements to insert the records into database.
Sending data in binary is not an option as the module that writes into DB has been finalized.
We do not have control over that.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance