X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A0B72D1D7FA for ; Mon, 2 Feb 2004 21:51:25 +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 08976-05 for ; Mon, 2 Feb 2004 17:51:16 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 663F1D1D59F for ; Mon, 2 Feb 2004 17:51:14 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i12LpEsv065200 for ; Mon, 2 Feb 2004 21:51:14 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i12LQP1d059911 for pgsql-performance@postgresql.org; Mon, 2 Feb 2004 21:26:25 GMT From: "Loeke" X-Newsgroups: comp.databases.postgresql.performance Subject: Re: views? Date: Mon, 2 Feb 2004 22:26:43 +0100 Organization: KULeuvenNet Lines: 16 Message-ID: <1075757185.980191@seven.kulnet.kuleuven.ac.be> References: <1075316194.466850@seven.kulnet.kuleuven.ac.be> <87k738ivl8.fsf@mailbox.samurai.com> <200402020948.21370.dev@archonet.com> X-Complaints-To: abuse@belnet.be X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Cache-Post-Path: seven.kulnet.kuleuven.ac.be!unknown@10-4-148-255.kotnet.org X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=BAYES_00, FORGED_HOTMAIL_RCVD2, NO_DNS_FOR_FROM, PRIORITY_NO_NAME X-Spam-Level: X-Archive-Number: 200402/51 X-Sequence-Number: 5575 > > This is called a "materialized view". PostgreSQL doesn't support them > > yet, but most people think it would be a Good Thing to have. > > There is a project on gborg (called "mview" iirc) though I don't know how far > it's got - I think it's still pretty new. tnx > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >