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 по дате отправления: