Re: Mapping a database completly into Memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Migowski <postgresql(at)Mig-O(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Mapping a database completly into Memory
Date: 2003-07-27 16:18:52
Message-ID: 9002.1059322732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Daniel Migowski <postgresql(at)Mig-O(dot)de> writes:
> I just wondered if there is a possibility to map my database running
> on a linux system completly into memory and to only use disk
> accesses for writes.

That happens for free, if you have enough RAM. The kernel will use
spare RAM to hold copies of every disk block it's ever read.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-07-28 04:14:11 Re: Mapping a database completly into Memory
Previous Message Rod Taylor 2003-07-27 14:25:40 Re: Query problem