Re: Best Approach for Swapping a Table with its Copy - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Best Approach for Swapping a Table with its Copy
Date
Msg-id CAKAnmm+XYQB71q8=x169XH0ujWsW6wxhZ-h1rZnwjyBPOa18jQ@mail.gmail.com
Whole thread Raw
In response to Re: Best Approach for Swapping a Table with its Copy  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
On Fri, Feb 14, 2025 at 12:41 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
Moreover, you have to make sure to send out invalidation messages so that every session that caches statistics or
execution plans for the tables discards them.

Hmm...is that really necessary? Because if so, there is no direct SQL-level way to do that I am aware of, so we are back to a C extension. Or just restarting the cluster :)

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Best Approach for Swapping a Table with its Copy
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Best Approach for Swapping a Table with its Copy