Re: JOIN performance - Mailing list pgsql-sql

From Tom Lane
Subject Re: JOIN performance
Date
Msg-id 22847.1095721574@sss.pgh.pa.us
Whole thread Raw
In response to JOIN performance  ("Dean Gibson (DB Administrator)" <postgresql3@ultimeth.com>)
Responses Re: JOIN performance  ("Dean Gibson (DB Administrator)" <postgresql3@ultimeth.com>)
List pgsql-sql
"Dean Gibson (DB Administrator)" <postgresql3@ultimeth.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


pgsql-sql by date:

Previous
From: Andrew Hammond
Date:
Subject: Re: CREATE TABLE AS SELECT....
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: JOIN performance