X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 557E1D1B9BB for ; Tue, 2 Mar 2004 16:41:02 +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 39280-08 for ; Tue, 2 Mar 2004 12:40:57 -0400 (AST) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 5F27BD1B470 for ; Tue, 2 Mar 2004 12:40:53 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i22Gek325112; Tue, 2 Mar 2004 11:40:46 -0500 (EST) From: Bruce Momjian Message-Id: <200403021640.i22Gek325112@candle.pha.pa.us> Subject: Re: [PERFORM] Materialized View Summary In-Reply-To: <200402240811.13013.jgardner@jonathangardner.net> To: "Jonathan M. Gardner" Date: Tue, 2 Mar 2004 11:40:46 -0500 (EST) Cc: PostgreSQL www X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/15 X-Sequence-Number: 3831 Can we get this URL added to the techdocs site please? Thanks. --------------------------------------------------------------------------- Jonathan M. Gardner wrote: [ PGP not available, raw data follows ] > -----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----- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > [ End of raw data] -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073