Materialized View Summary

From: "Jonathan M(dot) Gardner" <jgardner(at)jonathangardner(dot)net>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Materialized View Summary
Date: 2004-02-24 16:11:03
Message-ID: 200402240811.13013.jgardner@jonathangardner.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance pgsql-sql pgsql-www

-----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(at)jonathangardner(dot)net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAO3eZqp6r/MVGlwwRAnpEAKC8+/lFyPBbXetPEfFLwgUvJZLCmgCfYlmR
0vZmCcbGSNT/m/W8QOIhufk=
=snCu
-----END PGP SIGNATURE-----

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-02-24 16:16:30 Re: dollar quoting nits
Previous Message Shridhar Daithankar 2004-02-24 15:57:23 Re: Sparc optimizations

Browse pgsql-performance by date

  From Date Subject
Next Message Nick Barr 2004-02-24 16:44:57 Re: Slow join using network address function
Previous Message Tom Lane 2004-02-24 15:23:22 Re: Slow join using network address function

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2004-02-24 17:11:20 Re: [SQL] Materialized View Summary
Previous Message Sumita Biswas (sbiswas) 2004-02-24 15:35:07 Execute Query in Postgres Function

Browse pgsql-www by date

  From Date Subject
Next Message Richard Huxton 2004-02-24 17:11:20 Re: [SQL] Materialized View Summary
Previous Message L J Bayuk 2004-02-24 02:47:09 Re: tcl on gborg, pgtclsh