Mapping Database completly into memory

Поиск
Список
Период
Сортировка
От Daniel Migowski
Тема Mapping Database completly into memory
Дата
Msg-id 1662072945.20030727104009@artis.uni-oldenburg.de
обсуждение исходный текст
Ответы Re: Mapping Database completly into memory  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: "Balazs Wellisch"
Дата:
Сообщение: Re: Tuning PostgreSQL
Следующее
От: Daniel Migowski
Дата:
Сообщение: Mapping a database completly into Memory