On Sun, Oct 01, 2006 at 11:01:19PM -0400, Tom Lane wrote:
> Steve Martin <smartin(at)nec(dot)co(dot)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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)