Re: Re: Query precompilation?

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: Re: Query precompilation?
Дата
Msg-id 01022718341200.00770@wotan
обсуждение исходный текст
Ответ на Re: Query precompilation?  (Robert Schrem <Robert.Schrem@WiredMinds.de>)
Список 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 по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: Re[3]: Re: [PATCHES] A patch for xlog.c
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SunOS4