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 | CAKAnmmJ0=9m3gXvjvWVAbyJpU=Uopn1K5sQDOPWJG7GNRctPmg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Best Approach for Swapping a Table with its Copy (Marcelo Fernandes <marcefern7@gmail.com>) |
| Ответы |
Re: Best Approach for Swapping a Table with its Copy
|
| Список | pgsql-general |
On Thu, Feb 13, 2025 at 6:06 PM Marcelo Fernandes <marcefern7@gmail.com> wrote:
> It's technically possible to do something similar for your use case, but 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
В списке pgsql-general по дате отправления: