| From: | kavya chandren <kavyachandren(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Challenges with huge postgresql deployments in 300+ TBs |
| Date: | 2026-10-08 07:05:38 |
| Message-ID: | CAPXWBGai9XJdoikZXt_7-XmUHF5iSTkKpM3cQnk2xVQVcou8dQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Karremans | 2026-10-08 08:58:07 | Re: Challenges with huge postgresql deployments in 300+ TBs |
| Previous Message | Daniel Gustafsson | 2026-10-07 13:22:23 | Re: Regarding the General Availability of Postgres19 and its features |