X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D8337D1B4C5 for ; Tue, 24 Feb 2004 16:11:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 90697-07 for ; Tue, 24 Feb 2004 12:11:38 -0400 (AST) Received: from mail2.speakeasy.net (mail2.speakeasy.net [216.254.0.202]) by svr1.postgresql.org (Postfix) with ESMTP id 9CE1AD1B989 for ; Tue, 24 Feb 2004 12:11:33 -0400 (AST) Received: (qmail 22002 invoked from network); 24 Feb 2004 16:11:29 -0000 Received: from atlas.jonathangardner.net (HELO jonathangardner.net) (jgardn@[66.92.192.166]) (envelope-sender ) by mail2.speakeasy.net (qmail-ldap-1.03) with RC4-MD5 encrypted SMTP for ; 24 Feb 2004 16:11:29 -0000 From: "Jonathan M. Gardner" To: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org, pgsql-performance@postgresql.org Subject: Materialized View Summary Date: Tue, 24 Feb 2004 08:11:03 -0800 User-Agent: KMail/1.5.94 MIME-Version: 1.0 Content-Disposition: inline Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message-Id: <200402240811.13013.jgardner@jonathangardner.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/278 X-Sequence-Number: 5802 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I've written a summary of my findings on implementing and using=20 materialized views in PostgreSQL. I've already deployed eagerly updating=20 materialized views on several views in a production environment for a=20 company called RedWeek: http://redweek.com/. As a result, some queries=20 that were taking longer than 30 seconds to run now run in a fraction of a= =20 millisecond. You can view my summary at=20 http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Comments and suggestions are definitely welcome. - --=20 Jonathan Gardner jgardner@jonathangardner.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAO3eZqp6r/MVGlwwRAnpEAKC8+/lFyPBbXetPEfFLwgUvJZLCmgCfYlmR 0vZmCcbGSNT/m/W8QOIhufk=3D =3DsnCu -----END PGP SIGNATURE-----