From: Jim C. Nasby <jim@nasby.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Steve Martin <smartin@nec.co.nz>
Cc: pgsql-performance@postgresql.org
Subject: Re: selecting data from information_schema.columns performance.
Date: Mon, 2 Oct 2006 14:11:23 -0500
Message-ID: <20061002191123.GH81937@nasby.net> (raw)
In-Reply-To: <26736.1159758079@sss.pgh.pa.us>
References: <452078EC.90300@nec.co.nz>
<26736.1159758079@sss.pgh.pa.us>
On Sun, Oct 01, 2006 at 11:01:19PM -0400, Tom Lane wrote:
> 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.
Looking at the newsysviews stuff should prove enlightening...
AndrewSN spent a lot of time making sure those views are very
performant.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jim@nasby.net, tgl@sss.pgh.pa.us, smartin@nec.co.nz
Subject: Re: selecting data from information_schema.columns performance.
In-Reply-To: <20061002191123.GH81937@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox