On 10/8/26 12:05 AM, kavya chandren wrote:
Hi,
We have an oracle deployment running in 300+ TB. Apart from migration
challenges, do we foresee any operational challenges? I have not heard
of something huge prior. This would be highly helpful in planning further.
Why the change?
Is this a pricing issue or are you looking to get something else out of
the migration?
Few challenges which caught my attention include,
1. Backup, restore of such a large database
2. Recovery of a broken database (A lost replica)
3. Fixing a standby that lags a lot
4. Triggering a PITR with any backup tools
5. Maintenance at times
6. Finding equivalents of oracle items (which is common during any
oracle to postgres migration)
I dont see any limits in database/ objects as specified in https://
www.postgresql.org/docs/current/limits.html <https://www.postgresql.org/
docs/current/limits.html>
Thanks and Regards,
Kavya
--
Adrian Klaver
[email protected]
