question on most efficient way to increment a column

Поиск
Список
Период
Сортировка
От Tyson Maly
Тема question on most efficient way to increment a column
Дата
Msg-id 1368020713.12089.YahooMailNeo@web120504.mail.ne1.yahoo.com
обсуждение исходный текст
Ответы Re: question on most efficient way to increment a column  (Merlin Moncure <mmoncure@gmail.com>)
Re: question on most efficient way to increment a column  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: question on most efficient way to increment a column  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Seref Arikan
Дата:
Сообщение: Does it make sense to break a large query into separate functions?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: question on most efficient way to increment a column