Re: Challenges with huge postgresql deployments in 300+ TBs

On 10/8/26 8:56 AM, kavya chandren wrote:
> Hi Adrian,
>
> Intention is to get away from Oracle and get committed to Open source
> Postgresql.

Alright I understand.

Not sure what your timeline and resources are, but I would start with a
test setup using a subset of the existing Oracle setup and work against
that to do an initial determination of the challenges.

>
> On Thu, Oct 8, 2026 at 8:20 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 10/8/26 12:05 AM, kavya chandren wrote:
> > 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.
>
> Why the change?
>
> Is this a pricing issue or are you looking to get something else out of
> the migration?
>
> >
> > 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 <http://
> www.postgresql.org/docs/current/limits.html> <https://
> www.postgresql.org/ <https://www.postgresql.org/>
> > docs/current/limits.html>
> >
> > Thanks and Regards,
> > Kavya
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com