Tom Lane wrote:
"Kirill Simonov" <x...@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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to