Re: [HACKERS] v6.1 buffers and performance

Поиск
Список
Период
Сортировка
От Thomas G. Lockhart
Тема Re: [HACKERS] v6.1 buffers and performance
Дата
Msg-id de789f1b743976158e14023e26a20468
обсуждение
Ответ на [HACKERS] v6.1 buffers and performance  ("Thomas G. Lockhart" <Thomas.Lockhart@jpl.nasa.gov>)
Список pgsql-hackers
I upgraded my Linux box to have 96MB of memory, up from 32MB ($250, who
would have believed _that_ a few years ago).

There is a significant difference in Postgres performance, with the
regression tests taking ~5:15 to complete vs. ~6:20 before the upgrade
for a 17% speed improvement. There is little or no evidence for gross
degradation of performance with repeated runs of the regression test, as
I had reported earlier. So, the conclusion is that more memory is better
(duh!) and that as the buffer gets filled or fragmented smaller memory
machines start swapping.

            - Tom

------------------------------

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