Re: Monitoring disk space from within the server - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: Monitoring disk space from within the server
Date
Msg-id 20191112090424.GA20731@msg.df7cb.de
Whole thread Raw
In response to Re: Monitoring disk space from within the server  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_waldump and PREPARE
Next
From: Julien Rouhaud
Date:
Subject: Re: Monitoring disk space from within the server