Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4596: information_schema.table_privileges is way too slow - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #4596: information_schema.table_privileges is way too slow
Date
Msg-id 200812291251.55524.peter_e@gmx.net
Whole thread Raw
In response to Re: BUG #4596: information_schema.table_privileges is way too slow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
On Friday 26 December 2008 01:12:26 Tom Lane wrote:
> More generally, there are a *whole lot* of ridiculous inefficiencies
> in our information_schema views; I'm surprised there haven't been
> more complaints about them.  Sometime someone ought to go through
> the whole set and see what other refactorings might be appropriate
> to make them work better.

Added to TODO.  Could probably be accomplished for 8.5.

pgsql-bugs by date:

Previous
From: davidsarmstrong
Date:
Subject: Re: BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result
Next
From: Alvaro Herrera
Date:
Subject: Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held