Re: in memory views

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Thomas Vatter <thomas(dot)vatter(at)network-inventory(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: in memory views
Date: 2006-05-10 09:35:26
Message-ID: 4461B3DE.6030700@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Vatter 2006-05-10 09:55:37 Re: in memory views
Previous Message Thomas Vatter 2006-05-10 09:18:55 in memory views