Re: [Fwd: View Vs. Table] - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: [Fwd: View Vs. Table]
Date
Msg-id 20070306155258.GC15417@phlogiston.dyndns.org
Whole thread Raw
In response to [Fwd: View Vs. Table]  ("Radhika Sambamurti" <radhika@88thstreet.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Selecting exactly one row for each column value
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Inc