Re: [GENERAL] question on most efficient way to increment a column

2013-05-09 Thread Tyson Maly
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

[GENERAL] question on most efficient way to increment a column

2013-05-08 Thread Tyson Maly
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