Hola Alvaro

On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz
<[EMAIL PROTECTED]> wrote:
> > On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] como mi nueva y unica
direccion de correo en lugar de la vieja [EMAIL PROTECTED]
Please, record [EMAIL PROTECTED] as my new and unique email
address instead of ye old [EMAIL PROTECTED]
Gracias. Thankyou.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to