X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D4173DAEB9 for ; Wed, 26 Oct 2005 12:25:02 -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 57520-08 for ; Wed, 26 Oct 2005 15:24:59 +0000 (GMT) Received: from cicero1.cybercity.dk (cicero1.cybercity.dk [212.242.40.4]) by svr1.postgresql.org (Postfix) with ESMTP id 80C8DDAEB6 for ; Wed, 26 Oct 2005 12:24:59 -0300 (ADT) Received: from [192.168.0.79] (0x3e42eeca.adsl.cybercity.dk [62.66.238.202]) by cicero1.cybercity.dk (Postfix) with ESMTP id 8FB7A7E3C89 for ; Wed, 26 Oct 2005 17:24:56 +0200 (CEST) Message-ID: <435FA002.4060509@krap.dk> Date: Wed, 26 Oct 2005 17:25:54 +0200 From: Svenne Krap User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Perfomance of views Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/387 X-Sequence-Number: 15155 Hi there. I am currently building a system, where it would be nice to use multiple levels of views upon each other (it is a staticstics system, where traceability is important). Is there any significant performance reduction in say 10 levels of views instead of one giant, nested sql-statement ? I especially think exection planner-wise. The data mainly comes from one small to medium sized tabel (< 5 million rows) and a handfull small (< 5000 rows) support tables. The hardware will be okay for the job, but nothing really fancy (specs are Xeon, 2G of memory, 6 SCSI-disks in a RAID1+0) . The base will be version 8.1 provided that it gets out of beta around end-of-year. Svenne