From: Jan Wieck <JanWieck@Yahoo.com>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: Ries van Twisk <ries@jongert.nl>
Cc: pgsql-sql@postgresql.org
Subject: Re: To use a VIEW or not to use a View.....
Date: Wed, 22 Jan 2003 12:30:47 -0500
Message-ID: <3E2ED547.DF9F68D4@Yahoo.com> (raw)
References: <002001c2c228$bc3d2780$f100000a@IT001>
<3E2EBCEE.EF487ECC@Yahoo.com>
<3E2EC4E9.7000809@klaster.net>
Tomasz Myrta wrote:
>
> Jan Wieck wrote:
>
> >Use tables, views and views over views, it's all fine and your indexes
> >will be used.
>
> I can't agree with using views over views. It has some limitations.
> I asked about it on this list several months ago
> and Tom Lane's conclusion was:
It has less to do with the nesting level of rewriting, than with what
you do with the view in general. If you cram up all the functionality
with aggregating subselects into one monster view it might do better,
except for maintaining the code.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: JanWieck@Yahoo.com, jasiek@klaster.net, ries@jongert.nl
Subject: Re: To use a VIEW or not to use a View.....
In-Reply-To: <3E2ED547.DF9F68D4@Yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox