Materialized View Summary

Поиск
Список
Период
Сортировка
От Jonathan M. Gardner
Тема Materialized View Summary
Дата
Msg-id 200402240811.13013.jgardner@jonathangardner.net
обсуждение исходный текст
Ответы Re: [SQL] Materialized View Summary  (Richard Huxton <dev@archonet.com>)
Re: [HACKERS] Materialized View Summary  (Mark Gibson <gibsonm@cromwell.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow join using network address function
Следующее
От: Nick Barr
Дата:
Сообщение: Re: Slow join using network address function