Date: Tue, 12 Nov 2019 10:04:24 +0100
From: Christoph Berg <myon@debian.org>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Michael Paquier <michael@paquier.xyz>,
	Christoph Moench-Tegeder <cmt@burggraben.net>,
	Julien Rouhaud <rjuju123@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Monitoring disk space from within the server
Message-ID: <20191112090424.GA20731@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	Daniel Gustafsson <daniel@yesql.se>,
	Michael Paquier <michael@paquier.xyz>,
	Christoph Moench-Tegeder <cmt@burggraben.net>,
	Julien Rouhaud <rjuju123@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
References: <20191108132419.GG8017@msg.df7cb.de>
 <CAOBaU_YVGEnsnP1ufp42NiJ+WvPHRWBOsBOcaxWxsbXPN_sdNQ@mail.gmail.com>
 <20191108133531.GH8017@msg.df7cb.de>
 <CAOBaU_Zu6RP6-mHyA_J9-xkxJe0tarTVqU9TFza+tCPKUxsjiA@mail.gmail.com>
 <20191108135830.GJ8017@msg.df7cb.de>
 <CAOBaU_aENmaDNO7Y=iG=L2Wsjwje4HPxt5+c623_OfCwSzDKmQ@mail.gmail.com>
 <20191109015618.GB5128@paquier.xyz>
 <20191109133349.GA2545@elch.exwg.net>
 <20191112014641.GC1549@paquier.xyz>
 <7A3B9BB6-BEA0-466E-98A9-B4DD8F04830E@yesql.se>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <7A3B9BB6-BEA0-466E-98A9-B4DD8F04830E@yesql.se>
User-Agent: Mutt/1.12.2 (2019-09-21)
Precedence: bulk

Re: Daniel Gustafsson 2019-11-12 <7A3B9BB6-BEA0-466E-98A9-B4DD8F04830E@yesql.se>
> I agree with Tomas upthread that it's unclear whether this needs to be in core.
> There are many system parameters a database admin is likely to be interested
> in, diskspace being just one of them (albeit a very important one for many
> reasons), and there is nothing that makes the SQL interface (or postgres core
> for that matter) particularly more suited for this job than other existing
> tools.
> 
> Why is SQL level crucial for this?

Because the figure is interesting to users as well. They will usually
not have any access to monitoring, and checking if they can load this
extra 10 GB dataset is a good use case.

This is about providing the numbers in the place where they are
needed. Of course admins can just go elsewhere to look it up (and
probably will), but I think now there's a usability gap for people who
just have SQL access.

Christoph