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-----
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 |
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 |
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 |
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 |