"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.
> 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.
In response to
- views? at 2004-01-28 18:56:46 from Loeke
- Re: views? at 2004-02-02 09:48:21 from Richard Huxton
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2004-01-31 05:07:53|
|Subject: Re: High Performance/High Reliability File system on SuSE64 |
|Previous:||From: Josh Berkus||Date: 2004-01-31 01:45:45|
|Subject: Re: Unique index and estimated rows.|