Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Дата
Msg-id CAOR=d=3to4+6Ca9u-Sp8Rs4Yp=gMfa0AH+h6e56-pQqJ-tXqEg@mail.gmail.com
обсуждение исходный текст
Ответ на Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries  (Petr Praus <petr@praus.net>)
Ответы Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Список pgsql-performance
Дерево обсуждения 
Two possibilities:

caching.  make sure to run each query several times in a row.

zone reclaim mode. If this has gotten turned on turn it back off.

How to tell:

sysctl -n vm.zone_reclaim_mode

Output should be 0.  If it's not, then add this to /etc/sysctl.conf:

vm.zone_reclaim_mode=0

and run: sudo sysctl -p

and see if that helps.

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

Предыдущее
От: "Gunnar \"Nick\" Bluth"
Дата:
Сообщение: Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Следующее
От: Cesar Martin
Дата:
Сообщение: Re: High %SYS CPU usage