[Phpwm] Postgres query plan terminology

[David Goodwin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greg Jones wrote:
> They have nothing in the context of query plans, but the example of
> 'creating a materialized view' in the stored-procedures bit has, I
> think, informed me that it's to do with snap-shotting a view (or
> query-results) for re-use, which kindof makes sense. Does this seem to
> agree with what your book says?

Yes, it says some like :

It's used for some subselections, but only if the optimizer thinks it is
less expensive to materialize a subselection once than to do it for each
top level row.

It's also used on some merge-join operations, if the inner input set is
not produced by a seq scan, index scan, sort or a materialize operator.


I dislike the way it describes what it does using it's own name.

David.
- --
David Goodwin

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHHym6/ISo3RF5V6YRAmodAJ458xcwO/pjiZQVUk53vpIXYVIsTQCgwUHD
XmUf4NTuvHiaV9j6U3jwMMQ=
=9Q59
-----END PGP SIGNATURE-----