Re: go for a script! / ex: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Vivek Khera
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id x7brslp2r2.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to go for a script! / ex: PostgreSQL vs. MySQL  ("Nick Barr" <nicky@chuckie.co.uk>)
Responses Re: go for a script! / ex: PostgreSQL vs. MySQL  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: David Griffiths
Date:
Subject: Any issues with my tuning...
Next
From: Vivek Khera
Date:
Subject: Re: Performance, vacuum and reclaiming space, fsm