X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BF6DA53205 for ; Mon, 28 Mar 2005 22:44:20 +0100 (BST) 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 92232-02 for ; Mon, 28 Mar 2005 21:44:19 +0000 (GMT) Received: from web1-glo.biscit.net (web1-glo.biscit.net [82.195.96.53]) by svr1.postgresql.org (Postfix) with ESMTP id 58C7452D42 for ; Mon, 28 Mar 2005 22:44:18 +0100 (BST) Received: from bolek.coachhouse (host62-6-128-215.webport.bt.net [62.6.128.215]) by web1-glo.biscit.net (8.10.2/8.10.2) with ESMTP id j2SLiGA07892 for ; Mon, 28 Mar 2005 22:44:16 +0100 Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1DG20s-0001b0-00 ; Mon, 28 Mar 2005 22:43:10 +0100 Message-ID: <42487A6D.6020506@numerixtechnology.de> Date: Mon, 28 Mar 2005 22:43:09 +0100 From: T E Schmitz Reply-To: mailreg@numerixtechnology.de User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: cost of CREATE VIEW ... AS SELECT DISTINCT Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.08 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/369 X-Sequence-Number: 20848 Hello, How expensive would it be to maintain the following VIEW: CREATE VIEW origin AS SELECT DISTINCT origin FROM transaktion if there is in index on transaktion.origin; the table transaktion has thousands of records and there are only a few distinct origin? -- Regards/Gruß, Tarlika Elisabeth Schmitz