X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5E1229FA425 for ; Wed, 10 May 2006 06:36:12 -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 71088-04 for ; Wed, 10 May 2006 06:35:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id B0C4A9F96B6 for ; Wed, 10 May 2006 06:35:59 -0300 (ADT) Received: from [10.100.1.50] (074-016-066-080.eggenet.de [80.66.16.74]) by service-web.de (Postfix) with ESMTP id A6B2320002F; Wed, 10 May 2006 11:35:57 +0200 (CEST) Message-ID: <4461B3DE.6030700@wildenhain.de> Date: Wed, 10 May 2006 11:35:26 +0200 From: Tino Wildenhain User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050929) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Thomas Vatter Cc: pgsql-performance@postgresql.org Subject: Re: in memory views References: <4461AFFF.7060200@network-inventory.de> In-Reply-To: <4461AFFF.7060200@network-inventory.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/232 X-Sequence-Number: 19019 Thomas Vatter schrieb: > is there a possibility for creating views or temp tables in memory to > avoid disk io when user makes select operations? No need. The data will be available in OS and database caches if they are really required often. If not, tune up the caches and do a regular "pre select". Regards Tino