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
===================================================
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 |
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 |