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 1xEtzw-00000001KeQ-28I7 for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 19:41:48 +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 1xEtzu-0000000DpwL-4Ai8 for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 19:41:47 +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 1xEtzt-0000000DpwD-3yTN for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 19:41:46 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEtzq-000000016ub-20TL for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 19:41:45 +0000 Received: from phl-compute-07.internal (phl-compute-07.internal [10.202.2.47]) by mailfout.stl.internal (Postfix) with ESMTP id 14FB41D000E4 for ; Thu, 8 Oct 2026 15:41:39 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-07.internal (MEProxy); Thu, 08 Oct 2026 15:41:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1791488498; x=1791574898; bh=FnPq7/VYe+4UgkrVmQfW6ZT28mT2y7REUsRD6pOyL9s=; b= uSFAeg8kBxcFbyMBLL/wQ120SRcZztNtsfVksJfr3LnydCGXUkzM1Fob19fMwbBE No5RgpJxYGk9Ri7nWF+26b6aG3JCpdR0+OjE/sMROsemz5EDxK8yDc1FaqBIm1d8 wdVLAfkaHmyVb+iNGua0OWxoQ9dqxhjgfCwlugsY7Lcz1/oNtQ2XLZLD+VrZuhqJ 3S6U2FexQdA3x5zjEt/U5lRTGgdFD5dtl/wCg68RB1yR/dquylU4Ih52cymSS3G8 /QTErFMG3k8c1vexwm+XqXxrjVk0CTdj6QHlb6cqcU7OcwUaguomOILLEEL0XCbY 3dBDhevO7qQzobPxqEpgMw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1791488498; x= 1791574898; bh=FnPq7/VYe+4UgkrVmQfW6ZT28mT2y7REUsRD6pOyL9s=; b=Q nmnNkQzSUROuh9tkBUjY1Y3RjOW5Bkl4FEPwVmPbsKGpUhxQoJAnrK6lpcLpB0MG yqC+M+K0pxma8Cp+qMDyBtnnTB/06v8aBu1+m/OYpxJUVv0O6i8N30tI4ALptuYV /5TxclBBXhHeQLbI83JuIrsDKHyJx6YEsjCpfWKnv3m65XojShYcLZEMidn4KFvd ueNJQCTnDDAgqKuradhMUpoGivcQbHkGP5bt3RmHJNXJXBJQWSKGdcaldO3P0roU tOu4B1jTIh2Yv2E0vfVD2scVT6DH0U8HO/uCE+oX9QDKsU/MJAahKPNCkQ0yI1Ck 3AWhx03BPRKact3h2SHeg== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1791488498; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:qrCBCvNpmBWOhaj6xmi7PHKlyaO4OQFca8yHpWcfOFgAJqQ PBtwLyCrEZXDa09VtQaxl9yfxKtllLHF0tNHuJWYKseD27NkwYFw+QAarb30+naK vSeo34Q+P+7qwNLT1O0E4EevJ5EABDh1EC1oGEDfMPjbhpZtgCofK+VkmJwzMpFl JyYijj3hLKAW38RnNbmvgVjrImD4YtqU9xVRw/eXDO0CeAwXq85i6YA6mRSc6sGz qYYPw0WLCqirgAq9pcxPQ3afMOHurKRYLWwEgQFAw5PUrcmuZEu+8RE3e8dHfrHG cURnhH4j/Y9EIQc48Ia43vwsQNgTfYWGhVfHTqw==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; sw=lmtpprox; action=mi-m=1; hc=14; hn=cc,content-language,content-transfer-encoding,content-type, date,feedback-id,from,in-reply-to,message-id,mime-version, references,subject,to,user-agent; Message-Instance: m=1; h=sha256:hv82xHY30DiV6TllAznfYFghrsxg6MQFiDdliz1Bvjw=:Elyx3o82oicNKmHJeWHv/lSVpSy5HjPK5eOzxZl3NGA=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFGqV4v5NJlGEAlmz2sY6WK/FZ8jou9SAobSv97dE2DqdULA42U+sUgMrDVMJWb3C oEO+aia30lJFKrKCic7+3cbbprFajzxJOZKnLaZ1RlTSR8VGLVD5kZ7HXzQ36PBly6/4mG oXjH++qFILSPhVAqb/tJ+x/4YdC41917QBYDcSJF03Y7HvMVSSXsml3sX7hnuuU3IU+AXi N6iij05m8zhs50azhY1mNnb0IPzda8A6eJ7H9BZkS2pSqoW7Xq3OHASc7NHLKuhuqI0QvC mKtC4K2M0bhqD6WhbZHBmXL08y2y62yjUIlXjXlUFMV4Hrl9Vr73XX90WtgBPYIi34zuLj AMs/vDdW+yNkfew3QaSdsAjyCrtkM9sgKqGIFnWGnu1OQAXSI1zykZhm4EhCjfOKqPVskV JSubJwzGieFzbekhr4pZSlhYN87y3/9smyq4WKYWsvJdRwA4JWhbmWwXI/9UGkXHZdj9mm riUYjE6YBVLe73aifZpWgZz8aehIa85oiv8KNvu58F7C99eA732UWNj1rxwzO4fAJ+7qg1 S6LXXnYfqIXo78hjVUu6PpraUzO8QgbYE5xeDpHZUxBo/L3d8neLf4xvDtcJ+O5j/oSWmx EVzd0jKsgkpi4zNqUxsJ4NEWDcECxWyJVxa9oChWmB/RAcer9xYr+IncxHEQ X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 8 Oct 2026 15:41:38 -0400 (EDT) Message-ID: Date: Thu, 8 Oct 2026 12:41:37 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Challenges with huge postgresql deployments in 300+ TBs To: kavya chandren Cc: pgsql-general@lists.postgresql.org References: <96a0c9d6-d9ef-491e-8783-36b2f4840fe3@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 > 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 www.postgresql.org/docs/current/limits.html> www.postgresql.org/ > > docs/current/limits.html> > > > > Thanks and Regards, > > Kavya > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com