Request a Demo
Home   >   mailing lists

Re: Challenges with huge postgresql deployments in 300+ TBs - Mailing list pgsql-general

From Jan Karremans
Subject Re: Challenges with huge postgresql deployments in 300+ TBs
Date
Msg-id EDB1EB63-9C14-4F76-9096-B418BFB89CF0@gmail.com
Whole thread
In response to Challenges with huge postgresql deployments in 300+ TBs  (kavya chandren <kavyachandren@gmail.com>)
List pgsql-general
Tree view
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@gmail.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,
  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  

pgsql-general by date:

Previous
From: kavya chandren
Date:
Subject: Challenges with huge postgresql deployments in 300+ TBs
Next
From: Manu
Date:
Subject: Re: Challenges with huge postgresql deployments in 300+ TBs