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

help / color / mirror / Atom feed

From: Christoph Berg <myon@debian.org>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Monitoring disk space from within the server
Date: Fri, 8 Nov 2019 15:00:03 +0100
Message-ID: <20191108140003.GK8017@msg.df7cb.de> (raw)
In-Reply-To: <CAOBaU_ay0FT6dFt61Pae77pHEu6sny3xM43L4i-pPi5kKkguxQ@mail.gmail.com>
References: <20191108132419.GG8017@msg.df7cb.de>
	<CAOBaU_YVGEnsnP1ufp42NiJ+WvPHRWBOsBOcaxWxsbXPN_sdNQ@mail.gmail.com>
	<20191108134013.GI8017@msg.df7cb.de>
	<CAOBaU_ay0FT6dFt61Pae77pHEu6sny3xM43L4i-pPi5kKkguxQ@mail.gmail.com>

Re: Julien Rouhaud 2019-11-08 <CAOBaU_ay0FT6dFt61Pae77pHEu6sny3xM43L4i-pPi5kKkguxQ@mail.gmail.com>
> > We could append the quotactl(Q_GETQUOTA) information as well, but I'm
> > not sure this has a sensible actual-users-to-noise ratio.
> 
> Well, having a quota is one of the few real reason to create a
> tablespace so it's probably worth it, although  I have to agree that I
> seldom saw quota in production.

Given that PG deals badly with one tablespace being full (might work
in production, but if it's full during recovery, the whole server will
stop), I've never seen quotas being used.

Christoph

view thread (22+ messages)  latest in thread

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

copy link · copy postgr.es

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, rjuju123@gmail.com
  Subject: Re: Monitoring disk space from within the server
  In-Reply-To: <20191108140003.GK8017@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