On Wed, Oct 27, 2010 at 21:08, Divakar Singh <[email protected]> wrote: > So another question pops up: What method in PostgreSQL does the stored proc > use when I issue multiple insert (for loop for 100 thousand records) in the > stored proc?
It uses prepared statements (unless you are using execute). There is also the benefit of not being on the network. Assuming 0.3ms avg latency, 1 packet per query and 100,000 queries-- thats 30s just from latency! Granted this is just a silly estimate that happens to (more or less) fit my numbers... -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
