Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 25 Dec 2008 10:23:44 +0200
- Message-id: <49534310.5090603@gamma.dn.ua> <text/plain>
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
- Follow-Ups:
- Re: BUG #4596: information_schema.table_privileges is way too slow
- From: Pavel Stehule
- Re: BUG #4596: information_schema.table_privileges is way too slow
- References:
- BUG #4596: information_schema.table_privileges is way too slow
- From: Kirill Simonov
- Re: BUG #4596: information_schema.table_privileges is way too slow
- From: Tom Lane
- BUG #4596: information_schema.table_privileges is way too slow
- Prev by Date: Re: BUG #4596: information_schema.table_privileges is way too slow
- Next by Date: Re: BUG #4596: information_schema.table_privileges is way too slow
- Previous by thread: Re: BUG #4596: information_schema.table_privileges is way too slow
- Next by thread: Re: BUG #4596: information_schema.table_privileges is way too slow
- Indexes: