On Wed, Oct 27, 2010 at 21:08, Divakar Singh <dpsmails@xxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
