Re: [patch] Add schema total size to psql \dn+ - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [patch] Add schema total size to psql \dn+
Date
Msg-id 18445.1550859710@sss.pgh.pa.us
Whole thread Raw
In response to Re: [patch] Add schema total size to psql \dn+  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [patch] Add schema total size to psql \dn+  (Julien Rouhaud <rjuju123@gmail.com>)
Re: [patch] Add schema total size to psql \dn+  (Gilles Darold <gilles.darold@dalibo.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Feb 20, 2019 at 5:26 PM Gilles Darold <gilles.darold@dalibo.com> wrote:
>> The attached simple patch adds this feature. Is there any cons adding
>> this information?

> Well, it'll take time to compute, maybe a lot of time if the database
> is big and the server is busy.  Not sure how serious that problem can
> get.

Is there any permissions issue involved here?  I'd be a bit worried
about whether \dn+ could fail, or deliver misleading answers, when
run by a user without permissions on (some) tables.  Also, even if
we allow people to get size info on tables they can't read today,
having this feature would be a roadblock to tightening that in
the future.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Shawn Debnath
Date:
Subject: Re: Refactoring the checkpointer's fsync request queue
Next
From: Ibrar Ahmed
Date:
Subject: Temporal Table Proposal