Re: Challenges with huge postgresql deployments in 300+ TBs

Hi Kavya,

I also do not expect any major issues and as you have experience running this in Oracle, you are probably well versed enough.

Cheers,
Jan

Verstuurd vanaf mijn iPhone

> Op 8 okt 2026 om 10:16 heeft kavya chandren <kavyachandren(at)gmail(dot)com> het volgende geschreven:
>
> 
> 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,
> Backup, restore of such a large database
> Recovery of a broken database (A lost replica)
> Fixing a standby that lags a lot
> Triggering a PITR with any backup tools
> Maintenance at times
> 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