pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim Nasby <jim.nasby@gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Moving to Postgresql database
Date: Tue, 16 Jan 2024 12:36:13 -0600
Message-ID: <bd81fa1b-d00b-4c4f-9796-21509d8518c5@gmail.com> (raw)
In-Reply-To: <CANzqJaAG-3jeqS6+7PXsnVJE5CgpbAOfNoQL=nO2=Z5KsJwazw@mail.gmail.com>
References: <CAB+=1TUyxXeRbmz6oRC+96EjLAnW7Qvqmse4iSNtWgH5i21mQg@mail.gmail.com>
	<CAFCRh-9qkLTCWPssN4ZOvGj3JY3LceMKs2eaizx49b2Cx8019Q@mail.gmail.com>
	<40a34680-1583-4cff-86cb-2598be16bb80@aklaver.com>
	<CAFCRh-9Es2Ahgzetyu-46guwyGwPjaJXHfGpF0AG4zt7KDBjfw@mail.gmail.com>
	<8cbd791a-0688-49fb-a536-3b8c30b5109b@aklaver.com>
	<CANzqJaAG-3jeqS6+7PXsnVJE5CgpbAOfNoQL=nO2=Z5KsJwazw@mail.gmail.com>

On 1/16/24 11:59 AM, Ron Johnson wrote:
>      >      > Hi. One of the biggest pitfall of PostgreSQL, from the app-dev
>      >     perspective,
>      >      > is the fact any failed statement fails the whole
>     transaction, with
>      >      > ROLLBACK as the only recourse.
>      >
>      >     "SAVEPOINT establishes a new savepoint within the current
>     transaction.
>      >
>      >
>      > I wish it was that easy.
>      > I've been scared away from using them, after reading a few
>     articles...
>      > Also, that incurs extra round trips to the server, from the extra
>     commands.
> 
>     The point was that '...  with ROLLBACK as the only recourse.' is not
>     the
>     case. There is an alternative, whether you want to use it being a
>     separate question.
> 
> 
> Performance-killing alternatives are not really altternatives.

What's the actual performance issue here?

I'm also wondering what the use case for constantly retrying errors is.
-- 
Jim Nasby, Data Architect, Austin TX






view thread (18+ messages)  latest in thread

Message-ID: <bd81fa1b-d00b-4c4f-9796-21509d8518c5@gmail.com>
Permalink:  ../bd81fa1b-d00b-4c4f-9796-21509d8518c5@gmail.com/
Also on:    postgresql.org/message-id/bd81fa1b-d00b-4c4f-9796-21509d8518c5@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: jim.nasby@gmail.com, ronljohnsonjr@gmail.com
  Subject: Re: Moving to Postgresql database
  In-Reply-To: <bd81fa1b-d00b-4c4f-9796-21509d8518c5@gmail.com>
  References: <CAB+=1TUyxXeRbmz6oRC+96EjLAnW7Qvqmse4iSNtWgH5i21mQg@mail.gmail.com> <CAFCRh-9qkLTCWPssN4ZOvGj3JY3LceMKs2eaizx49b2Cx8019Q@mail.gmail.com> <40a34680-1583-4cff-86cb-2598be16bb80@aklaver.com> <CAFCRh-9Es2Ahgzetyu-46guwyGwPjaJXHfGpF0AG4zt7KDBjfw@mail.gmail.com> <8cbd791a-0688-49fb-a536-3b8c30b5109b@aklaver.com> <CANzqJaAG-3jeqS6+7PXsnVJE5CgpbAOfNoQL=nO2=Z5KsJwazw@mail.gmail.com> <bd81fa1b-d00b-4c4f-9796-21509d8518c5@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox