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 1wQJAz-001QaZ-1j for pgsql-hackers@arkaria.postgresql.org; Fri, 22 May 2026 06:16:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQJAx-00CVwI-1v for pgsql-hackers@arkaria.postgresql.org; Fri, 22 May 2026 06:16:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wQJAx-00CVwA-0z for pgsql-hackers@lists.postgresql.org; Fri, 22 May 2026 06:16:04 +0000 Received: from mail-qv1-xf2d.google.com ([2607:f8b0:4864:20::f2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQJAw-00000000EMf-1o8O for pgsql-hackers@lists.postgresql.org; Fri, 22 May 2026 06:16:03 +0000 Received: by mail-qv1-xf2d.google.com with SMTP id 6a1803df08f44-8cac189e516so35424556d6.2 for ; Thu, 21 May 2026 23:16:02 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779430562; cv=none; d=google.com; s=arc-20240605; b=IAEdoujstun9ihFz2Na8DJHpAO6xpEcPZTuUJik25aPcSSGXWRePZut9xfk1a3O4xK YZgeB2dz1sHsxcuLP801mV/OslT8UjZecqSSzdp9PJm04GKfw5cjUz93NZRkhRYyzDN8 Hb6//aeVF3lf1X0kN8DJtLsAcsAs9FCf4XQSnuv9MbTKxp0eop62VyD3J6UuiosslT+E qf+LJK/YM8IwyZT+XkR5J4yZREl37Z0UdgrTVvpRPmVe6sewNg91GbFQTB0U7Aro3dlX pYbnF9R1vvEgpx9BQmTWsFailT0u6sUbvC5gVdsTMrKuIUasSlXw3aQDS57Ic6yjPgKJ PtIg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=08H+BuZmyCyGvkiZ+CZ+5YRivS/2UL/Fe37wfF8cNUA=; fh=1USthIYg8jVBp7SgRJ17ZDcMorD/hoj1Xh1Q08V0dpg=; b=DzslRy+jOKD49BinRZhjDpiUjL/HwCHDLKb4DyJWlUTbQcbuXuTFXcD4hdoa/gXMdw 0tMKjnJ4mHmei6/v9hHqb5OgenYq7Ln7pxQgvrKGi24bfo2hlUOsSVdb3tYS6SJaquDI MiJDzgkUOAfwUgD/DodWaYYDKtIKFvN644kbRVxZasVnqUycHFvqr6qFQWbTeJ2w4gSH 8LIJHFSPbOBI1Z7/4M85Y+Pv/+DtdmiT+3NStXgsGf3m22BK5Pe5jp0zWezAgiZ27/SB kj9VzKYYEGyjlyuUb4jhjgkQANAvG9atc2sqKMyXD3JoWupHnDnR2Dvi8oG2ZK/j+jei dvtQ==; 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=1779430562; x=1780035362; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=08H+BuZmyCyGvkiZ+CZ+5YRivS/2UL/Fe37wfF8cNUA=; b=FM2MgxvDUnqGHe9DxL+DYThpxHSleaiHM0vxeLyXiH8FPD11ywjQSg9yCm35dGqitS avIinWnBOkWwI2BCdlzNCQqv5iq2CdfP8n+/+YPzyG+bw1yzL54WDqqOpgYTMwDPfDIk 8h4BdD4FkDwOIchlw19NX9VpXcbjzCkcDdePt0VDz3FD0GzwT3ViOIODk78KLFyveJce rc+P92hLVZs3noBZ1pVofehK/k1vAAtQUr86vT5NfIsR2UIH5aWEfufEaZjOI9lOxPkI ZjTqiHa6hYhOfw24qFaeBmQfzN78HHmZxlRVuUqVsy8i+zfxSSUhnhT8PaN7iSA+qyH6 ekrw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779430562; x=1780035362; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=08H+BuZmyCyGvkiZ+CZ+5YRivS/2UL/Fe37wfF8cNUA=; b=hFCYNev8LsGau6NuvMsbMwYVJlgbAWWGctBH/DX9CA5+2y35PAYRRhJT8cP3d84LZw 152IsN6pduiKr/qseXm81/nAwN0p8KGWJ3OOvRQZ0s3tfuXbl8kH88+uAAthwuNS4RHu uIYze9AWUvJk8Fo/5m1EpuEvfC0ifcPXr8pd8e8MtsZ85l4mOyXP4SIxwFNnGTGOFu2S ryvZU5yCzyanl9JMtE0zeDw/gkKz3K7Ye9m2EHPgDDqljDvxKznwx+9ZVCj8Www36YBu J+EZzdiw+NhnEc3Bo62LVwD0+aX0doAyopy1Zpec8ldV8OsdKyE3B/EouYiBXBlSwH9U lNxg== X-Forwarded-Encrypted: i=1; AFNElJ8leKJmiQHD3TM0zxf0QbShFdOs4pS+HQL5uRS5DtxW3v5JmXuvUK2TVCCKBgT7EHv5s93bkTygDQovBWzl@lists.postgresql.org X-Gm-Message-State: AOJu0YzhjlXx+tywPhK44oHD7zGm9O4rUHb9EKfz3JRh5q7jLrXEzbRe 9WKssgL4UYH7eRx7OnVtiYYzispCd0gzeLTU7mTEH9aYLCpD3IAHFgj+DWQQVZ5jl9CnoK2pe5e IMjp4fMPhbTFcIzI0GnKpjeUiIqqvDck= X-Gm-Gg: Acq92OFh91GhmfCOsLAeHwGusG/Psst++y3i3DPHD6MeoLpp9oUxQlaocY+jrlzCYRo v0tzlEVzhk7vwCNU9CV5J2iuanlNCOGE1liYe8NurhSSw5sY+rW7PUewxN6zlkbqZ0LpbSnS8z6 TIs9AlQGbIAKHWindVQPY6tx7WThdNzRfEE30M7bMQrUrtTTOxsErCrlBJCn0n6YL2XEUC00i74 XT3wv5eefz5GlAQN+X/QdN2yhPVrj8z4ZU3uYdNl5A3M1EETzpyqAsV+TnXuFtbP+2QKQw8bzvk kij0ZxQ= X-Received: by 2002:a05:6214:410b:b0:8ae:6460:c550 with SMTP id 6a1803df08f44-8cc7b5cf73dmr41996936d6.36.1779430561554; Thu, 21 May 2026 23:16:01 -0700 (PDT) MIME-Version: 1.0 References: <2df8509c-e28a-467a-8f03-f3cfe812ed62@yeah.net> In-Reply-To: From: solai v Date: Fri, 22 May 2026 11:45:25 +0530 X-Gm-Features: AVHnY4LywTemFJE7DFy_NgnkZ1GMBIe5ZeCM5ItNM6eBTnFuvo75KBgXnfqJ570 Message-ID: Subject: Re: Available disk space per tablespace To: Christoph Berg Cc: Thomas Munro , Quan Zongliang , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi , I tested the v5 of the pg_tablespace_avail() patch on Linux. The patch applied and built cleanly for me .After applying the patch and re-running initdb,pg_tablespace_avail() worked correctly and \db+ showed the new Free column as expected. The reported values matched the output from df -h on my system.I also tested custom tablespace and non-superuser access,and both behaved correctly. Additionally,I ran : make check TESTS= tablespace and all tests passed. Overall , the feature looks useful and worked well in my testing. Regards Solai