Re: Re: Query precompilation? - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: Re: Query precompilation?
Date
Msg-id 01022718341200.00770@wotan
Whole thread Raw
In response to Re: Query precompilation?  (Robert Schrem <Robert.Schrem@WiredMinds.de>)
List pgsql-hackers
(...)
> >
> > I don't care about integrity etc!
>
> You should !-)
>
> You can find some valueable tips in the documentation:
> http://www.de.postgresql.org/users-lounge/docs/7.0/user/c4929.htm
>

In the docs there is this paragraph:
>Disable Auto-commit
>
> Turn off auto-commit and just do one commit at the end. Otherwise Postgres 
>is doing a lot of work for each record added. In general when you are doing 
>bulk inserts, you want to turn off some of the database features to gain 
>speed. 

This sounds nice, but I've read a lot of postgres documents and still do not 
know how to disable autocommit. Is this possible? And how?

Mario Weilguni

-- 
===================================================Mario Weilguni                               KPNQwest Austria GmbH
 Senior Engineer Web Solutions                         Nikolaiplatz 4
 tel: +43-316-813824                                8020 graz, austria
 fax: +43-316-813824-26                    http://www.kpnqwest.at
 e-mail: mario.weilguni@kpnqwest.com
===================================================


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Re[3]: Re: [PATCHES] A patch for xlog.c
Next
From: Tom Lane
Date:
Subject: Re: SunOS4