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

From Christopher Kings-Lynne
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 3F8B54C1.5090206@familyhealth.com.au
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-performance
>
> Yes, indeed, sysctl can tweak these values fairly adequately.
>
> Now, numbers of semaphors are not as readily tweaked; I wound up
> limited, the other day, when I tried setting values for...
>
>   kern.ipc.semmns
>   kern.ipc.semmni

Same.  Maybe that was the option I was thinking was read-only:

houston# sysctl kern.ipc.semmns
kern.ipc.semmns: 60
houston# sysctl -w kern.ipc.semmns=70
sysctl: oid 'kern.ipc.semmns' is read only
houston# sysctl kern.ipc.semmni
kern.ipc.semmni: 10
houston# sysctl -w kern.ipc.semmni=30
sysctl: oid 'kern.ipc.semmni' is read only

I like how they use oids :P

Chris



pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Next
From: Seth Ladd
Date:
Subject: Re: ways to force index use?