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