2008/12/25 Kirill Simonov <x...@gamma.dn.ua>: > 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
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 > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
