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

[PERFORM] selecting data from information_schema.columns performance.

2006-10-01 Thread Steve Martin
Hi, I am trying to determine if there is a way to improve the performance when selecting data from the information_schema.columns view. We use data from this view to inform our application information on the columns on a table and is used when data is selected from a table. Below is the out