Skip site navigation (1) Skip section navigation (2)

Re: Oracle vs PostgreSQL in real life

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 (view raw or flat)
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


In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2002-02-28 19:20:08
Subject: Re: elog() patch
Previous:From: Tom LaneDate: 2002-02-28 18:05:37
Subject: Re: Defunct postmasters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group