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 E70249FA2FA for ; Wed, 10 May 2006 12:45:54 -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 18050-10 for ; Wed, 10 May 2006 12:45:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.refusion.com (mail.refusion.com [213.144.155.20]) by postgresql.org (Postfix) with ESMTP id 9D55B9FA1B0 for ; Wed, 10 May 2006 12:45:49 -0300 (ADT) Received: from iwing by mail.refusion.com (Cipher TLSv1:RC4-MD5:128) (MDaemon PRO v9.0.1) with ESMTP id md50000666595.msg for ; Wed, 10 May 2006 17:45:47 +0200 Message-ID: <0dbe01c67448$c9834b10$6402a8c0@iwing> From: To: "Thomas Vatter" Cc: References: <4461AFFF.7060200@network-inventory.de> <4461B3DE.6030700@wildenhain.de> <4461B899.4030502@network-inventory.de> <1147273917.9755.22.camel@state.g2switchworks.com> <4462098D.2010500@network-inventory.de> Subject: Re: in memory views Date: Wed, 10 May 2006 17:45:37 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.3790.2663 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2663 X-Authenticated-Sender: info@alternize.com X-Spam-Processed: mail.refusion.com, Wed, 10 May 2006 17:45:47 +0200 (not processed: message from trusted or authenticated source) X-MDRemoteIP: 80.238.206.247 X-Return-Path: me@alternize.com X-MDaemon-Deliver-To: pgsql-performance@postgresql.org X-ClamAV: Pass X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/262 X-Sequence-Number: 19049 > is there a possibility for creating views or temp tables in memory to > avoid disk io when user makes select operations? you might also want to look into "materialized views": http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html http://www.varlena.com/varlena/GeneralBits/64.php this helped us alot when we had slow queries involving many tables. cheers, thomas