Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 61E7E1337BCD for ; Thu, 16 Sep 2010 20:13:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 28836-10 for ; Thu, 16 Sep 2010 23:13:03 +0000 (UTC) X-Greylist: delayed 00:06:28.158735 by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id B09921337990 for ; Thu, 16 Sep 2010 20:13:03 -0300 (ADT) Received: by vws3 with SMTP id 3so1385072vws.19 for ; Thu, 16 Sep 2010 16:13:03 -0700 (PDT) Received: by 10.220.125.23 with SMTP id w23mr2120219vcr.136.1284678395178; Thu, 16 Sep 2010 16:06:35 -0700 (PDT) Received: from Craig-Jamess-MacBook-Pro.local (wsip-70-167-124-126.sd.sd.cox.net [70.167.124.126]) by mx.google.com with ESMTPS id m30sm2186319vbr.19.2010.09.16.16.06.33 (version=SSLv3 cipher=RC4-MD5); Thu, 16 Sep 2010 16:06:34 -0700 (PDT) Message-ID: <4C92A2F8.2050209@emolecules.com> Date: Thu, 16 Sep 2010 16:06:32 -0700 From: Craig James User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.9) Gecko/20100825 Thunderbird/3.1.3 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: incrementing updates and locks References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/92 X-Sequence-Number: 35636 On 9/16/10 3:54 PM, Aras Angelo wrote: > Hello All > > I have a column in my table which is incrementally updated. Try to give us more details... Does the column need have contiguous values or are "gaps" ok? That is, does it have to be 1,2,3,4,...,N-1,N or is it ok to have something like 1,3,4,7,...,M (where M>N) for N rows? Is the value updated every time the row is changed, or is it set once only? If gaps are OK, then a sequence is a simple answer. Craig