X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0486C329EA6 for ; Tue, 21 Sep 2004 00:06:20 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54261-01 for ; Mon, 20 Sep 2004 23:06:12 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 57900329E74 for ; Tue, 21 Sep 2004 00:06:14 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i8KN6E2a022848; Mon, 20 Sep 2004 19:06:14 -0400 (EDT) To: "Dean Gibson (DB Administrator)" Cc: pgsql-sql@postgresql.org Subject: Re: JOIN performance In-reply-to: <5.1.0.14.2.20040920121606.00a89c68@imaps.mailpen.net> References: <414F02FF.8000603@numerixtechnology.de> <414F02FF.8000603@numerixtechnology.de> <5.1.0.14.2.20040920121606.00a89c68@imaps.mailpen.net> Comments: In-reply-to "Dean Gibson (DB Administrator)" message dated "Mon, 20 Sep 2004 12:24:49 -0700" Date: Mon, 20 Sep 2004 19:06:14 -0400 Message-ID: <22847.1095721574@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/174 X-Sequence-Number: 19020 "Dean Gibson (DB Administrator)" 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