We have some large tables created a long time ago with OIDs. Are there any replication methods/tools available for large tables (within the same DB) without any performance hit? Once the tables are caught up, I can take a small downtime to swap large tables to new tables (without OIDs).
The end goal is to upgrade from version 11.9 to 12.4. Right now, OIDs are stopping us from upgrading as OIDs are not supported in version 12. I came up with a script to get rid of the OIDs (as we are not using them) to run in parallel. But we have some big tables and this process itself is taking 4 to 6 hours. We can’t afford to have downtime more than 1 hour.
All my script does is the following for each table.
ALTER TABLE ONLY SET WITHOUT OIDS;
This is a busy DB with 24X7 availability. Any help in this regard is appreciated.