Re: Mapping a database completly into Memory

Список
Период
Сортировка
От Franco Bruno Borghesi
Тема Re: Mapping a database completly into Memory
Дата
Msg-id 1059401815.749.7.camel@taz.oficina
обсуждение исходный текст
Ответ на Re: Mapping a database completly into Memory  (Josh Berkus)
Ответы Re: Mapping a database completly into Memory  (Tom Lane)
Список pgsql-performance
Дерево обсуждения
Mapping a database completly into Memory  (Daniel Migowski, )
 Re: Mapping a database completly into Memory  (Tom Lane, )
  Re: Mapping a database completly into Memory  (Josh Berkus, )
   Re: Mapping a database completly into Memory  (Franco Bruno Borghesi, )
    Re: Mapping a database completly into Memory  (Tom Lane, )
     Re: Mapping a database completly into Memory  (Andrew Sullivan, )
 Re: Mapping a database completly into Memory  (Josh Berkus, )
  Re: Mapping a database completly into Memory  (Franco Bruno Borghesi, )
  Re: Mapping a database completly into Memory  (Tom Lane, )
 Re: Mapping a database completly into Memory  (Vivek Khera, )
  Re: Mapping a database completly into Memory  (Bruce Momjian, )
   Re: Mapping a database completly into Memory  (Vivek Khera, )
  Re: Mapping a database completly into Memory  (Bruce Momjian, )
wouldn't also increasing shared_buffers to 64 or 128 MB be a good performance improvement? This way, pages belonging to heavily used indexes would be already cached by the database itself.

Please, correct me if I'm wrong.

On Mon, 2003-07-28 at 01:14, Josh Berkus wrote:
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.
Вложения

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

Предыдущее
От: Shankar K
Дата:
Сообщение: Rebuild indexes
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Rebuild indexes