Re: go for a script! / ex: PostgreSQL vs. MySQL

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: go for a script! / ex: PostgreSQL vs. MySQL
Дата
Msg-id x7brslp2r2.fsf@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на go for a script! / ex: PostgreSQL vs. MySQL  ("Nick Barr" <nicky@chuckie.co.uk>)
Ответы Re: go for a script! / ex: PostgreSQL vs. MySQL
Список pgsql-performance
>>>>> "CK" == Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

>> If shmmax and shmmall are too small, then:
>> PostgreSQL requires some more shared memory to cache some tables, x
>> Mb, do you want to increase your OS kernel parameters?
>> Tweak shmmax and shmmall

CK> Note that this still requires a kernel recompile on FreeBSD :(

According to whom?  sysctl is your friend.  Some sysctl settings may
require reboot, but I don't think the SHM ones do.


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: David Griffiths
Дата:
Сообщение: Any issues with my tuning...
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Performance, vacuum and reclaiming space, fsm