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

From Josh Berkus
Subject Re: Mapping a database completly into Memory
Date
Msg-id 200307272114.11579.josh@agliodbs.com
Whole thread Raw
In response to Re: Mapping a database completly into Memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Mapping a database completly into Memory
List pgsql-performance
Daniel,

> > 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.

Also, don't forget to raise your effective_cache_size so that PostgreSQL
*knows* that you have lots of RAM.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Mapping a database completly into Memory
Next
From: Franco Bruno Borghesi
Date:
Subject: Re: Mapping a database completly into Memory