Mapping Database completly into memory

From: Daniel Migowski <Mig-O(at)artis(dot)uni-oldenburg(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Mapping Database completly into memory
Date: 2003-07-27 08:40:09
Message-ID: 1662072945.20030727104009@artis.uni-oldenburg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hallo pgsql-performance,

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.

I got a nice machine around with 2 gigs of ram, and my database at
the moment uses about 30MB on the disks.

Or does Postgresql do this automtatically, with some cache adjusting
parameters, and after doing a select * from <everything> on my
database?

Thank you and ciao,
Mig-O

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Migowski 2003-07-27 08:49:01 Mapping a database completly into Memory
Previous Message Balazs Wellisch 2003-07-26 21:08:34 Re: Tuning PostgreSQL