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

From filippo
Subject load the whole database into RAM
Date
Msg-id 1175064218.297786.149440@o5g2000hsb.googlegroups.com
Whole thread Raw
Responses Re: load the whole database into RAM  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: load the whole database into RAM  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
hello,

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)

Thanks,

Filippo


pgsql-general by date:

Previous
From: "Angva"
Date:
Subject: Re: multi-row check constraints?
Next
From: "Ian Johnson"
Date:
Subject: Re: redhat debug info