Postgres Pro
Downloads
Home   >   mailing lists

Re: Mapping a database completly into Memory - Mailing list pgsql-performance

From Tom Lane
Subject Re: Mapping a database completly into Memory
Date
Msg-id 9002.1059322732@sss.pgh.pa.us
Whole thread Raw
In response to Mapping a database completly into Memory  (Daniel Migowski <postgresql@Mig-O.de>)
Responses Re: Mapping a database completly into Memory
List pgsql-performance
Tree view 
Daniel Migowski <postgresql@Mig-O.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

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Query problem
Next
From: Josh Berkus
Date:
Subject: Re: Mapping a database completly into Memory