BUG #4596: information_schema.table_privileges is way too slow

From: "Kirill Simonov" <xi(at)gamma(dot)dn(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4596: information_schema.table_privileges is way too slow
Date: 2008-12-24 20:40:47
Message-ID: 200812242040.mBOKelf5093189@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-12-25 01:59:17 Re: BUG #4596: information_schema.table_privileges is way too slow
Previous Message Alvaro Herrera 2008-12-23 15:47:03 Re: Problem on Installation