Re: Oracle vs PostgreSQL in real life

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Jean-Paul ARGUDO <jean-paul(dot)argudo(at)idealx(dot)com>
Cc: Hannu Krosing <hannu(at)krosing(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Oracle vs PostgreSQL in real life
Date: 2002-03-01 08:05:07
Message-ID: 20020301080507.GB17165@feivel.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Feb 28, 2002 at 10:32:48AM +0100, Jean-Paul ARGUDO wrote:
> As I wrote it before there, it is an ECPG script that runs with bad perfs.
> ...
> it seems that on every commit, the cursor is closed

Cursors shouldn't be closed, but prepared statements are deallocated on each
commit. AFAIK this is what the standard says.

Michael
--
Michael Meskes
Michael(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2002-03-01 08:12:41 Re: Oracle vs PostgreSQL in real life
Previous Message Michael Meskes 2002-03-01 08:03:12 Re: Oracle vs PostgreSQL in real life