On 6/17/25 10:30, Marcin Gozdalik wrote:
Around 100 DBs, ranging from 1TB to 50TB.
Initial testing showed that it takes 1.5h to dump the DB and 3h to restore it for a DB of around 3TB.

Just recreating the indexes takes around 30 minutes on the same DBs.

I understand that pg_dump/pg_restore is the safe route but it's too slow for me so I'd like to understand if I have any alternative.

Alright I see the issue. I don't know enough about this to say whether directly altering the system catalog would be a safe operation or not. An answer to that is going to need to come from someone with more knowledge on Postgres internals then I.



--
Adrian Klaver
adrian.kla...@aklaver.com



Reply via email to