load the whole database into RAM

From: "filippo" <filippo2991(at)virgilio(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: load the whole database into RAM
Date: 2007-03-28 06:43:38
Message-ID: 1175064218.297786.149440@o5g2000hsb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2007-03-28 07:10:08 tweaks for write-intensive dbs ?
Previous Message Kevin Hunter 2007-03-28 06:02:23 Re: custom type for storing a HTML color