Hello!
One important use case in my libpq based application (PostgreSQL 8.1.4) is a sort of massive data loading.
Currently it is implemented as a series of plain normal INSERTs
(binary form of PQexecParams is used) and the problem here it is pretty slow.
I've tried to play with batches and with peculiar constructions
like INSERT (SELECT .. UNION ALL SELECT ..) to improve performance, but not satisfied with the result I've got.
Now I try to figure out if it is possible to use COPY FROM STDIN instead of INSERT if I have to insert, say, more then
100records at once.
Hints are highly appreciated.
The only limitaion mentioned in Manual is about Rules and I don't care about this since I don't use Rules.
Am I going to come across with any other problems (concurrency, reliability, compatibility, whatever) on this way?
Many thanks.
--
Best regards
Ilja Golshtein