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 1xErzV-00000001Jfp-2Bse for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 17:33:13 +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 1xErzT-0000000D9gD-2e4E for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 17:33:11 +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 1xErzT-0000000D9g4-0wQ7 for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 17:33:11 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xErzQ-000000015qZ-2PSu for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 17:33:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1791480787; x=1792085587; i=karsten.hilbert@gmx.net; bh=AoikkJLzwDio2MoCJjzrp/L8PxDLocOm9MhsrbSHEwY=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=b525qbmay2DOllW1WSpjzsYR8imuZYcM5s1X2bbU6S0xH0WNEeGQQY6WjFNxu7gU VAZ4PVU/QTt7inblQ2UMUqc8rrJeqIoZEIfyqwgNkDeHJnq+4FWxmbYg3plUAf2MQ VX/+FpR6zj46lFtgOMJxPT1F7CNCo7j5opxJ00lNm8En5o4VfXnxS3jbSUnWV1qTG H4NAgpmRZ6PtSScWHhtyEVxPcfJz7nhgTw1IHEscuXHTuTf7eq3ZYkKY1Mdro9LbL YBl6L6zGRxL+hPTqMFk6yuKFQiMChcx1ExT5q25bfLhnZPHmM9Q3Y0PkU8lX8Hv7I nJ9K0aD0/LrLbqylag== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MXGvG-1xAylR0B9a-00UB1y for ; Thu, 08 Oct 2026 19:33:07 +0200 Received: from ncq by hermes with local (Exim 4.98.2) (envelope-from ) id 1xErzP-000000006hJ-0Qex for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 19:33:07 +0200 Date: Thu, 8 Oct 2026 19:33:07 +0200 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Challenges with huge postgresql deployments in 300+ TBs Message-ID: References: <010201a11bfc5153-2d71c4e9-2958-437d-8a62-6f056692bb82-000000@eu-west-1.amazonses.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <010201a11bfc5153-2d71c4e9-2958-437d-8a62-6f056692bb82-000000@eu-west-1.amazonses.com> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:3/axai+KkJRMUH7stGJ+rNvCbejhq1af769HYzKNFnkkvEvcruo lAZFlGCdnXGyisAgDZh5+0JjoW0dow68GExsEZ+RHvPf24E/305gfAXhChFICxAl4eXmhES +J1RSezvlLayXANTkHWQ9FmQQ8hjZxJ+/dLhZbGAA7zurvZA7/WmQ74QrDZeRU9+5tkPtWz wnZSzLMH1ELOHizUSOxFw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:lyLkl7xkjOw=;Y+gy3w4LUZaKxAXTShe2AafoMRc TkHeule1C2WNsIJG769E6NF9DM+AvvUoRudCUtKfPmzyiwY3SLVjzMrPXS+S6ff4p5o+kZZUN /IAyQYUvQGXgT+aJ9A0CN1RJAKpIMSpkbZXYwWwa9QMGdNK1+8nVlBZZ+YubYjHs+A8cE1W+d a8HpONX0M6gUFK1CYZqy5uutveqoVCrKx0omkie8ejD72+rgh9Wlt1kV6fPFdhX8xEKoPJe1V M0Mt3sx79gHIT+BHSBkdHx7vLlA1428/fQYMmM5M4w7ZO30PD6KId7SpFGHIJIiLnK5UqfwgJ tCWVMswTIHkItliZubvNsZgbNLdnAe0rRqNkN/o9k9xkVV5T70Sp9oBQoIvHgVTtIsl+BL/o+ oFGOMUac5h5AtH+4uB+LqVXuFZGmQ+c1MuAfMUID8GaS1rkqIbrikN5N9OVAB7kllyaokfJUZ tE5Ag6E8ds1Xu2t3saI/WTo0vbWzBbDpGMAZWPTc65fZ62FNq3FPkGl0q1NqfDAIWxGLoFKF7 jjf4etcK5AZC41QSDn1rEFSI2tXzPCydfMWxNmUKXxKW3JS9tjX2i6Mgf1Lbe9b9aA5EM8noK WPFNiqrYrkbuiaFS/uYs9KtstQFBkQQJoYZMOvjqUmDgv2PXuJzZ+WBiyzwqYd8E1iQoA88Jc mr4dEpT/RHRJiGr1Ig32ewq8WT6iJevordXGVroulLSMN8e9Fak3maoE/SpZuZk3HD+QPFoDw VfE+YvKovYpW12EhtqpmHWfAECTb7YM8GUj45/NptWO4Xom0CbU0j59E3pHiI5qWCQ8faZb7l 8UzY3iPL7XcFuVHvinDRaZPNAxN5O+vxIiJTgheHCiTZTiJBPHATTFm7kgqUcBj4H7FcEw/Xn dqEdmSdr+7/rW31WeHQAGn118euv5FAuiXDeVTh0AvojD7gyKFdVWzCNnJLn/8+AVTwxWCDhh A7UeMHG9cegSDyhneKsY7ehqLYmWquLOsvBiuB7zsqJpQlTZo9vED1cvvqXbgKlwqm//xuG8N Mc8BYayVgbq7X6aI8jzIs1mdh5lvsz3tbUyBnPh9YXn1tda64Mmpfbkt1/ZZ5x+J+SJYLmqV7 X8We0NPv7QHx7m/FaGqnquqYzsRsyMkYhLpchz312i++ogLETJzDIN4CXblGbO4FwHAjWylcW VobhmqxODYwJhKxym5AeHxoFo6OP+UiHOLQpqjfsWZ9kRdEkhVZhevl1dfdIg7eP7MNQqIQYe arPDnBoX5VgxoYtWPw0BR8gjIdYEprTXbqiJsh/CqfOzbpmG1aTWQgCY3+iSvUcUw+5IDl3CL 7dlVLe5VNrfzVO9MVKgmPlxHRJdn1BM/l5HP7WOXKiu341SNbAYZf9g96DLSbhHw2jhLaJAy1 EuKcKPqPFlC/QJ9tZhJJRl6/JjO9R0sBYgc7SrHFHkAqPuiovQzD7lpJ8fZ2rB5hSg/uiJ9P1 Cha0O2iOKa/3AZF5a7805UCyGrOLQ/roLizSBgf1DdMc/pjIPXpsCQMFahqupGM5yu6MZLYOo 1qXLGhEw04FpKrGtRXbf9bSkQVF2bsroo5QR47QdVdLRv7f3NkisLdSoe9l/tjbzoRBllN5wQ bfcoHJD8K3rbOel7eV3MfO9Cs3Ua213SliPyyVVejEA7uUWMtsWfjCDGDuBprCZSmSdXWFfsU NVlY5tTLQJHHEOK6/GWDsdvbcrsX1rG7k71hzDHLKNzfxM8kAUl7K7UA1BE+QOEFWWqPd4EkW QV5eNa4atFMRPsH42BMapscFA9cfJIofXhQEKEswDCdc8vNNJMI/7okeyVt7S5LSlLpkIlMAD iSE3jDAleQqPenKz4G9Zk3v8bcFVCMDtZCeu3TVwbtWZkAzvuHNypX1JVSC8X7ASaaEs5bysr GfakjcMEmtMJQckiYAdxG+Pdugr3w/Xt8qNwA94AyLW3gRsEb/tipfOlJofgxwegazsX3XadB 7OJfkHAf/DFBREnniHbIE5WYVS7CDxL5HcnGwaueJfaSkpHTkpi4BnK6vwQ7hb37TLW/fkNHr oWno8ZulrU0lVLllo4AGJXrTfEe/qOyEyyOkZZcml93468VqRRs8sA3aozIb89a59XyTz+q7E rHXxR9o0lcqr1iMCQQiRYOEUei+C+Bvgg67eRVdPo3IlV+T/hVoUZcVNqGLNgA7mH0QOBpT8E E2s2zzB1LjABKsgNWI9oGqWEj9VwbPkWIl2FaWjS/hmU0VDLk3wpXg35c62/e7q9VVIxsdWok VXhiWN1k/f1QsmERiHY8QKOgqJGIu/78DOXfy+hkRtQ2vKAGbaxgJIwYW0mhDvvoHQjjtz8RK OXwfjIE46kS5PLSmQI6a00LYrb/AWjThFv+aX+raLrNZE/4n+SxN7TNod6RldYgDUBxsUA+4R 0jkVR+mshCjq7fiGL7MLheUY3i48bt5OE0Ie1ZEf2DShEB5chAwSH0O5K1Jj2jumUQ2jvDYZ+ 9KkPQOSpQJYa9QsBeT+UgSJqIGNRSSeREK4KUqsIo72iR1EO2trA+rn6k76QmWiUUL0qBZEQr 03XO14peM4FiflI+kJ8esvVL4dcqiJ6XzT/hSrObRTyllSx133S5A8jL1tLPTSw+1Yr3pmzGN jfeSfwSDPrKM0pdXf8IpjxVpO4mRRHE12WfccLunOTsu/TyhI04uEf4K/KwN4m7H0FSSVcK/y +g8N09VuYzfOyR4jnBVQYhhEwfc8L5t0Y81PabqofWxrDPKh9+cBfzfQZStNuHsNpuvfgC9xe sDNk4wfsksj8hylCM6RSBNbl6NBJpWoX80J/MOaToRX2Oe6ZjyabCCXl8oyB5OJJnMIQ3no78 +zHQUBWB6GaWkwK1QULqgoXkbgzPKayM854VwqfFtHG0HVF1sr2dcnATDIKHYSls6+rDIBlMU qFCv75PpPPx29IIy1p/8f57boc5PXG4Lb5VZ9CnWgy5D4kZrcTJ8xpvK7QVQNkBJTXTK9+CxG k0dWzAHd4hQn6zC7M3RPIzzSW9bWwM8HaItiO+E6Pow8PfTu+nlT6pLnyqrWRnBbplfTIQD7z NNGAaS/B8fUTuQWoLSbH4bGhAbRKccG0GT7x8PEUdof4wmyJIkaC2X7L7k5G1ncP5+hAxn27f 5G+tj5dCHFe+Z+S3Pndq/Iz4RSMTSTrBFXDT5p55vhiCLR6gRCk4HGOKB7Oa1lwl5PbwwYLYt YMdc/1xWJjbMqR6IBpmsDBF7Mb4PLa0Kq8MVYgxEQxQnizzXfQoxHa0DY6sSyxhuNXgAZDtzE KRhQYH7119zTb2a0/h5IBOhivUrBspc4K6wMS9RytrE2O23ap+S7yuNz0+DLSWYnYo8fCrIbE xAaXAeciiKQCvA23QH4L+0mSo2q9T/jaiYsng5BndBrRr4Ov6zbV883EHSyeO4uC8Zg16KRXS odXflU87EAnrmxmFwPExPRuU4kxN0g9Kwsx0ok7P1KdsIf/2nbeX+27glUnj/ZjBolR8hPJ5y AO4hjA+Cc8TkkM4k6g0cHu4M28YJ6RyBTZp0eDmFz+Xq0EWpGpLH/nYVU0vZvmQmzupusEuDF 87FgFAGc9nuM5iQz28jUeO7V3g23j2YLT2ZLPxmcXsW/JiX5zB97nFTIumTlqTfL22AlVnZO0 5JEPHYYz/+E+28h9lQx/trr7DTxRsLmt+rh2AHcoT+I5pGVXJ+65OMO62I8K3/5zqH9dE2UB2 S7zTaSrtaCyQAcvfePqdQlSw2DB6j5rtnAZmpuRsRnuG0l5qkWVlSptAc04wjv3d0W88IfLxY NnvDYE6BTz06ayUSqeRvUwUuYIGKa6Pm+U8UiSG/C+g/l6nhOsKTJ/dO3CiQEIlwSiCwwI15/ Xh4AmHSVmaP1AvN70fn3oFNaKkb/pzMEIgGHx0vgssVfSNNgwgJqQTIiNS3WiVgAHHpM0dXNA VLDyyG2xEFcfOGQbeuVGbWVYl2EIaulbKBBnla5hIVmztNI8xyI05hBzHkW9sdQNeQA1J+Ak2 bXaRg8glysXNwBQ5zmTkfVf+4gdPiNRoj+te0V/S9qehcWCdc3kgfSkurNzyR0HyHdowLHCRp z7eRnoFXj66RkWAGW/AL6iTaCeH/8tEO1KOmOVUL9eX72cfqKqhsc3hEOEIc30Tx+OdHpsHhS mqhda8XoDux87L3JATqvbZuLPCr8tEFCcfwLEToQCJemonR/tT56VOgQ7pyI0KgjSL6HdPPID YcS5ZEY8DLZuIqY0izi2fcwTrWz/oRLVjHzgDiwm/htYSDZF8lrXijmt8QEfE/9/rki1UY0Yv 4Qb/+VnHDzdAMIKdMS9gobGk52CGGM/Ts2M6PgzRsfkRAddANi+CW+dcfuNkwwMVJbyPo8sZF s9OgUrz0/0TRkbdRNho+cgvhShfr211h3eyMWRfs6RNMoeilBJWZ7uj+FE3A9rN0phPToBSwt KQxOAJn5YMFiuXfIxh+wbHujnI/LosYEn9ADyvvGh01CEaF+hGE0TrrQ7CQyIEB731Up6kFG+ w7qQIhTae/fdrFbd9x2TZDI+40I25takjp0nmPRcb4zG8PXVezjyk88hp3iIMm97U7DAuVilZ ygkWaDzjig7ZFVfTUhW3XHwqo2cBLOVCmhB9qeYJKGsUGEWSv2MwRcFpIhogAnk7ChkwfHskF TzyudIIuZTNo63XG4ajRx87Arv8DynQ5rADNwNAi54gLKEAvE+MzEBNgZ2/8zHlV3GvCmJKaJ GxN9XWZN/uBqZtq/Y967xnzSEFXDFRcSDozwd/NXb+mzqy0G0kaC6n6NSezA+10JIsDtpSDBj H5l5Tq90J+9USzSdaL/KMdDBumP3v98YxK81E6XOsGwvp3J5+JjZU2ZhS7a4poLMxTAWYWCSN XW1WEsuk+PJQElAj+NJlFMAvIOd8hNNFhFpJPpQupid752JIeT9EiL8XBnDpSy9BgxU/CY3Zi qRKkPSdlt8iHkutbdgi8diqTT+1wj34tj99XEBXG7OyQhlNVFVcnWu7bfdLW9kAvWIPZjO8VY 8syiwq4dPsYOXDlfi7PEfkl6oAnHsdQvMd6fE8oOZPEOnFq3AbCGMrYHcaz7+HIySRoTVE92Z mdLIEhE6wj4sVK4kipNJQqrtSqUjhSucLJUpxdobM9yrUI36z19oOHmd5GPvu6KOmoKpdKEtf myuob/qrbzYE0adVIT/sjCLs36HsoDDsj0jmULkun2MbBCfU4noU5sEL9B3pL5huZpSfzCKYA Ex+bebI7OSQpNky6M+wqSe28EXT5GqC4pDwhWNaa2autFtjd7Nlc+R0OlVdIohNd1JyeE2Qhp bW+X1XlQeA/mjU29p5WI+key4ZVhc8v81ZBfHtFqw+5oPHbTad0gFJ1Bkq871th5ESSmSaz1f nIxCf7r1q0KLF/MP0f/0dgeuDQSMnKYbIFFlIkO+Ljj3dLBry/C/gKSQ8EJNVfLHbDW67csKB Lu2SzsV+A6vcWQS9dRtpfZaGFX8juqxJKa5KvQ0jOfwtCLrTdNZbuFrsNLbaJ4uYAzHemRpTI WHobuFsxUw35cSHW4LHAiPtnlaU5DI0fIF/bWDAPeDHVS1jtOaCr4IRTN+e28N97lFWxSPPuu yHiqcv2ZZ2I0AZkigqnaYMb3TngOYJD5EelXl5PTkHfO0T5kT/Kt7Tz9p7zrgdPCVYfoO/Hz9 I9+izjie72eu/lxJx+0EXVL635Bri8xxQj85TNXSZzIYmeW4Q1ofA5fD7sabsVZ1IfFvBGX1d AZGB81tKroemZX43Fbq7hjuY3BbarV1ajdBP5QGtDZNJJZDCD4rAHN1fXsE2poiOlz+hlbFlh KKRpxzGk4GHNG1h0XHCw0warkqfQpD9e+guAxvxLTkuQQuQEycp1Itp6JLDOg1OztTZC/jlmf yjJG5C3nW704RugHdc+SeYceivmim20KoSnAS6MfSaLXk84gvMgXspc1gAklJGygu1t6Fp4hU CVFmHZhGiZfRApfBPAOKuYVd6gzjVu9C0f+uqhsgpWbGn8rbuozZ14CKtq4aprl9DKjhU71G9 GESjLViX5M4VCod+FL6iOownMtZIiMbRSpLW0D4lVzUqE4Q4zY+StE9c/LqgU7uoNPPMSLbIe yXTmKoOlS3OPfhcDCFRuvnUUou4zjBKn+aq21yc2EwVs+q/1VylZGdGS0ncTvc6JvXlwIhuM8 /Mk4x/p7RBLWVdxuId+UBpwvWtaFGfVA36vN1saiRQlXuT9oBSaN6SmOdBEgX9kqr9gqkPk+N hAU5zhlJPVIHImWqIqH4rxLmt3kz1dgYK//sIwMQquZglZlECkq6r+n8Ipp6nlFlkzHLrwtlZ QTP0M8nQFjF+8HhPhbyvzS9YWrWF7LOR+R3UpFW6GgB0eHd0GzY7/t/kmp39VKpNDIAlI4MVT Iuqq05YPwNa1YoVJ6qLBqrt4F7RmMghz9EOwxeNfq3CG3hjnve7FYMpqSxjdj7GpMC6LxC8T2 CYwB9K20FLfRkvpaikCLzZmRIgjHaYL7lzmTJhmC0gSPq/g= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Thu, Oct 08, 2026 at 02:48:03PM +0000 schrieb Ray O'Donnell: > There was an interesting talk on very large databases at PGDay UK: >=20 > https://pgday.uk/events/pgdayuk2026/schedule/session/276-operational-haz= ards-of-managing-postgresql-dbs-over-100tb/ >=20 > I don't see any slides there https://www.postgresql.eu/events/pgdayparis2026/sessions/session/7226/sli= des/836/PGDayParis2026-TeresaLopes-reduced.pdf Regards, Karsten =2D-=20 GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B