Horton

Re: [HACKERS] Postgres Speed or lack thereof

Tom Samplonius <tom@sdf.com>

View thread
From: Tom <tom@sdf.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: John Holland <jholland@isr.umd.edu>, pgsql-hackers@postgresql.org
Date: 1999-01-18T03:14:05Z
Lists: pgsql-hackers 
On Sun, 17 Jan 1999, Tom Lane wrote:

> I tried this myself and found that wrapping BEGIN/END around a series of
> INSERT statements didn't make much difference at all.

  Using what API?  Some APIs control autocommit for you, so execing
"BEGIN" and "END" commands may not do anything.  You might want to check
your API for a way to set autocommit off.  In fact, I would suggest that
you never use BEGIN and END except via cli.

Tom