Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

BUG #4596: information_schema.table_privileges is way too slow



The following bug has been logged online:

Bug reference:      4596
Logged by:          Kirill Simonov
Email address:      xi(at)gamma(dot)dn(dot)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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group