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.

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

Thanks and Regards,
Kavya

Reply via email to