Skip site navigation (1) Skip section navigation (2)

Re: JOIN performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: JOIN performance
Date: 2004-09-20 23:06:14
Message-ID: 22847.1095721574@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
"Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com> writes:
> I have a view that when used, is slow:

It's obvious that you haven't given us anything remotely like full
information here.  AFAICT the "tables" in your view are actually
other views, plus it looks like your call to the view is a query
that adds some other conditions you didn't mention.  (Or are those
conditions coming from the sub-views?  Hard to tell.)  If you want
useful help you need to be more complete.

			regards, tom lane

In response to

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-09-20 23:23:16
Subject: Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ?
Previous:From: Andrew HammondDate: 2004-09-20 21:56:43
Subject: Re: CREATE TABLE AS SELECT....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group