From owner-freebsd-performance@FreeBSD.ORG Tue Nov 23 02:15:34 2010 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C6DA11065674; Tue, 23 Nov 2010 02:15:34 +0000 (UTC) (envelope-from ivoras@gmail.com) Received: from mail-qw0-f54.google.com (mail-qw0-f54.google.com [209.85.216.54]) by mx1.freebsd.org (Postfix) with ESMTP id 6796B8FC0A; Tue, 23 Nov 2010 02:15:34 +0000 (UTC) Received: by qwg5 with SMTP id 5so531679qwg.13 for ; Mon, 22 Nov 2010 18:15:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received :in-reply-to:references:from:date:x-google-sender-auth:message-id :subject:to:cc:content-type; bh=Pt3d+RqVQv8vj3tMYBfXT6sHnlrcXWU5K2HhOnJmXN4=; b=Lfb1dmXN8b3+1KIhQlNIAU3zk2LmEbdSfL//+6gX0n5l+jZuC8puon2NjQ6GHp3qk9 9dr5XYZZmAuQ7Sd8VciVoQ1YwALGddizs/isoxW1xrv6F+MoBpE5MzASrBeEMBPmeKER HYaVWdVDz48bmxaV3MRHc6vIJFSiIDPy2rYAk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type; b=bAgP+74gPBl4J0wo5yBLV/+N9McnVhiDHQGImpvBKbJFNYSve0UMR2iG40K1egqp5L BEBKSiZpRhVjm9Wjv/eFLwSu1V9JT0lRzdNDG14V3KmgaUn70SpW+SHAGUgHauixZvep ViGUUcIKlWe4oUOfzutW19EgiAIvvb5T3j+Vs= Received: by 10.229.212.5 with SMTP id gq5mr5599744qcb.275.1290476759318; Mon, 22 Nov 2010 17:45:59 -0800 (PST) MIME-Version: 1.0 Sender: ivoras@gmail.com Received: by 10.229.231.143 with HTTP; Mon, 22 Nov 2010 17:45:19 -0800 (PST) In-Reply-To: <4CEB8AEF.7030202@freebsd.org> References: <4CEA9C46.8010507@freebsd.org> <4CEB8AEF.7030202@freebsd.org> From: Ivan Voras Date: Tue, 23 Nov 2010 02:45:19 +0100 X-Google-Sender-Auth: Fel-KL5ST49mnrAAqD_IhjtgAzc Message-ID: To: David Xu Content-Type: text/plain; charset=UTF-8 Cc: freebsd-performance@freebsd.org Subject: Re: PostgreSQL performance scaling X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Nov 2010 02:15:34 -0000 On 23 November 2010 10:35, David Xu wrote: > Ivan Voras wrote: >> and the overall behaviour is similar - the processes spend a lot of time >> in "sbwait" and "ksem" states. >> > Strange, the POSIX semaphore in head branch does not use ksem, it is > based on umtx, there is no limit on POSIX semaphore, the only limit > is process's address space which limits how many semaphores can be > used. *shrug*; I don't know how it could be wrong - this PostgreSQL was built from ports after I upgraded & booted 9-current. If it didn't use POSIX semaphores from HEAD, shared semaphores wouldn't have worked, right?