pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: me@alternize.com
To: Thomas Vatter <thomas.vatter@network-inventory.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: in memory views
Date: Wed, 10 May 2006 17:45:37 +0200
Message-ID: <0dbe01c67448$c9834b10$6402a8c0@iwing> (raw)
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>

> 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

view thread (19+ messages)  latest in thread

Message-ID: <0dbe01c67448$c9834b10$6402a8c0@iwing>
Permalink:  ../0dbe01c67448$c9834b10$6402a8c0@iwing/
Also on:    postgresql.org/message-id/0dbe01c67448$c9834b10$6402a8c0@iwing

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: me@alternize.com, thomas.vatter@network-inventory.de
  Subject: Re: in memory views
  In-Reply-To: <0dbe01c67448$c9834b10$6402a8c0@iwing>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox