From: Robert Treat <xzilla@users.sourceforge.net>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Jonathan M. Gardner <jgardner@jonathangardner.net>
Cc: PostgreSQL www <pgsql-www@postgresql.org>
Subject: Re: [PERFORM] Materialized View Summary
Date: 02 Mar 2004 11:54:12 -0500
Message-ID: <1078246452.3204.123.camel@camel> (raw)
In-Reply-To: <200403021640.i22Gek325112@candle.pha.pa.us>
References: <200403021640.i22Gek325112@candle.pha.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: xzilla@users.sourceforge.net, pgman@candle.pha.pa.us, jgardner@jonathangardner.net, pgsql-www@postgresql.org
Subject: Re: [PERFORM] Materialized View Summary
In-Reply-To: <1078246452.3204.123.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox