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 x77k39p2p4.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>)
List pgsql-performance
>>>>> "JB" == Josh Berkus <josh@agliodbs.com> writes:

JB> Chris,
>> > 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
>>
>> Note that this still requires a kernel recompile on FreeBSD :(

JB> Not our fault, now is it?  This would mean that we wouldn't be
JB> able to script for FreeBSD.  Bug the FreeBSD developers.

"I read it on the net so it must be true" applies here.  You /can/ set
these values via sysctl calls.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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: Sean Chittenden
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Next
From: David Griffiths
Date:
Subject: Any issues with my tuning...