Re: [PERFORM] Materialized View Summary

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jonathan M(dot) Gardner" <jgardner(at)jonathangardner(dot)net>
Cc: PostgreSQL www <pgsql-www(at)postgresql(dot)org>
Subject: Re: [PERFORM] Materialized View Summary
Date: 2004-03-02 16:40:46
Message-ID: 200403021640.i22Gek325112@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance pgsql-sql pgsql-www


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(at)jonathangardner(dot)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(dot)org)
>
[ End of raw data]

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2004-03-02 16:54:12 Re: [PERFORM] Materialized View Summary
Previous Message Greg Patnude 2004-03-02 16:23:16 Re: User defined types -- Social Security number...

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Treat 2004-03-02 16:54:12 Re: [PERFORM] Materialized View Summary
Previous Message Oliver Elphick 2004-03-02 11:48:06 Re: Select-Insert-Query

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Treat 2004-03-02 16:54:12 Re: [PERFORM] Materialized View Summary
Previous Message Greg Patnude 2004-03-02 16:23:16 Re: User defined types -- Social Security number...

Browse pgsql-www by date

  From Date Subject
Next Message Robert Treat 2004-03-02 16:54:12 Re: [PERFORM] Materialized View Summary
Previous Message Devrim GUNDUZ 2004-03-02 14:27:34 Re: New Event