Re: Mapping a database completly into Memory

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Mapping a database completly into Memory
Дата
Msg-id 200307272114.11579.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Mapping a database completly into Memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Mapping a database completly into Memory  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
Список pgsql-performance
Daniel,

> > 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.
>
> That happens for free, if you have enough RAM.  The kernel will use
> spare RAM to hold copies of every disk block it's ever read.

Also, don't forget to raise your effective_cache_size so that PostgreSQL
*knows* that you have lots of RAM.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Mapping a database completly into Memory
Следующее
От: Franco Bruno Borghesi
Дата:
Сообщение: Re: Mapping a database completly into Memory