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.96) (envelope-from ) id 1wJTFC-000SXl-0t for pgsql-general@arkaria.postgresql.org; Sun, 03 May 2026 09:36:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wJTF8-002kT6-2X for pgsql-general@arkaria.postgresql.org; Sun, 03 May 2026 09:36:06 +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.96) (envelope-from ) id 1wJTF8-002kSx-1T for pgsql-general@lists.postgresql.org; Sun, 03 May 2026 09:36:06 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wJTF6-00000000FrP-0uXX for pgsql-general@lists.postgresql.org; Sun, 03 May 2026 09:36:06 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-5a525aedb24so3721619e87.2 for ; Sun, 03 May 2026 02:36:03 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777800961; cv=none; d=google.com; s=arc-20240605; b=L5fcH6CcH8e03cOYrBjYUzM8n5AOsSQ25pOqzeDx6I5zSeigmFT9U3HqEC9b8+ibeG jzGI2qMEc825Wfpj7v4IesZCjnzYIgUqrL5f2P57/q9ZjsJpNuay3n9FT57mLUBTRLHn 2oTuLMaJ4Jxu9+vaL5ASnoreK5wM6BR8noKTsLKIzciba68h3N/7k8UnG1EOHX9+cTtv yPhfR29pQ8Q61Ucy1Cj6uUOBU3YsL9YLOyqTc0O5NmX9ryv02DYowgR2ydLHNHXmvg3N PMSQQ4JPHHGonVkWfaql7PealfPNqLxnb1crYjBMLtInstGxQkEA+kTsOKxGIGpLpj+R DC1Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=fQKxExBn3bDlhRMPBcSVzGvkR8IRt9ZdCz/6kSK9AS8=; fh=4rCG0PM8n0FOokGy8sSWDJpgPdCgp6yIXcpABJ7tUh0=; b=CzF2Vuenhc3ranCaGz6GCMt55iRoWE87bP6nvdzWhXuKsNcYTpVPlEipd55TiRCmyA TOl7XOK4u/Ksr0kVWZdOhc9xPW0EwnBfINNh7NsJE/9DynFELkXh5Cdp3pjMn1Ax/McQ DCM+zoEA+mhrr4V/npvdehBOWrI8nAUokDpAV2355cqvnG1ainmB4Qt7CeAf51crx/vs Aenxs2G9S6jrZh65SVymwFaMgLfYVbsKHnd1AUJ8LNZuQYMsWnoqXYqRhdTwdGEY8zz3 Xez+d9t92uvR/vlklY741HA/jne4BlPogLZaJ2zW5JsKA3V78AjQTKbCnhf9bQ6+NOVs OCWg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777800961; x=1778405761; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=fQKxExBn3bDlhRMPBcSVzGvkR8IRt9ZdCz/6kSK9AS8=; b=U1gwZ7v/PgLfH+jh4fNs+I1Ou9lUU7WUfmMvAgd+HfQ+4/ykWhCq9HSBIn9BeunOQU kdLwaY4Xu+wtC9PEzvFKTUXSGuQLydkL2ZWQnNYH5n9wpA8pAe9sORBDvDSssJMcrqJw unA9zM4BwJrKhQhyuedwFcbdVwV2Tg9imq3/4xWz38S4nLoabF1/zLkr6qENxJ/sbDoY Z58tc9jSCpwEsVg4+dboDxHkUOKpDOQzNK227uo2q1rTv2eOGmrsbFS7n+HhxLqXZqS5 Q7eXT7FZmNyG+J99QDVe9OZSzhLOZ70EPzMCS6JsQuMWAwMG8m9Zd40ahNTrUgqMQ8RV xuIw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777800961; x=1778405761; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=fQKxExBn3bDlhRMPBcSVzGvkR8IRt9ZdCz/6kSK9AS8=; b=r2PyXhHrGjV8XaG0Pen7NEYU2Hje/YfclAzPypkukyCeGfVocP/4nVFWu20PBGlCvC N6k/5HtvAeu5+Vdu4n+j+CP3g865vQjXlhydMBDpubw+zxNrwZbHJFlXQoCoErG4R08r DEt2iBhsGr1JTBJt6H2jv4hs3/IKU9movtuaoOQrLS9sjsuUA/kTPtXwvRnzGw3TAk1w +dcLI58BaM+MtHUUF/2kRL3Fn5jb44QfoDuJV6HMfBq1cDHPpUTXtsIoJu8kUhtrD3WZ 1tSNDRWTylFvUvRPOZM2CxNV/OZpaH04kYX9D5pfPFnJODN289N4PP58HAkuDgoMArpj KdEA== X-Gm-Message-State: AOJu0YzPO2xsfiVZDE/m98Aa7J0c04eVUyBmWI00sKFXoxB3Y3qiE2Mi HILG74OejJakcjEH2WMZVPuIC//6k4fLFSEh50/w7imwvXo1X53F61XUZB4mrszGS2fikgC8eed KrF4/5+Rx8gNUqwe9DVPG34MaCuSUbNFlEx8NKHpc3SZ5 X-Gm-Gg: AeBDietv0mIQF+guJUhhdySWpXVO0P6WSSkdtTkFZ879y4ArUs1D+rOl8Wb+QPhtmaw fvePOPrbhTyFM6VwRgmWJjfVvXViPOgq3R688yBrJxRJu2wj5m6v3GbDqEywWXlZYF2umX91y0w Txp5+OHZ3ZX/4FQ+X6a+JmJGKHGyKGAK/sIng4OxwgnyguiqrfJLX/Ic3E3mevPYgGFYq6d3qAk TPtzbXi2AY+/cUySrCoobopjT/60imyNFA1mYRpiir1Md9XWLBr47pslmiAdyEQlGlP6H1fN+s5 A8e/aGBNI9ntw7kjelSZVGkvNT9ptwJ5AqD4JFeTvghkdGIAB6HR44Ra6f8PkDaFRT7nEAhDdQX Uq2gQpg== X-Received: by 2002:a05:6512:a88:b0:5a2:7b74:3c60 with SMTP id 2adb3069b0e04-5a8631bf27cmr1718345e87.33.1777800961021; Sun, 03 May 2026 02:36:01 -0700 (PDT) MIME-Version: 1.0 From: masheed ullah Date: Sun, 3 May 2026 12:35:51 +0300 X-Gm-Features: AVHnY4ImpGevlMybzbkWWr0x9wBNKJP5NneOUW6is2MelTVqeayrFfTvC3icDi8 Message-ID: Subject: Tablespace size in TB To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000c35a9d0650e68acd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c35a9d0650e68acd Content-Type: text/plain; charset="UTF-8" Hi, Postgres = Version 13 OS=Linux Redhat version 8 Our team is using a single tablespace for the whole database. Its size is more than 13TB. I am from an Oracle background and want to suggest that they split the data in multiple tablespaces. It will not only improve the performance & reduce the backup time. But I did not find any Postgres best practice or blog, to show as a reference. -- Best Regards, *Masheed Ullah* --000000000000c35a9d0650e68acd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Postgres =3D Version 13

OS=3DLinux Redhat version 8

Our team is using a single tablespace for the whole database. Its si= ze is more than 13TB. I am from an Oracle background and want to suggest th= at they split the data in multiple tablespaces. It will not only improve th= e performance & reduce the backup time.

But I did not find any Postgres best practice or blog, to show as a refe= rence.


--
Best= Regards,
Masheed Ullah


--000000000000c35a9d0650e68acd--