Skip site navigation (1) Skip section navigation (2)

Materialized View Summary

From: "Jonathan M(dot) Gardner" <jgardner(at)jonathangardner(dot)net>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org,pgsql-performance(at)postgresql(dot)org
Subject: Materialized View Summary
Date: 2004-02-24 16:11:03
Message-ID: 200402240811.13013.jgardner@jonathangardner.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performancepgsql-sqlpgsql-www
-----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-----

Responses

pgsql-performance by date

Next:From: Nick BarrDate: 2004-02-24 16:44:57
Subject: Re: Slow join using network address function
Previous:From: Tom LaneDate: 2004-02-24 15:23:22
Subject: Re: Slow join using network address function

pgsql-www by date

Next:From: Richard HuxtonDate: 2004-02-24 17:11:20
Subject: Re: [SQL] Materialized View Summary
Previous:From: L J BayukDate: 2004-02-24 02:47:09
Subject: Re: tcl on gborg, pgtclsh

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-02-24 16:16:30
Subject: Re: dollar quoting nits
Previous:From: Shridhar DaithankarDate: 2004-02-24 15:57:23
Subject: Re: Sparc optimizations

pgsql-sql by date

Next:From: Richard HuxtonDate: 2004-02-24 17:11:20
Subject: Re: [SQL] Materialized View Summary
Previous:From: Sumita Biswas (sbiswas)Date: 2004-02-24 15:35:07
Subject: Execute Query in Postgres Function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group