Re: BUG #4596: information_schema.table_privileges is way too slow - Mailing list pgsql-bugs

Tom Lane wrote:
> "Kirill Simonov" <xi@gamma.dn.ua> writes:
>> It takes about 5 minutes to perform the query
>> SELECT * FROM information_schema.table_privileges
>> on an empty database (i.e. with system tables only).
>
> Not here.  What non-default settings might you be using?
>

Indeed, it is slow because there are a lot of rows in pg_authid (about
700).  Is there a possibility to make table_privileges faster with a
large number of roles?

Thanks,
Kirill