On Wed, Oct 27, 2010 at 21:08, Divakar Singh <dpsmails(at)yahoo(dot)com> 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...