Tyson Maly 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
UPDATE tablename SET total_count=total_count+1 WHERE id=42; Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general