From: | Antonio Sergio de Mello e Souza <asergioz(at)bol(dot)com(dot)br> |
---|---|
To: | Jean-Paul ARGUDO <jean-paul(dot)argudo(at)idealx(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Oracle vs PostgreSQL in real life |
Date: | 2002-02-28 18:18:29 |
Message-ID: | 3C7E7475.4060602@bol.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-02-28 19:20:08 | Re: elog() patch |
Previous Message | Tom Lane | 2002-02-28 18:05:37 | Re: Defunct postmasters |