Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEjxJ-00000001FtC-3idZ for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 08:58:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xEjxI-0000000Aqiu-0J08 for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 08:58:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEjxH-0000000Aqim-36L4 for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 08:58:23 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xEjxD-000000011wF-29t7 for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 08:58:23 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-c263415982eso377413366b.0 for ; Thu, 08 Oct 2026 01:58:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1791449898; x=1792054698; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:content-type:from:to:cc:subject:date :message-id:reply-to:content-type; bh=5Yb01X7NPZjDFwGQ7q2a9RMa2p8U2o0ksMKs6LP4zBU=; b=j0s0cqT3sRd+aK3DGjgYc8IUfrs3U+WWztK5BL4+xgscoe+535HZgolq+b755wWbfV wccRwwzYwa60TGkDdOKZZSFAtTAV50huxX305YdOEN9s2/ynC4tYPP5DY+aqBWApMUK+ LAcOayVg1T2rCHoIgPULsV7kxdcIyjQjPkyPfbwdlpBrf5zG1kKEOjlfR8C1IULeJFVm tjzARNRIvCBSrhcEz2UJ64KTaRxDGA+0/zpZJqMJvUvsYgvYkS2hu4bhZ8WYvmJk1wmj tSmJLg4e+u/VCE6yHsgXtkJj0HHdZ2mgzum012nHA7S2eQ+1DFZdQHDspSP0abe10ogm O25g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791449898; x=1792054698; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:content-type:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=5Yb01X7NPZjDFwGQ7q2a9RMa2p8U2o0ksMKs6LP4zBU=; b=iTAftynKQFzV2ZrYVdy5rkUqaFe0DAhjglEZTAs/NuEl7f+1Z0cUS1v1tFiRxY1wnP z5C1Ug3YdZy4MY+sCVz7qf6sFZ0jnhZfkfSVzfCUdSuDXVmCoycV6H/e948aLtyXIqAn +e8V84hVLsZUVhpxFnytJW7rzDR/5B1ncGGLHO5E1lfff66WInSn7TNj5LRuQ6h9Zdgl ehQtmGONWPrj5nPcRX/pWef4+PL1MeM1aR5xYkpKc4L49WVlxQsj1W2e2D6c5WTzSVwY nPSvzdcwlR74bckGaeGumcYz+t1tMltmalIBjZZl7jO4S+eqpiOrmI3awmqmOm11AE4l t+lg== X-Gm-Message-State: AFuF++lvECFAERWh9aGwyd4r0zBURTqBuS91U2jh1Z1zfri5z2TkXmp6 wxuaEyxT0OJGtEbx3lC7Qmp3CMjN7sDAvwOufrwmaIV7V41VtGnJ+MBq932c7A== X-Gm-Gg: AYBFou0/8KA300JTzq9HdrS0T70cA1TdbrJPQ7zpgvT37VFRjS2yC7utqrWt8tCRJIn zIOLrFHTctIAFOO/0aas6OAW6K9dXBl2nIct5u3Ecf2y29PbaGZ1kYnB321JTFp4GmOWEYkSh0Q eLDP7NX+wRxDs40EySCRBrO/A9pHLJWmhiNdKj5OyufaDPHD3MRMbwibMP5GZSUsBOjZB1CmWGc XZqXAGOAW+Rg0fDH49wmhUjvM+2LACoQmVcwx1BB9m7vGOPvbuM8s/YzNEoairDWlm9QRAcwAOQ ESzqe3gp+34iX+meGEb9Mb/iN9fZhrTxgCABrRQBw7Rgj3ZGgwgZlHKmcwyO6L/Y3Z6HzQd3G1m fuHi+b6x2ocFn89fAz463EiXGYARIbAghtjGSjW1XOOlqRdPsRKm4yRTKcScL13mzpN4w+FVVS2 Jran7jnGrYJf4Wi5oWkRJIcSvGuT3PCo6q8P4OZqGZJsxBQlM6RSoCdhA7D4P1DvYb1A4yHWE41 U0uoObYJl7f2hrS7ko9rMI= X-Received: by 2002:a17:907:3d4d:b0:c31:6a37:f284 with SMTP id a640c23a62f3a-c317bb35d6cmr441029666b.1.1791449898187; Thu, 08 Oct 2026 01:58:18 -0700 (PDT) Received: from smtpclient.apple ([192.87.39.141]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-c317c33e313sm193065866b.70.2026.10.08.01.58.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 08 Oct 2026 01:58:17 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-AAEE2797-14C5-4E89-9988-CC4CE6E6764F Content-Transfer-Encoding: 7bit From: Jan Karremans Mime-Version: 1.0 (1.0) Subject: Re: Challenges with huge postgresql deployments in 300+ TBs Date: Thu, 8 Oct 2026 10:58:07 +0200 Message-Id: References: Cc: pgsql-general@lists.postgresql.org In-Reply-To: To: kavya chandren X-Mailer: iPhone Mail (23G90) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-AAEE2797-14C5-4E89-9988-CC4CE6E6764F Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Kavya, I also do not expect any major issues and as you have experience running thi= s in Oracle, you are probably well versed enough. Cheers, Jan Verstuurd vanaf mijn iPhone > Op 8 okt 2026 om 10:16 heeft kavya chandren het v= olgende geschreven: >=20 > =EF=BB=BF > Hi, >=20 > We have an oracle deployment running in 300+ TB. Apart from migration chal= lenges, do we foresee any operational challenges? I have not heard of someth= ing huge prior. This would be highly helpful in planning further. >=20 > 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 p= ostgres migration) > I dont see any limits in database/ objects as specified in https://www.pos= tgresql.org/docs/current/limits.html >=20 > Thanks and Regards, > Kavya =20 --Apple-Mail-AAEE2797-14C5-4E89-9988-CC4CE6E6764F Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Kavya,

I also do not expect any major issues an= d as you have experience running this in Oracle, you are probably well verse= d enough.

Cheers,
Jan

Verstuurd vanaf mijn iPho= ne

Op 8 okt 2026 om 10:1= 6 heeft kavya chandren <kavyachandren@gmail.com> het volgende geschrev= en:

=EF= =BB=BF
Hi,

We have an oracle deployment r= unning in 300+ TB. Apart from migration challenges, do we foresee any operat= ional challenges? I have not heard of something huge prior. This would be hi= ghly helpful in planning further.

Few challenges wh= ich caught my attention include,
  1. Backup, restore of s= uch a large database
  2. Recovery of a broken database (A lost replica)<= /li>
  3. Fixing a standby that lags a lot
  4. Triggering a PITR with any b= ackup tools
  5. Maintenance at times
  6. Finding equivalents of orac= le items (which is common during any oracle to postgres migration)
=
I dont see any limits in database/ objects as specified in&n= bsp;https://= www.postgresql.org/docs/current/limits.html

Tha= nks and Regards,
Kavya  
= --Apple-Mail-AAEE2797-14C5-4E89-9988-CC4CE6E6764F--