X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B4BBE52B04 for ; Thu, 4 Aug 2005 05:52:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68535-09 for ; Thu, 4 Aug 2005 08:52:35 +0000 (GMT) Received: from epbsa003.epam.com (epbsa003.epam.com [195.56.119.212]) by svr1.postgresql.org (Postfix) with ESMTP id D5A4552901 for ; Thu, 4 Aug 2005 05:52:33 -0300 (ADT) Received: from [127.0.0.1] ([10.0.11.147]) by epbsa003.epam.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 4 Aug 2005 10:52:33 +0200 Message-ID: <42F1D739.2090309@forgeahead.hu> Date: Thu, 04 Aug 2005 10:52:09 +0200 From: Laszlo Hornyak User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Indexed views. References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 04 Aug 2005 08:52:33.0899 (UTC) FILETIME=[DAF4CBB0:01C598D1] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200508/34 X-Sequence-Number: 13781 prasanna s wrote: > Does postgres support indexed views/materialised views that some of > the other databases support? > > Thanks > Prasanna S Hi! It is not supported, but perhaps this will help you: http://www.varlena.com/varlena/GeneralBits/Tidbits/matviews.html