[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [HACKERS] Oracle vs PostgreSQL in real life
From: Antonio Sergio de Mello e Souza <asergioz () bol ! com ! br>
Date: 2002-02-28 18:18:29
[Download RAW message or body]
Jean-Paul ARGUDO wrote:
>As I wrote it before there, it is an ECPG script that runs with bad perfs.
>I put back trace/ notices/debug mode on the server.
>
>Here is an example of what does the debug doesnt stop to do:
>
>c... stuffs are CURSORS
>
>it seems that on every commit, the cursor is closed
>
>[... snip ...]
>NOTICE: Closing pre-existing portal "csearcht04"
>
...
>NOTICE: Closing pre-existing portal "cfindplu"
>NOTICE: Closing pre-existing portal "cfindplu"
>NOTICE: Closing pre-existing portal "cfindplu"
>[... snip ...]
>
>c... stuffs are CURSORS
>
>it seems that on every commit, the cursor is closed... and re-opened with new
>variables'values
>
By default, Postgres executes transactions in autocommit mode.
This means that each statement is executed in its own transaction and a
commit is performed
at the end of the statement, what is much slower than executing all
statements inside a
begin ... commit block.
To disable the autocommit mode you have to compile the ECPG script with
the -t option.
I Hope that it helps.
Regards,
Antonio Sergio
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic