Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 829E49FBB8D for ; Tue, 27 Feb 2007 14:55:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 14370-04 for ; Tue, 27 Feb 2007 14:54:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0B3729FBB5D for ; Tue, 27 Feb 2007 14:54:46 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l1RIsUcb029065; Tue, 27 Feb 2007 13:54:30 -0500 (EST) To: "Jim C. Nasby" cc: pgsql-performance@postgresql.org Subject: Re: [kris@obsecurity.org: Anyone interested in improving postgresql scaling?] In-reply-to: <20070227183219.GG29041@decibel.org> References: <20070227183219.GG29041@decibel.org> Comments: In-reply-to "Jim C. Nasby" message dated "Tue, 27 Feb 2007 12:32:20 -0600" Date: Tue, 27 Feb 2007 13:54:30 -0500 Message-ID: <29064.1172602470@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.059 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/330 X-Sequence-Number: 23384 "Jim C. Nasby" writes: > Ok, looks like the FreeBSD community is interested in PostgreSQL > performance, or at least enough to investigate it. I think this guy is barking up the wrong tree though, because we don't ever have multiple processes sleeping on the same sema. Not that there's anything wrong with his proposal, but it doesn't affect Postgres. regards, tom lane