MIME-Version: 1.0
References: <CAM2F1VP9nn0F6fSjbmhJCNSjv-dbAJcAytZ2HkTkZ0dGYZvxrw@mail.gmail.com>
 <8ac6a1dd-db82-4ea7-8186-0c354d79049f@aklaver.com> <CAM2F1VOOn1izCrtcrDx4YUtCY-H64Vj5yvN5H1Lhk8kCY+_W6Q@mail.gmail.com>
 <9fa75099-1ee9-43de-ac6e-945841b184eb@aklaver.com> <CAM2F1VONo8M9gcybhmf8-CdmRUC2QrFGZkZLYF-+uLZuhRKaxQ@mail.gmail.com>
 <22406cdf-83f5-4b98-b07e-7827afe97f93@aklaver.com> <CAM2F1VMdDSxLhccn=0pXriJrR6a7Oe9Kir1DB_0pW1v88bsvCg@mail.gmail.com>
 <CAKAnmmJ04kH_gWR+cOFWD0h63RDck1k6hqQYH8K30-cfCvtO_Q@mail.gmail.com>
 <CAFCRh-9xC0CXKM2GTQBfjYY5GQx29Uit+fY5PpBFTvX927YC8w@mail.gmail.com>
 <94e1205e-8ddf-403b-8477-02d7939f2905@aklaver.com> <CAM2F1VMApyPvdA4ERoF7Fob6CXimgOWMKC1vayO5OQa3TtJAFQ@mail.gmail.com>
 <CAM2F1VNnm_x5F7xSKcv6x-hQHY-zxvFgyAdrdwTaQ9ZTVUQ3pQ@mail.gmail.com>
In-Reply-To: <CAM2F1VNnm_x5F7xSKcv6x-hQHY-zxvFgyAdrdwTaQ9ZTVUQ3pQ@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Fri, 14 Feb 2025 10:11:48 -0500
Message-ID: <CAKAnmmJ0=9m3gXvjvWVAbyJpU=Uopn1K5sQDOPWJG7GNRctPmg@mail.gmail.com>
Subject: Re: Best Approach for Swapping a Table with its Copy
To: Marcelo Fernandes <marcefern7@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, Dominique Devienne <ddevienne@gmail.com>, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000c8a18062e1b9ab0"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmJ0%3D9m3gXvjvWVAbyJpU%3DUopn1K5sQDOPWJG7GNRctPmg%40mail.gmail.com>
Precedence: bulk

--0000000000000c8a18062e1b9ab0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Feb 13, 2025 at 6:06=E2=80=AFPM Marcelo Fernandes <marcefern7@gmail=
.com>
wrote:

> > It's technically possible to do something similar for your use case, bu=
t
> it's not trivial. All the cab to trailer wires must be precisely changed.
> Everything directly related to the data must be swapped: heap, indexes,
> toast.
>
> I'd really appreciate to know more about how I can do this, as I think
> this is
> the crux of what I am trying to solve.
>

The pg_repack link posted earlier has the details on how it is done. But
messing with system catalogs like this is highly discouraged, for good
reasons. Still, if you need to go that route, test heavily and post the
solutions here for feedback.

Cheers,
Greg

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Feb 13, 2025 at 6:06=E2=80=AFPM M=
arcelo Fernandes &lt;<a href=3D"mailto:marcefern7@gmail.com">marcefern7@gma=
il.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex">&gt; It&#39;s technicall=
y possible to do something similar for your use case, but it&#39;s not triv=
ial. All the cab to trailer wires must be precisely changed. Everything dir=
ectly related to the data must be swapped: heap, indexes, toast.<br>
<br>
I&#39;d really appreciate to know more about how I can do this, as I think =
this is<br>
the crux of what I am trying to solve.<br></blockquote><div><br></div><div>=
The pg_repack link posted earlier has the details on how it is done. But me=
ssing with system catalogs like this is highly discouraged, for good reason=
s. Still, if you need to go that route, test heavily and post the solutions=
 here for feedback.</div><div><br></div><div>Cheers,</div><div>Greg</div><d=
iv><br></div></div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"l=
tr"><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com=
" target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise Po=
stgres Software Products &amp; Tech Support</div><div><br></div></div></div=
></div>

--0000000000000c8a18062e1b9ab0--