load the whole database into RAM

Поиск
Список
Период
Сортировка
От filippo
Тема load the whole database into RAM
Дата
Msg-id 1175064218.297786.149440@o5g2000hsb.googlegroups.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Angva"
Дата:
Сообщение: Re: multi-row check constraints?
Следующее
От: "Ian Johnson"
Дата:
Сообщение: Re: redhat debug info