Re: [PATCH] Add regress test for pg_read_all_stats role

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [PATCH] Add regress test for pg_read_all_stats role
Дата
Msg-id 20180926062916.GK1659@paquier.xyz
обсуждение исходный текст
Ответ на Re: [PATCH] Add regress test for pg_read_all_stats role  (Alexandra Ryzhevich <aryzhevich@google.com>)
Список pgsql-hackers
On Fri, Aug 24, 2018 at 03:37:17PM +0100, Alexandra Ryzhevich wrote:
> CONNECT ON DATABASE privilege is granted to public by default (so
> all users by default can select pg_database_size()) and
> REVOKE CONNECT ... FROM <username> command doesn't impact
> user's privileges. The only way to revoke connect privilege from user
> is to revoke it from public. That's why maybe it will be less harmful
> just to remove pg_database_size tests at all. But will it be better to
> remove pg_tablespace_size() tests also? if possible costs are more
> harmful than not testing this code path then I'll remove these tests
> also.

Sorry for the delay, Alexandra, and thanks for the new version.  I have
removed the tests related to pg_tablespace_size as they are costly and
those for vacuum_cost_delay as we didn't gain more with those tests.
The rest has been committed, which makes a good first cut.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: pgbench - add pseudo-random permutation function
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: file cloning in pg_upgrade and CREATE DATABASE