Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id ACBA9634410 for ; Tue, 2 Feb 2010 14:41:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 57510-05-3 for ; Tue, 2 Feb 2010 18:40:55 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f189.google.com (mail-yw0-f189.google.com [209.85.211.189]) by mail.postgresql.org (Postfix) with ESMTP id B21D7641A73 for ; Tue, 2 Feb 2010 13:32:58 -0400 (AST) Received: by ywh27 with SMTP id 27so297719ywh.1 for ; Tue, 02 Feb 2010 09:32:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=etpnaZQ29FiA3/33nYcGheCEDYXX9Zq2WGwRmgjdQ5o=; b=JciKXO5W34HkkFNBTCgxhKx1LKcfehlPuGri5kAF80l2/2bTmV3Ops8dZVjGm3bJTo S2Qc5p1hAjJ2Z0b85/tvxyFCu/0DrJpn7PLMvnwlGmjT7D+EGdXQ3en9gUWN1iSEcbA0 AmNk5JOXSQQl7EAIc10nCrkm/AErdtz213204= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=dqr64IBJ7ycrtM79D5UgKwYVxu6fX4ezfFqqYCZ5nhl4qjraQ1fhV6iHiUPxJwm9Qc wss6V5/nR9u+pLndK99+j8eUgCGVsoEaHAaIqMFy5lCfjZ0dcxcJFs4dOUYID6XeQlqL U74OgIin0tYmCs7Y/jznC1fj3MD21vO2TQklY= MIME-Version: 1.0 Received: by 10.101.51.7 with SMTP id d7mr7876655ank.201.1265125432144; Tue, 02 Feb 2010 07:43:52 -0800 (PST) In-Reply-To: <20100202071154.241D94B1C71@mail175-236.sinamail.sina.com.cn> References: <20100202071154.241D94B1C71@mail175-236.sinamail.sina.com.cn> Date: Tue, 2 Feb 2010 07:43:52 -0800 Message-ID: <396486431002020743x739a5f80od11dbb83c6e1c399@mail.gmail.com> Subject: =?UTF-8?Q?Re=3A_=E5=9B=9E=E5=A4=8D=EF=BC=9ARe=3A_=5BPERFORM=5D_the_jokes_for_pg_concurre?= =?UTF-8?Q?ncy_write_performance?= From: Richard Broersma To: wyx6fox@sina.com, pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.385 tagged_above=-10 required=5 tests=AWL=0.214, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/13 X-Sequence-Number: 37434 2010/2/1 : > yet, this code is just for fun , why ? because i found this code in one > article:PostgreSQL Concurrency Issues . I'm not familiar with the "code" that you are referring to. Do you have a hyper-link to it? > Tom Lane > Red Hat Database Group > Red Hat, Inc. Also, I'm not sure why you mentioned Tom's name here. Does he have anything to do with the "code" that you've previously mentioned? > so many design should be better than this , But now we should talk about > this ,I just want talk about confick update on concurrency write > transaction. Regarding the update conflict, what aspect of it did you want to talk about? Also, so that others (having much more experience that I do) can participate in this discussion please reply-all to the email. This will ensure that the pgsql-performance@postgresql.org mailing is included. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug