On Wed, May 8, 2013 at 8:45 AM, Tyson Maly <tvm...@yahoo.com> wrote: > If I have a simple table with an id as a primary key that is a serial column > and a column to keep track of a total_count for a particular id, what method > would provide the fastest way to increment the total_count in the shortest > amount of time and minimize any locking? > > id serial > total_count integer >
uh, update foo set total_count = total_count + 1 where id = x; ? merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
