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