Re: [HACKERS] Postgres Speed or lack thereof

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tom <tom(at)sdf(dot)com>
Cc: John Holland <jholland(at)isr(dot)umd(dot)edu>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Postgres Speed or lack thereof
Date: 1999-01-18 04:21:45
Message-ID: 25968.916633305@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom <tom(at)sdf(dot)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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-01-18 04:51:14 Re: [HACKERS] drop before create in pg_dump
Previous Message Tom Lane 1999-01-18 03:34:39 Re: [HACKERS] Postgres Speed or lack thereof