Autocommit

From: Hasnul Fadhly bin Hasan <hasnulfadhly(dot)h(at)mimos(dot)my>
To: pgsql-performance(at)postgresql(dot)org
Subject: Autocommit
Date: 2005-02-14 08:01:20
Message-ID: 42105AD0.2010803@mimos.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I am just wondering, by default, autocommit is enabled for every client
connection. The documentations states that we have to use BEGIN
and END or COMMIT so to increase performance by not using autocommit.
My question is, when we use the BEGIN and END statements, is autocommit
unset/disabled automatically or we have to disable/unset it manually?

Hasnul

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Fuhr 2005-02-14 08:47:03 Re: Autocommit
Previous Message Mark Kirkwood 2005-02-14 03:45:58 Re: estimated rows vs. actual rows