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 9063BD1B470 for ; Tue, 2 Mar 2004 16:54:43 +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 50692-05 for ; Tue, 2 Mar 2004 12:54:39 -0400 (AST) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 2D53CD1B906 for ; Tue, 2 Mar 2004 12:54:38 -0400 (AST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i22GPRcM032388; Tue, 2 Mar 2004 11:25:27 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i22GsDl02530; Tue, 2 Mar 2004 11:54:13 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id FVMAV3RM; Tue, 2 Mar 2004 11:54:11 -0500 Subject: Re: [PERFORM] Materialized View Summary From: Robert Treat To: Bruce Momjian Cc: "Jonathan M. Gardner" , PostgreSQL www In-Reply-To: <200403021640.i22Gek325112@candle.pha.pa.us> References: <200403021640.i22Gek325112@candle.pha.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 02 Mar 2004 11:54:12 -0500 Message-Id: <1078246452.3204.123.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/16 X-Sequence-Number: 3832 Already there, under "Technical Guides and Documents", I gave it a new section "Materialized Views" Robert Treat On Tue, 2004-03-02 at 11:40, Bruce Momjian wrote: > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL