Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group