Materialized View Summary - Mailing list pgsql-performance

From Jonathan M. Gardner
Subject Materialized View Summary
Date
Msg-id 200402240811.13013.jgardner@jonathangardner.net
Whole thread Raw
Responses Re: [SQL] Materialized View Summary
Re: [HACKERS] Materialized View Summary
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow join using network address function
Next
From: Nick Barr
Date:
Subject: Re: Slow join using network address function