question on most efficient way to increment a column - Mailing list pgsql-general

From Tyson Maly
Subject question on most efficient way to increment a column
Date
Msg-id 1368020713.12089.YahooMailNeo@web120504.mail.ne1.yahoo.com
Whole thread Raw
Responses Re: question on most efficient way to increment a column
Re: question on most efficient way to increment a column
Re: question on most efficient way to increment a column
List pgsql-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 integer

Best regards,

Ty

pgsql-general by date:

Previous
From: Seref Arikan
Date:
Subject: Does it make sense to break a large query into separate functions?
Next
From: Merlin Moncure
Date:
Subject: Re: question on most efficient way to increment a column