Re: [HACKERS] Postgres Speed or lack thereof

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tom <tom@sdf.com>
Cc: John Holland <jholland@isr.umd.edu>, pgsql-hackers@postgreSQL.org
Date: 1999-01-18T04:21:45Z
Lists: pgsql-hackers
Tom <tom@sdf.com> writes:
> 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?

Sorry, I neglected to specify that it was psql (being driven by
hand-trimmed pg_dump scripts).

> Some APIs control autocommit for you, so execing
> "BEGIN" and "END" commands may not do anything.

That's not the case for psql.  If it were, I would have measured no
difference in speed, rather than a small difference.

			regards, tom lane