Re: [HACKERS] Postgres Speed or lack thereof - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Postgres Speed or lack thereof
Date
Msg-id 25968.916633305@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Postgres Speed or lack thereof  (Tom <tom@sdf.com>)
Responses Re: [HACKERS] Postgres Speed or lack thereof  (Tom <tom@sdf.com>)
List 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


pgsql-hackers by date:

Previous
From: Tom
Date:
Subject: Re: [HACKERS] Postgres Speed or lack thereof
Next
From: Tom
Date:
Subject: Re: [HACKERS] Postgres Speed or lack thereof