Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id B6E639FBAD1 for ; Tue, 6 Mar 2007 11:53:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 27890-08 for ; Tue, 6 Mar 2007 11:52:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 49A159FBAC3 for ; Tue, 6 Mar 2007 11:53:09 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HOcDR-00047S-CQ for pgsql-sql@postgresql.org; Tue, 06 Mar 2007 11:08:41 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id C3C044050; Tue, 6 Mar 2007 10:52:58 -0500 (EST) Date: Tue, 6 Mar 2007 10:52:58 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: [Fwd: View Vs. Table] Message-ID: <20070306155258.GC15417@phlogiston.dyndns.org> References: <14956.63.118.86.10.1173192052.squirrel@www.88thstreet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <14956.63.118.86.10.1173192052.squirrel@www.88thstreet.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/49 X-Sequence-Number: 27687 On Tue, Mar 06, 2007 at 09:40:52AM -0500, Radhika Sambamurti wrote: > But from the db point of view, is there a bigger performace hit when I > query a view Vs a table or is there no difference. It rather depends on your view definition. See the discussion of views and, especially, the discussion of rules in the manual (views are basically just an automatic application of certain rules). A -- Andrew Sullivan | ajs@crankycanuck.ca Information security isn't a technological problem. It's an economics problem. --Bruce Schneier