Kirill Simonov writes:
> Pavel Stehule wrote:
>> really it's should be slow, it's cross join pg_class, pg_authid, pg_authid
> Yes, I realize why it's slow. I'm introspecting the database schema,
> that's why I need the whole contents of "table_privileges". I suppose I
> could obtain the same
Pavel Stehule wrote:
really it's should be slow, it's cross join pg_class, pg_authid, pg_authid
for fast respond you have to specify minimally table_name and grantor fields.
select * from information_schema.table_privileges where table_name =
'foo' and grantor = 'pavel';
Yes, I realize why i
Pavel Stehule wrote:
2008/12/25 Kirill Simonov :
Tom Lane wrote:
"Kirill Simonov" 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 usi
Hello
really it's should be slow, it's cross join pg_class, pg_authid, pg_authid
for fast respond you have to specify minimally table_name and grantor fields.
select * from information_schema.table_privileges where table_name =
'foo' and grantor = 'pavel';
regards
Pavel Stehule
2008/12/25, Kir
Really, this view is strange. I'll look on at
Pavel
2008/12/25, Kirill Simonov :
> Pavel Stehule wrote:
>> 2008/12/25 Kirill Simonov :
>>> Tom Lane wrote:
"Kirill Simonov" writes:
> It takes about 5 minutes to perform the query
> SELECT * FROM information_schema.table_privileges
>>>
2008/12/25 Kirill Simonov :
> Tom Lane wrote:
>>
>> "Kirill Simonov" 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
Tom Lane wrote:
"Kirill Simonov" 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
