Materialized View Summary
От | Jonathan M. Gardner |
---|---|
Тема | Materialized View Summary |
Дата | |
Msg-id | 200402240811.13013.jgardner@jonathangardner.net обсуждение исходный текст |
Ответы |
Re: [SQL] Materialized View Summary
Re: [HACKERS] Materialized View Summary |
Список | pgsql-performance |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I've written a summary of my findings on implementing and using materialized views in PostgreSQL. I've already deployed eagerly updating materialized views on several views in a production environment for a company called RedWeek: http://redweek.com/. As a result, some queries that were taking longer than 30 seconds to run now run in a fraction of a millisecond. You can view my summary at http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Comments and suggestions are definitely welcome. - -- Jonathan Gardner jgardner@jonathangardner.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAO3eZqp6r/MVGlwwRAnpEAKC8+/lFyPBbXetPEfFLwgUvJZLCmgCfYlmR 0vZmCcbGSNT/m/W8QOIhufk= =snCu -----END PGP SIGNATURE-----
В списке pgsql-performance по дате отправления: