Irreversible performance drop after increasing shared mem

Поиск
Список
Период
Сортировка
От jake@omnimode.com (jake johnson)
Тема Irreversible performance drop after increasing shared mem
Дата
Msg-id 8897a0de.0402241040.1db32e2c@posting.google.com
обсуждение исходный текст
Ответы Re: Irreversible performance drop after increasing shared mem  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Дерево обсуждения 
I'm running PG 7.4.1 on FreeBSD 5.2.1_RC1 and experienced a general
40% drop in performance after increasing Shared mem buffers to 2000
(from the 1000 default setting) and the Sort Mem to 1024 from 16.
After changing the .conf file back to the original values, performance
didn't change back.  Only after dropping the database and reloading
from dump, did performance return.  Is this unusual behavior in
anyone's opinion?  (Note that I didn't forget to do a pg_ctl reload to
have postmaster re-read the .conf file.)

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

Предыдущее
От: "Greg Patnude"
Дата:
Сообщение: Re: Moving from MySQL to PGSQL....some questions
Следующее
От: jack_turer@yahoo.com (jack turer)
Дата:
Сообщение: Re: pg_dump and pg_dumpall fail when trying to backup database