Re: Available disk space per tablespace

2025-04-24 Thread said assemlal
Hi, I also tested the patch on Linux mint 22.1 with the btrfs and ext4 partitions. I generated some data and the outcome looks good: postgres=# \db+    List of tablespaces    Name   |  Owner   | Location  | Access privile

Re: Available disk space per tablespace

2025-03-15 Thread Christoph Berg
Re: Thomas Munro > > Hmm. Is looping on EINTR worth the trouble? > > I was just wondering if it might be one of those oddballs that ignores > SA_RESTART, but I guess that doesn't seem too likely (I mean, first > you'd probably have to have a reason to sleep or some other special > reason, and who

Re: Available disk space per tablespace

2025-03-15 Thread Thomas Munro
On Sun, Mar 16, 2025 at 1:09 AM Christoph Berg wrote: > Hmm. Is looping on EINTR worth the trouble? I was just wondering if it might be one of those oddballs that ignores SA_RESTART, but I guess that doesn't seem too likely (I mean, first you'd probably have to have a reason to sleep or some othe

Re: Available disk space per tablespace

2025-03-15 Thread Thomas Munro
On Sat, Mar 15, 2025 at 4:40 AM Christoph Berg wrote: > I'm still unconvinced if we should use statfs() instead of statvfs() > on *BSD or if their manpage is just trolling us and statvfs is just > fine. > > DESCRIPTION >The statvfs() and fstatvfs() functions fill the structure pointed to b

Re: Available disk space per tablespace

2025-03-15 Thread Thomas Munro
On Sun, Mar 16, 2025 at 1:17 AM Laurenz Albe wrote: > On Sat, 2025-03-15 at 13:09 +0100, Christoph Berg wrote: > > Do we care about any of these? > > > > AIX > > We dropped support for it, but there are efforts to change that. FWIW AIX does have it, according to its manual, in case it comes back.

Re: Available disk space per tablespace

2025-03-15 Thread Laurenz Albe
On Sat, 2025-03-15 at 13:09 +0100, Christoph Berg wrote: > Do we care about any of these? > > AIX We dropped support for it, but there are efforts to change that. Yours, Laurenz Albe

Re: Available disk space per tablespace

2025-03-15 Thread Christoph Berg
Re: Thomas Munro > Hah, I see this in my local FreeBSD man page. I guess this might be a > reference to POSIX's 100% get-out clause "it is unspecified whether > all members of the statvfs structure have meaningful values on all > file systems". Yeah I could hear someone being annoyed by POSIX ech

Re: Available disk space per tablespace

2025-03-14 Thread Christoph Berg
Re: Quan Zongliang > According to the statvfs documentation for macOS > f_frsize The size in bytes of the minimum unit of allocation on this > file system. > f_bsizeThe preferred length of I/O requests for files on this file > system. Thanks for catching that. f_frsize is the correct

Re: Available disk space per tablespace

2025-03-13 Thread Quan Zongliang
On 2025/3/14 02:10, Christoph Berg wrote: Hi, I'm picking up a 5 year old patch again: https://www.postgresql.org/message-id/flat/20191108132419.GG8017%40msg.df7cb.de Users will be interested in knowing how much extra data they can load into a database, but PG currently does not expose that n