[stats-dev] [jgardner@jonathangardner.net: [PERFORM] Materialized View Summary]

Jim C. Nasby decibel at distributed.net
Thu Feb 26 18:56:31 EST 2004


It was mostly FYI, but also something we might want to look at.

On Tue, Feb 24, 2004 at 07:49:54PM -0800, Benjamin Gavin wrote:
>   Was there something particular that you had in mind, or just for the
> general interest?  This reminds me again why DBMSs should just support
> this type of functionality out of box.
> 
>   Does PGSQL 7.4 support the ANSI method of table/view schema discovery? 
> If so, it would seem that it should be fairly straightforward to
> genericize his findings so as not to have to reconstruct each view...
> 
> Ben
> 
> --- "Jim C. Nasby" <jim at nasby.net> wrote:
> > FYI
> > ----- Forwarded message from "Jonathan M. Gardner"
> > <jgardner at jonathangardner.net> -----
> > 
> > Delivered-To: nasby-jim at nasby.net
> > X-Original-To: pgsql-performance-postgresql.org at localhost.postgresql.org
> > From: "Jonathan M. Gardner" <jgardner at jonathangardner.net>
> > To: pgsql-hackers at postgresql.org, pgsql-sql at postgresql.org,
> >    pgsql-performance at postgresql.org
> > Subject: [PERFORM] Materialized View Summary
> > Date: Tue, 24 Feb 2004 08:11:03 -0800
> > User-Agent: KMail/1.5.94
> > X-Virus-Scanned: by amavisd-new at postgresql.org
> > X-Mailing-List: pgsql-performance
> > Precedence: bulk
> > X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on 
> > 	flake.decibel.org
> > X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00
> > autolearn=ham 
> > 	version=2.60
> > X-Spam-Level: 
> > 
> > -----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.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.org)
> > 
> > 
> > ----- End forwarded message -----
> > 
> > -- 
> > Jim C. Nasby, Database Consultant                  jim at nasby.net
> > Member: Triangle Fraternity, Sports Car Club of America
> > Give your computer some brain candy! www.distributed.net Team #1828
> > 
> > Windows: "Where do you want to go today?"
> > Linux: "Where do you want to go tomorrow?"
> > FreeBSD: "Are you guys coming, or what?"
> > _______________________________________________
> > stats-dev mailing list
> > stats-dev at lists.distributed.net
> > http://lists.distributed.net/mailman/listinfo/stats-dev
> 
> 
> =====
> /******************************/
> Benjamin Gavin
> virtual.olympus software
> ben at virtual-olympus.com
> http://www.virtual-olympus.com/
> /******************************/
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools
> _______________________________________________
> stats-dev mailing list
> stats-dev at lists.distributed.net
> http://lists.distributed.net/mailman/listinfo/stats-dev
> 

-- 
Jim C. Nasby, Database Consultant                  jim at nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


More information about the stats-dev mailing list