Request a Demo
Home   >   mailing lists

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

From kavya chandren
Subject Challenges with huge postgresql deployments in 300+ TBs
Date
Msg-id CAPXWBGai9XJdoikZXt_7-XmUHF5iSTkKpM3cQnk2xVQVcou8dQ@mail.gmail.com
Whole thread
Responses Re: Challenges with huge postgresql deployments in 300+ TBs
Re: Challenges with huge postgresql deployments in 300+ TBs
Re: Challenges with huge postgresql deployments in 300+ TBs
Re: Challenges with huge postgresql deployments in 300+ TBs
Re: Challenges with huge postgresql deployments in 300+ TBs
Re: Challenges with huge postgresql deployments in 300+ TBs
Re: Challenges with huge postgresql deployments in 300+ TBs
List pgsql-general
Tree view
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: Daniel Gustafsson
Date:
Subject: Re: Regarding the General Availability of Postgres19 and its features
Next
From: Jan Karremans
Date:
Subject: Re: Challenges with huge postgresql deployments in 300+ TBs