Re: [Fwd: View Vs. Table]

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [Fwd: View Vs. Table]
Date: 2007-03-06 15:52:58
Message-ID: 20070306155258.GC15417@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-03-06 16:55:35 Inc
Previous Message Florian Weimer 2007-03-06 15:46:29 Re: Selecting exactly one row for each column value