On Thu, Feb 13, 2025 at 6:06 PM Marcelo Fernandes <marcefe...@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 -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support
