X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E46A99DC80F for ; Tue, 7 Feb 2006 18:21:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63535-06 for ; Tue, 7 Feb 2006 18:21:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtpauth07.mail.atl.earthlink.net (smtpauth07.mail.atl.earthlink.net [209.86.89.67]) by postgresql.org (Postfix) with ESMTP id 258829DC82A for ; Tue, 7 Feb 2006 18:20:59 -0400 (AST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=bW6hdPK86s79si7hAaO6Sf44HzhbPxbFF9XnC3lJq+YcRuiI/aIc8wLU3/jV6Zm+; h=Received:Message-Id:X-Mailer:Date:To:From:Subject:In-Reply-To:References:Mime-Version:Content-Type:X-ELNK-Trace:X-Originating-IP; Received: from [71.243.30.247] (helo=ron-6d52adff2a6.earthlink.net) by smtpauth07.mail.atl.earthlink.net with asmtp (Exim 4.34) id 1F6bCl-0001Cw-Bv; Tue, 07 Feb 2006 17:21:00 -0500 Message-Id: <7.0.1.0.2.20060207171933.037eee98@earthlink.net> X-Mailer: QUALCOMM Windows Eudora Version 7.0.1.0 Date: Tue, 07 Feb 2006 17:22:22 -0500 To: Simon Riggs ,pgsql-performance@postgresql.org From: Ron Subject: Re: partitioning and locking problems In-Reply-To: <1139350142.1258.174.camel@localhost.localdomain> References: <2BCEB9A37A4D354AA276774EE13FB8C2BCC2A6@mailserver.sandvine.com> <1139350142.1258.174.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-ELNK-Trace: acd68a6551193be5d780f4a490ca69563f9fea00a6dd62bcaed4711ccea23c093c94ea04d64c1214350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 71.243.30.247 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200602/58 X-Sequence-Number: 17044 At 05:09 PM 2/7/2006, Simon Riggs wrote: >I'd be disinclined to using the locking system as a scheduling tool. I Agree with Simon. Using the locking system for scheduling feels like a form of Programming by Side Effect. Ron