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.94.2) (envelope-from ) id 1v8Ktl-00GX9r-SJ for pgsql-general@arkaria.postgresql.org; Mon, 13 Oct 2025 15:55:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v8Ktj-006mCf-Jy for pgsql-general@arkaria.postgresql.org; Mon, 13 Oct 2025 15:55:44 +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.94.2) (envelope-from ) id 1v8Ktj-006mCW-7A for pgsql-general@lists.postgresql.org; Mon, 13 Oct 2025 15:55:44 +0000 Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v8Kth-001xPB-36 for pgsql-general@postgresql.org; Mon, 13 Oct 2025 15:55:43 +0000 Received: by mail-lf1-x12e.google.com with SMTP id 2adb3069b0e04-58afb2f42e3so5240848e87.2 for ; Mon, 13 Oct 2025 08:55:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760370940; x=1760975740; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=gLSwPi+wwYP4kUUogqpz9co4r770D+7Ofh3MJNeSRCc=; b=T/FcBn4oZ4Pgxli9W+1Ly/snKNtc3nkPQUuBSkCssS+YvDaR2CIm65HF6AVbAdEljw seJXM+29d0yOjdxjDyOY74X27YVY1oH9eC9OSqvUTNE7KiB/7IeiGuUzI8zeO+QFaGQp 1jQ9ErVLPGgOTM1qGYbvEA1FD7fL86JNwQ19BJV0lRpAd/fuPOvmLgNq2R3pxHqSCv9R Jcljh4Xi0euVtsOdz1mhlDNzDfZQJtmN3VcVJOjvje7rIys1lAJyoBhVI6mx1nRV1W7B JHyzLKVT/IxItPmbXQ2yXzsb7LbNsAYEtSnyW8C/FKMn3uGpclxAZDpy5WUDrBgKP+yT TBmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760370940; x=1760975740; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=gLSwPi+wwYP4kUUogqpz9co4r770D+7Ofh3MJNeSRCc=; b=E+zJKmWOM1gIC29pF0q1RdeqQ32LUXSSYG16a0+7OESZE+QsSroRasQTkBJRXBW08n Mpif9eP2x37f8CwPh5zJI5wuEESMVNjVEpR/9E/f8Jk1wvbOC+t/K+jBjOItnoC7eIHO 7Gks+V8JCUXhel5E9BFBHXO24Z5iiJrPonkR8++yu22/P/90t1k+gPOJ2sdA0OT7h44u K1u3M8VqP66T2YkqhJouOzA94uSdLaELQ0SOaOapAduJrtAyOT3E3KUaTLyvEMrDOZN/ xKrTS8oKBdc4+IzhUHpS2wl4NpDC4FaGFvxzamutOvpP7fTZVgFjSBHRF2L7hPebniqa MhSg== X-Gm-Message-State: AOJu0Yx9yYMN51UiGRbUtNCDLpPZX51Nzs/9AKMUk1ORdkwvJ4IDwNhW gKzseP8KXkPr2LUMNE9fEV+aY/Cu2Qe+lDER9b17ueOeXB66S1FV2pPwy6DqkUx5O46aTslIXs9 y+Rhocv5c7hERkmJnE8JvxXQOFbmDk1y7Znte X-Gm-Gg: ASbGncv1nM+PL/lFIpMpHonHmAWjuszBsztTaYUW9jZxOOtVkdrXqjIWLoRwzarW99s U9wOsQ38GjvCe0JHy2pUSgj8GCRgKHkAyi1HEQxTT3cLRsMJK24g2iKyongISuDAAPBr/dQGsiQ +NUBkL7ggcw2IiPoMh9d+HVqT5Dm+kpHFaogfNRpX7Q/HYVn1oYwVbtXx9upoC9mB4q4wWbc4ZY R3yDZqaPF2vGAi1kh88TnKp0Y/JpqNbIjBGf9qC8OLNcuZ9knxe4nxbsOPyQFId59OOJvkkpnCP pSFT8YUDK+gZ X-Google-Smtp-Source: AGHT+IFA24qLL4wU4c//GHj6NsxMkk/h6xhvFIhLbMnhkjdOb+M0KFPmTRUhehofkfE85dY5VMhULu/xP02a5mxq9Xo= X-Received: by 2002:a2e:bc0a:0:b0:373:a93d:5b42 with SMTP id 38308e7fff4ca-37609e64bbbmr48652761fa.27.1760370939555; Mon, 13 Oct 2025 08:55:39 -0700 (PDT) MIME-Version: 1.0 From: Ashish Mukherjee Date: Mon, 13 Oct 2025 21:25:27 +0530 X-Gm-Features: AS18NWD862MkkoVLlJiAI3RAEmE8lZX1ZysX1JbGDPhM8qS8O6RReqk8Ub-A7kI Message-ID: Subject: Enquiry about TDE with PgSQL To: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary="00000000000086747706410c4c02" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000086747706410c4c02 Content-Type: text/plain; charset="UTF-8" Hello, Thank you to the group members for the responses to my previous questions about TDE problems with PgSQL 17. I would like to enquire that based on the anecdotal experience of group members, which TDE solution works best for PgSQL 17 databases. The scenario I have is of a large number of tables (15-20K) and some tables with 100M tuples each. The total database size is 4TB. I understand there may be variations and specific testing is required, however high-level pointers and feedback would be valuable. Regards, Ashish --00000000000086747706410c4c02 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

Thank you to the group members f= or the responses to my previous questions about TDE problems with PgSQL 17.=

I would like to enquire that based on the anecdot= al experience of group members, which TDE solution works best for PgSQL 17 = databases. The=C2=A0scenario I=C2=A0have is of a large number of tables (15= -20K) and some tables with 100M tuples each. The total database size is 4TB= .

I understand there may be variations and specifi= c testing is required, however high-level pointers and feedback would be va= luable.

Regards,
Ashish
--00000000000086747706410c4c02--