From: | Haroldo Stenger <haroldo(dot)stenger(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Does psql use nested transactions? |
Date: | 2004-08-17 23:21:13 |
Message-ID: | d33fde4e04081716212c359f16@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hola Alvaro
On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz
<alvherre(at)dcc(dot)uchile(dot)cl> wrote:
> > On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(dot)stenger(at)gmail(dot)com como mi nueva y unica
direccion de correo en lugar de la vieja hstenger(at)adinet(dot)com(dot)uy
Please, record haroldo(dot)stenger(at)gmail(dot)com as my new and unique email
address instead of ye old hstenger(at)adinet(dot)com(dot)uy
Gracias. Thankyou.
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2004-08-17 23:23:44 | Re: Does psql use nested transactions? |
Previous Message | Marc G. Fournier | 2004-08-17 23:10:52 | Re: stop the presses (Re: 7.4.4 packaged ...) |