| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] What is the syntax turn off auto commit? |
| Date: | 2001-07-18 18:18:55 |
| Message-ID: | Pine.BSF.4.21.0107181118130.30757-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wed, 18 Jul 2001, Raymond Chui wrote:
>
>
> The Subject says its all.
>
> To speed up a bulk of INSERTs, I need to turn-off the auto commit 1st.
> Then
> at the end of INSERTs, issue COMMIT;
> What is the syntax to turn off the auto commit? Thank you!
Put them in an explicit transaction block
begin
insert ...
insert ...
commit;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan C. Bonham | 2001-07-18 18:19:54 | RE: THIS IS NOT RELATED TO THE RDBMS BUT PLEEEEEEEEEEEE EASE |
| Previous Message | Stephan Szabo | 2001-07-18 18:17:38 | Re: VACUUM ANALYZE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-18 20:34:58 | Re: pl/pgsql - code review + question |
| Previous Message | Nils Zonneveld | 2001-07-18 16:49:30 | Re: Records exactly the same. |