[BUGS] BUG #4596: information_schema.table_privileges is way too slow

2008-12-24 Thread Kirill Simonov 

The following bug has been logged online:

Bug reference:  4596
Logged by:  Kirill Simonov
Email address:  x...@gamma.dn.ua
PostgreSQL version: 8.3.5
Operating system:   Linux Ubuntu 8.10
Description:information_schema.table_privileges is way too slow
Details: 

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).

postgres=# select * from information_schema.table_privileges;
Time: 296409.513 ms

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

2008-12-24 Thread Tom Lane 
"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?

regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs