Re: [PERFORM] selecting data from information_schema.columns

2006-10-02 Thread Jim Nasby
On Oct 2, 2006, at 7:31 PM, Steve Martin wrote: Regarding, newsysviews, what is the current state, I have had a quick look at the pgFoundry site and the last updates were 9 months ago. Well, the system catalogs don't change terribly often, so it's not like a lot needs to be done. We'd hope

Re: [PERFORM] selecting data from information_schema.columns

2006-10-02 Thread Steve Martin
Hi Thanks for you replies. Regarding, newsysviews, what is the current state, I have had a quick look at the pgFoundry site and the last updates were 9 months ago. The most efficient way in the short term I can find to improve performance for our application is to create a table from inform

Re: [PERFORM] selecting data from information_schema.columns performance.

2006-10-02 Thread Jim C. Nasby
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

Re: [PERFORM] selecting data from information_schema.columns performance.

2006-10-01 Thread Tom Lane
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 :-(. Somebo