Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AE5329FB3AD for ; Tue, 24 Oct 2006 13:03:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 83211-09 for ; Tue, 24 Oct 2006 13:03:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id F2A9E9FB3AE for ; Tue, 24 Oct 2006 13:03:12 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Tue, 24 Oct 2006 16:03:09 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 24 Oct 2006 11:03:09 -0500 Subject: Re: materialized view From: Scott Marlowe To: rajesh boppana Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1161705788.8706.174.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 24 Oct 2006 11:03:09 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.996 tagged_above=0 required=5 tests=AWL, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL, UNPARSEABLE_RELAY X-Spam-Level: * X-Archive-Number: 200610/151 X-Sequence-Number: 23454 On Tue, 2006-10-24 at 08:26, rajesh boppana wrote: > we know that presently postgresql wiln't support it. we want to > implement it.but i don,t know which source file we have to change.so > please let me know the details of source functions which need to be > changed to achieve materialized views. > thanking the community Like everything about PostgreSQL, while the core software may not have the functionality built in, it has enough extensibility to let you do it yourself. For a very informative tutorial on mat views and how to do them, check out this page: http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html