Re: Does psql use nested transactions?

Hola Alvaro

On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz
<alvherre@dcc.uchile.cl> wrote:
> > On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > > The other objection is that this would create very substantial overhead.
> >
> > why?
> 
> Establishing a savepoint is a non-trivial operation (cost-wise).  Several
> internal server structures have to be prepared for it.  It's way cheaper than
> normal transaction start and commit, but undesirable anyway if done once per
> query.  Worse if it's going to be seldom used.

I see. So, any heavy use of savepoints, say, issuing one before each
SQL command that might violate a restriction, would worsen a lot the
performance of my application?

Saludos
Haroldo

-- 
Por favor registre haroldo.stenger@gmail.com como mi nueva y unica
direccion de correo en lugar de la vieja hstenger@adinet.com.uy
Please, record haroldo.stenger@gmail.com as my new and unique email
address instead of ye old hstenger@adinet.com.uy
Gracias. Thankyou.