The following bug has been logged online:
Bug reference: 4596
Logged by: Kirill Simonov
Email address: xi@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