Re: Re: Query precompilation?

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: Query precompilation?
Date: 2001-02-27 18:39:43
Message-ID: 01022718341200.00770@wotan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(dot)weilguni(at)kpnqwest(dot)com
===================================================

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2001-02-27 18:52:30 Re: vacuum and backup
Previous Message Doug McNaught 2001-02-27 18:37:08 Re: vacuum and backup

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-27 19:13:22 Re: SunOS4
Previous Message The Hermit Hacker 2001-02-27 17:26:03 Re: Re[3]: Re: [PATCHES] A patch for xlog.c