MIME-Version: 1.0
References: <CAFCRh-8g-41VhdbbbnP+eezFq1UJ6T2JdQ=iS60hcaqGoJ=x9w@mail.gmail.com>
 <2701260.1740065273@sss.pgh.pa.us> <CAFCRh-8YN2GUkpo8PkdouGf55FzzkjAhV8t-gj0i5zfbz8i_fg@mail.gmail.com>
In-Reply-To: <CAFCRh-8YN2GUkpo8PkdouGf55FzzkjAhV8t-gj0i5zfbz8i_fg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Thu, 20 Feb 2025 11:07:02 -0500
Message-ID: <CAKAnmmLE-PhxTvB-fEOc3X=MhbH2R-HA9yRp0xnNO4coGRB0Ng@mail.gmail.com>
Subject: Re: #XX000: ERROR: tuple concurrently updated
To: Dominique Devienne <ddevienne@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c8e406062e9512d7"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLE-PhxTvB-fEOc3X%3DMhbH2R-HA9yRp0xnNO4coGRB0Ng%40mail.gmail.com>
Precedence: bulk

--000000000000c8e406062e9512d7
Content-Type: text/plain; charset="UTF-8"

Since you are willing to break the all one transaction rule, and if the
restores were created via pg_dump, you could use the --section argument to
split things up, run the "pre-data" sections serially, and the rest ("data"
and "post-data") concurrently.

-- 
Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000c8e406062e9512d7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Since you are willing to break the all on=
e transaction rule, and if the restores were created via pg_dump, you could=
 use the --section argument to split things up, run the &quot;pre-data&quot=
; sections serially, and the rest (&quot;data&quot; and &quot;post-data&quo=
t;) concurrently.</div><div dir=3D"ltr"><br></div><span class=3D"gmail_sign=
ature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div=
 dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div><br></div><div>--</div><=
div>Crunchy Data - <a href=3D"https://www.crunchydata.com" target=3D"_blank=
">https://www.crunchydata.com</a></div><div>Enterprise Postgres Software Pr=
oducts &amp; Tech Support</div><div><br></div></div></div></div>

--000000000000c8e406062e9512d7--