Re: Mapping a database completly into Memory

From: Josh Berkus <josh(at)agliodbs(dot)com>
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-28 04:14:11
Message-ID: 200307272114.11579.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Franco Bruno Borghesi 2003-07-28 14:16:55 Re: Mapping a database completly into Memory
Previous Message Tom Lane 2003-07-27 16:18:52 Re: Mapping a database completly into Memory