Do I need serializable for this query?
| От | William Garrison |
|---|---|
| Тема | Do I need serializable for this query? |
| Дата | |
| Msg-id | 461BDB32.8040904@mobydisk.com обсуждение исходный текст |
| Ответы |
Re: Do I need serializable for this query?
Re: Do I need serializable for this query? Re: Do I need serializable for this query? |
| Список | pgsql-general |
I have a table that keeps running totals. It is possible that this
would get called twice simultaneously for the same UserID. Do I need to
put this in a serializable transaction? Since this gets called often,
could it be a performance problem if I make it serializable?
CREATE FUNCTION UpdateTotals(IN UserID int,
IN AddToCount int,
IN AddToSize bigint)
RETURNS void AS $$
BEGIN
UPDATE
Totals
SET
TotalSize = TotalSize + $2,
TotalCount = TotalCount + $3
WHERE
UserID = $1;
END IF;
END
$$ LANGUAGE 'plpgsql' VOLATILE;
В списке pgsql-general по дате отправления: