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 1wJVtF-000Vg0-1z for pgsql-general@arkaria.postgresql.org; Sun, 03 May 2026 12:25:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wJVtE-003CXs-1c for pgsql-general@arkaria.postgresql.org; Sun, 03 May 2026 12:25:40 +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 1wJVtE-003CXj-0T for pgsql-general@lists.postgresql.org; Sun, 03 May 2026 12:25:40 +0000 Received: from mail-ej1-x62d.google.com ([2a00:1450:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wJVtC-00000000Grt-0l1i for pgsql-general@lists.postgresql.org; Sun, 03 May 2026 12:25:39 +0000 Received: by mail-ej1-x62d.google.com with SMTP id a640c23a62f3a-b936331786dso378123666b.3 for ; Sun, 03 May 2026 05:25:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777811137; x=1778415937; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Zg+A0vC7y2UOfeJeq5igb5zBDEUvf03tb8mmub5veNg=; b=mNbAI2XdkJrqitzTaDa7ZgPQv3kRYHbKBtIWnIMVWL1P94Uo6/154IqmACgu3Ny3jZ MydzyDy3FRv7hAa8WWjWQNL1tlEMO/KIpdsofTcdsaff2p4/mAxJFnWyzP2ImtnhukuV RlP8EKKn2lQNCtIO/KUAfDVCJX35dsuvbzdrA7LWUK8nEMCY41tlEaXc2EymvyIZzyZc WxysQyf+Aq26C9xkPW/x41R1FUQ2WfhnF0aU17fbqWsz08myinn6OwULAgJWJtmYpers 2VwkkcFCIRrakbDIRMbDinNEWWx9NQoEpEnA6SUbyAlmv5lDCLjSLEJPFaL4r9dsEVUf abaw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777811137; x=1778415937; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Zg+A0vC7y2UOfeJeq5igb5zBDEUvf03tb8mmub5veNg=; b=Wu808RbKHiOFSCY60/HQxmI3wUA0UKQ8wwU0T4Y9cg8CVzdrxqJ/BuoVSIBAoSNmx+ +8zG9eIgFflcnf9M0eGBk07X0cluzF5PQQJlGzXuGlfovWE7/9p0jWMLdYuUdj10nN49 9tCO0MtladjFwBuoGW+vjKkO/7+CQLdgWARQ9jZsfGiKVktmVHD39pW1LNpQbrTwrUVo 4h8sYv9VZKPKh++b7JYyt4lfKvF14PHEEwCdkW9B/4BxqmOAFEl0GU22P/LTuiP+McBT a54eoVfM9yTDHLeMzxfHf2nPiZiLRhSrUBgojo7bhG7fut/LCV8UJV1t5hEx/jQmJ7/W PIWQ== X-Forwarded-Encrypted: i=1; AFNElJ88WP1I3yAOqSXN7jQ4uBOyriYI5fDbFt5wHMqP/msCeBzkwKo6HWv5OBGtrM5CBeBO0UvcK5+QWqSDSU9q@lists.postgresql.org X-Gm-Message-State: AOJu0YxHr4tIwD2tN5ZUMAEXUdKMVA2k3+Btu1d0Uo0Gv6+e8KWNJ9nf TgAmy6dE6LmikfPa3r5TRG/v7x1+z9C3wabgQjDL6DUHC7lb6tz072IK X-Gm-Gg: AeBDietTs5wvOkRLDdWhnvvYylTXXng6tIMhHLADsxPiFzLa5H+S9BPGDjEmdpNbAtW 55T85/wCoFGwNkNCOB+3+DPz9QkwlePMCVVt8kJR50jAN2FV46xsBZs7UygwauTURvuj71VlB31 C8674X3PRV+tir/qwkfr4eks0ORyWHk7hhXNcKR0S2HzBmBRX5wYzdzvqIqqHw4+7H+/EJUgNCH ka0uX7PI4BCI+59JvJk1/Lvela0WQMygkmb0Y9ezk8QQRqXOPYAfVIyFPY8Xy3NGWuU14tgnXKo VjP+mgA635raZW8a/pczXBRNqxDNYhkyWIGTZFKq/gPXXwcKs6Dmb8UfI5mTvdb5I+4Vggxoj9o 3dNrf3MMaa4QJDynMRzkDuppE+ktSzDGy/rWGzGPYRbYsAK2k22bW3Ue6dgdPVLQTY6mKTvJMIk qBCr/b0PuNoy7MMKnLqt+idyMpL0pMr0KJTnejMIKtTRN4mlTFv5247EzVT/EhPN8E X-Received: by 2002:a17:907:d481:b0:b97:b3bc:f6ba with SMTP id a640c23a62f3a-bbffbf85ac0mr291813866b.39.1777811136837; Sun, 03 May 2026 05:25:36 -0700 (PDT) Received: from smtpclient.apple ([2a02:a44d:c827:0:441c:9e02:9aa:40fd]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-bc1671c1d3esm69285766b.42.2026.05.03.05.25.36 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 03 May 2026 05:25:36 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.400.21\)) Subject: Re: Tablespace size in TB From: Jan Karremans In-Reply-To: Date: Sun, 3 May 2026 14:25:26 +0200 Cc: masheed ullah , Thiemo Kellner , pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <86590390-F0A6-448A-985A-AA7CCC5D9C16@gmail.com> References: To: Laurenz Albe X-Mailer: Apple Mail (2.3864.400.21) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk My thinking would be to have the different directories on different = tiers of storage. Cheers, Jan > On 3 May 2026, at 14:21, Laurenz Albe = wrote: >=20 > On Sun, 2026-05-03 at 14:10 +0200, Jan Karremans wrote: >> Contrary to Oracle, a table space in PostgreSQL is a directory. And = not a logical abstraction. >> Moving tables from one table space to another becomes so much easier = by that. >=20 > I am confused. Yes, if you have more than a single (default) = tablespace, > moving tables between tablespaces becomes possible and hence easier. > But why would you want to move tables between tablespaces in the first = place? >=20 > Yours, > Laurenz Albe