Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4596: information_schema.table_privileges is way too slow - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4596: information_schema.table_privileges is way too slow
Date
Msg-id 17300.1230170357@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4596: information_schema.table_privileges is way too slow  ("Kirill Simonov" <xi@gamma.dn.ua>)
Responses Re: BUG #4596: information_schema.table_privileges is way too slow  (Kirill Simonov <xi@gamma.dn.ua>)
List pgsql-bugs
Tree view 
"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?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Kirill Simonov"
Date:
Subject: BUG #4596: information_schema.table_privileges is way too slow
Next
From: Kirill Simonov
Date:
Subject: Re: BUG #4596: information_schema.table_privileges is way too slow