From: Jonathan M. Gardner <jgardner@jonathangardner.net>
To: pgsql-hackers@postgresql.org
To: pgsql-sql@postgresql.org
To: pgsql-performance@postgresql.org
Subject: Materialized View Summary
Date: Tue, 24 Feb 2004 08:11:03 -0800
Message-ID: <200402240811.13013.jgardner@jonathangardner.net> (raw)
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jgardner@jonathangardner.net, pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org
Subject: Re: Materialized View Summary
In-Reply-To: <200402240811.13013.jgardner@jonathangardner.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox