Mapping a database completly into Memory

Поиск
Список
Период
Сортировка
От Daniel Migowski
Тема Mapping a database completly into Memory
Дата
Msg-id 97842368.20030727104901@artis.uni-oldenburg.de
обсуждение исходный текст
Ответы Re: Mapping a database completly into Memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Daniel Migowski
Дата:
Сообщение: Mapping Database completly into memory
Следующее
От: pginfo
Дата:
Сообщение: Query problem