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

From: Kirill Simonov <xi(at)gamma(dot)dn(dot)ua>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4596: information_schema.table_privileges is way too slow
Date: 2008-12-25 08:23:44
Message-ID: 49534310.5090603@gamma.dn.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
> "Kirill Simonov" <xi(at)gamma(dot)dn(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2008-12-25 10:53:36 Re: BUG #4596: information_schema.table_privileges is way too slow
Previous Message Tom Lane 2008-12-25 01:59:17 Re: BUG #4596: information_schema.table_privileges is way too slow