In some cases, it would be 2-10 times a second per id.
From: Scott Marlowe scott.marl...@gmail.com
To: Tyson Maly tvm...@yahoo.com
Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org
Sent: Wednesday, May 8, 2013 10:10 PM
Subject: Re: [GENERAL
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