pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Cherio <cherio@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17810: Update from 13.09 to 13.10 breaks SQLs with VACUUM
Date: Mon, 27 Feb 2023 13:11:02 -0500
Message-ID: <392516.1677521462@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKHqFkL3Ms6NzZ9_9UbpN3Qr0UKHdHisRH=JkeGYirYRhg0R7g@mail.gmail.com>
References: <17810-8eb7b4e1b7a68e1a@postgresql.org>
	<371962.1677515656@sss.pgh.pa.us>
	<CAKHqFkJsF8TOm0UV+-4=M98hc_D5qqqxFu3AY-mOyKrPuMMswQ@mail.gmail.com>
	<CAKHqFkJfO3-TA4YL_O0yw8EaKTGY9+2HFAiRgHpEu8q1abvesg@mail.gmail.com>
	<391334.1677520801@sss.pgh.pa.us>
	<CAKHqFkL3Ms6NzZ9_9UbpN3Qr0UKHdHisRH=JkeGYirYRhg0R7g@mail.gmail.com>

Cherio <cherio@gmail.com> writes:
> The second script should have tables used in the reversed order:
> UPDATE tableA
> UPDATE tableB

> and

> UPDATE tableB
> UPDATE tableA

> Since they will run in individual transactions tableA gets locked by the
> 1st script and tableB by the 2nd; as execution flow proceeds to the next
> update in each script, those tables would be locked in separate
> transactions.

I think you are working with a completely wrong mental model of what
this change did.  It will not affect a pipeline that doesn't contain
any VACUUM, ANALYZE, or similar maintenance commands.

			regards, tom lane

view thread (14+ messages)  latest in thread

Message-ID: <392516.1677521462@sss.pgh.pa.us>
Permalink:  ../392516.1677521462@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/392516.1677521462@sss.pgh.pa.us

copy link · copy postgr.es

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 using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, cherio@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #17810: Update from 13.09 to 13.10 breaks SQLs with VACUUM
  In-Reply-To: <392516.1677521462@sss.pgh.pa.us>

* 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