On Sun, Oct 01, 2006 at 11:01:19PM -0400, Tom Lane wrote: > Steve Martin <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
