[stats-dev] [jgardner@jonathangardner.net: [PERFORM] Materialized View Summary]

Jim C. Nasby jim at nasby.net
Tue Feb 24 16:52:55 EST 2004


FYI
----- Forwarded message from "Jonathan M. Gardner" <jgardner at jonathangardner.net> -----

Delivered-To: nasby-jim at nasby.net
X-Original-To: pgsql-performance-postgresql.org at localhost.postgresql.org
From: "Jonathan M. Gardner" <jgardner at jonathangardner.net>
To: pgsql-hackers at postgresql.org, pgsql-sql at postgresql.org,
   pgsql-performance at postgresql.org
Subject: [PERFORM] Materialized View Summary
Date: Tue, 24 Feb 2004 08:11:03 -0800
User-Agent: KMail/1.5.94
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Mailing-List: pgsql-performance
Precedence: bulk
X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on 
	flake.decibel.org
X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham 
	version=2.60
X-Spam-Level: 

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

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo at postgresql.org)


----- End forwarded message -----

-- 
Jim C. Nasby, Database Consultant                  jim at nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


More information about the stats-dev mailing list