>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
TL> Everything is always a transaction in Postgres. If you don't say
TL> begin/end, then there's an implicit begin and end around each individual
TL> query. So your first set of tests were paying transaction commit
TL> overhead for each insert.
This doesn't seem to hold exactly for INSERTs involving sequences as
default values. Even if the insert fails for some other constraint,
the sequence is incremented.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/