Re: load the whole database into RAM - Mailing list pgsql-general

From Merlin Moncure
Subject Re: load the whole database into RAM
Date
Msg-id b42b73150703291142g472a42e7r9b1e48189dbe7b9c@mail.gmail.com
Whole thread Raw
In response to load the whole database into RAM  ("filippo" <filippo2991@virgilio.it>)
List pgsql-general
On 27 Mar 2007 23:43:38 -0700, filippo <filippo2991@virgilio.it> wrote:
> I use pgsql to store data for my program (hotel manager). The
> filesystem reports that the size on disk of database is not so bing
> (~100MB  ~20MB actual data). I want to tune the engine to fit the
> database as much as possible in RAM, say: postgres, please, use 512MB
> (1GB) of my RAM just for your needs and     load everithing on it. Is
> it possible and, of course, effective?
>
> Just taking a look to some tuning document I didn't find a direct
> answer (I'm not a smart guy)

All modern operating systems do this without any extra effort on your
part...all you can really do is get in the way.

Just make sure there is enough ram in the box and let postgresql do
its thing.  I think in your case the only thing you should be
considering is to turn fsync on (safe, slow, default) or off (unsafe,
fast).

merlin

pgsql-general by date:

Previous
From: "Nik"
Date:
Subject: pg_dump is stuck
Next
From: Martijn van Oosterhout
Date:
Subject: Re: load the whole database into RAM