Re: Performance tuning for linux, 1GB RAM, dual CPU?

Поиск
Список
Период
Сортировка
От snpe
Тема Re: Performance tuning for linux, 1GB RAM, dual CPU?
Дата
Msg-id 01071219182300.01463@spnew
обсуждение исходный текст
Ответ на Re: Performance tuning for linux, 1GB RAM, dual CPU?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> Another factor, not under our control, is that if the shared memory
> region gets too large the kernel may decide to swap out portions of
> it that haven't been touched lately.  This of course is completely
> counterproductive, especially if what gets swapped is a dirty buffer,
> which'll eventually have to be read back in and then written to where
> it should have gone.  This is the main factor behind my thought that you
> don't want to skimp on kernel disk buffer space --- any memory pressure
> in the system should be resolvable by dropping kernel disk buffers, not
> by starting to swap shmem or user processes.
>

You can lock shared memory for this problem ?


regards
haris peco

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: Pg7.2 (was: vacuum and 24/7 uptime)
Следующее
От: "Ben-Nes Michael"
Дата:
Сообщение: Re: locale per db / table / column