Re: Best Approach for Swapping a Table with its Copy

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Best Approach for Swapping a Table with its Copy
Дата
Msg-id CAKAnmm+XYQB71q8=x169XH0ujWsW6wxhZ-h1rZnwjyBPOa18jQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Best Approach for Swapping a Table with its Copy  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления: