I am doing twice as big imports daily, and found the follwing method
most efficient (other than using copy):
- Use plpgsql function to do the actual insert (or update/insert if
needed).
- Inside a transaction, execute SELECT statements with maximum possible
number of insert function calls in one go. This minimizes the number
of round trips between the client and the server.
Thanks Teemu! could you paste an example of one of those functions? ;-)
An example of those SELECTS also would be great, I'm not sure I have
completly understood what you mean.
--
Arnau
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
