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