Skip site navigation (1) Skip section navigation (2)

Re: views?

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Loeke" <LoekeDoeLoekeDoe(at)dontlikespam(dot)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: views?
Date: 2004-01-31 04:35:31
Message-ID: 87k738ivl8.fsf@mailbox.samurai.com (view raw or flat)
Thread:
Lists: pgsql-performance
"Loeke" <LoekeDoeLoekeDoe(at)dontlikespam(dot)hotmail(dot)com> writes:
> do views exist fysically a separate "table", or are they generated
> on the fly whenever they are queried?

Views are implementing by rewriting queries into the appropriate query
on the view's base tables.

http://www.postgresql.org/docs/current/static/rules-views.html

> if they exist fysically they could improve performance (..php, web),

This is called a "materialized view". PostgreSQL doesn't support them
yet, but most people think it would be a Good Thing to have.

-Neil


In response to

  • views? at 2004-01-28 18:56:46 from Loeke

Responses

  • Re: views? at 2004-02-02 09:48:21 from Richard Huxton

pgsql-performance by date

Next:From: Tom LaneDate: 2004-01-31 05:07:53
Subject: Re: High Performance/High Reliability File system on SuSE64
Previous:From: Josh BerkusDate: 2004-01-31 01:45:45
Subject: Re: Unique index and estimated rows.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group