[Phpwm] Postgres query plan terminology

[David Goodwin]

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

Greg Jones wrote:
> Does anyone know of anything that will tell me what exactly is meant
> by the various terms used when I run an 'explain analyze' on a query?
> Some are fairly self explanatory ('seq_scan' vs 'index_scan' for
> example) but I have no idea what 'materialize' means in this context?
> 


our postgresql book - 0-7357-1257-3 (Douglas & Douglas) mentions
Materialize...


I could copy and paste it into here, but it doesn't mean much to me. Are
you sure the online postgresql docs don't cover this?

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

iD8DBQFHHxRT/ISo3RF5V6YRApECAJ9Gzxg0YjUZ6avgrgBO4CkoAVaofACfRZNI
PqMxH6WJ7GVUVnVm9leUjD4=
=ISGo
-----END PGP SIGNATURE-----