Re: selecting data from information_schema.columns performance. - Mailing list pgsql-performance

From Tom Lane
Subject Re: selecting data from information_schema.columns performance.
Date
Msg-id 26736.1159758079@sss.pgh.pa.us
Whole thread Raw
In response to selecting data from information_schema.columns performance.  (Steve Martin <smartin@nec.co.nz>)
Responses Re: selecting data from information_schema.columns performance.
List pgsql-performance
Steve Martin <smartin@nec.co.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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Steve Martin
Date:
Subject: selecting data from information_schema.columns performance.
Next
From: Simon Riggs
Date:
Subject: Re: PostgreSQL runs a query much slower than BDE and