Re: selecting data from information_schema.columns performance.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Martin <smartin(at)nec(dot)co(dot)nz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: selecting data from information_schema.columns performance.
Date: 2006-10-02 03:01:19
Message-ID: 26736.1159758079@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Steve Martin <smartin(at)nec(dot)co(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2006-10-02 13:06:50 Re: PostgreSQL runs a query much slower than BDE and
Previous Message Steve Martin 2006-10-02 02:26:52 selecting data from information_schema.columns performance.