Re: BUG #4596: information_schema.table_privileges is way too slow

2008/12/25 Kirill Simonov <xi@gamma.dn.ua>:
> 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

two years ago I tested 50000 users without problems. Try to vacuum and
reindex your system tables

regards
Pavel Stehule

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