[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 ab

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 pgs