От: Kevin Grittner
Тема: Re: Memory Allocation
Дата: ,
Msg-id: 492D82BB.EE98.0025.0@wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Memory Allocation  (Scott Carey)
Ответы: Re: Memory Allocation  (Scott Carey)
Список: pgsql-performance

Скрыть дерево обсуждения

Memory Allocation  ("Ryan Hansen", )
 Re: Memory Allocation  (Alan Hodgson, )
 Re: Memory Allocation  (Carlos Moreno, )
 Re: Memory Allocation  (Tom Lane, )
 Re: Memory Allocation  (Scott Carey, )
  Re: Memory Allocation  ("Kevin Grittner", )
   Re: Memory Allocation  (Scott Carey, )
    Re: Memory Allocation  ("Kevin Grittner", )

>>> Scott Carey <> wrote:
> Set swappiness to 0 or 1.

We recently converted all 72 remote county databases from 8.2.5 to
8.3.4.  In preparation we ran a test conversion of a large county over
and over with different settings to see what got us the best
performance.  Setting swappiness below the default degraded
performance for us in those tests for identical data, same hardware,
no other changes.

Our best guess is that code which really wasn't getting called got
swapped out leaving more space in the OS cache, but that's just a
guess.  Of course, I'm sure people would not be recommending it if
they hadn't done their own benchmarks to confirm that this setting
actually improved things in their environments, so the lesson here is
to test for your environment when possible.


В списке pgsql-performance по дате сообщения:

От: Kevin Kempter
Сообщение: performance tuning queries
Сообщение: Re: performance tuning queries