Re: [patch] Add schema total size to psql \dn+

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [patch] Add schema total size to psql \dn+
Дата
Msg-id 18445.1550859710@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [patch] Add schema total size to psql \dn+  (Robert Haas <robertmhaas@gmail.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Shawn Debnath
Дата:
Сообщение: Re: Refactoring the checkpointer's fsync request queue
Следующее
От: Ibrar Ahmed
Дата:
Сообщение: Temporal Table Proposal