Tweaking on an OpenBSD Machine
От
Alex Hochberger
Тема
Tweaking on an OpenBSD Machine
Дата
Msg-id
1F3774AB3688D4118B1300508BD9641528A818@CHINA
Список
I'm looking for help from someone that has run Postgres 7.1.1 on a highend OpenBSD machine. We have LOTS of RAM (1.5GB) and we want to get Postgres to use as MUCH as possible to speed things up. What kernel tweaks have you applied? What login.conf changes have you made? What have you done to the postgresql startup to make it use this RAM? Also, in addition to what changes that you've made, what are the defaults, what does it mean, etc? I need to get the system speedy (then I can use EXPLAIN for further query tweaks) quickly, and I need to know what changes I should make. Alex
В списке pgsql-general по дате отправления