pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Christoph Berg <myon@debian.org>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Christoph Moench-Tegeder <cmt@burggraben.net>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Monitoring disk space from within the server
Date: Tue, 12 Nov 2019 10:04:24 +0100
Message-ID: <20191112090424.GA20731@msg.df7cb.de> (raw)
In-Reply-To: <7A3B9BB6-BEA0-466E-98A9-B4DD8F04830E@yesql.se>
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>

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





view thread (22+ messages)  latest in thread

Message-ID: <20191112090424.GA20731@msg.df7cb.de>
Permalink:  ../20191112090424.GA20731@msg.df7cb.de/
Also on:    postgresql.org/message-id/20191112090424.GA20731@msg.df7cb.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: myon@debian.org, daniel@yesql.se, michael@paquier.xyz, cmt@burggraben.net, rjuju123@gmail.com
  Subject: Re: Monitoring disk space from within the server
  In-Reply-To: <20191112090424.GA20731@msg.df7cb.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox