Re: selecting data from information_schema.columns performance.

On Sun, Oct 01, 2006 at 11:01:19PM -0400, Tom Lane wrote:
> Steve Martin <smartin@nec.co.nz> writes:
> > I am trying to determine if there is a way to improve the performance
> > when selecting data from the information_schema.columns view.
>
> In my experience, there isn't any single one of the information_schema
> views whose performance doesn't suck :-(.  Somebody should work on that
> sometime.  I haven't looked closely enough to determine where the
> bottlenecks are.

Looking at the newsysviews stuff should prove enlightening...
AndrewSN spent a lot of time making sure those views are very
performant.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)