select/update performance?

Поиск
Список
Период
Сортировка
От Bjørn T Johansen
Тема select/update performance?
Дата
Msg-id 1068024291.12114.16.camel@pgsqlsrv.havleik.no
обсуждение исходный текст
Ответы Re: select/update performance?
Список pgsql-general
I need to maintain a manually counter for an id-field, but I can do this
two ways. Either make a counter table (which means one select and one
update) or just selecting the largest id from existing table and
increment by one (just one select + one table lock). Which one is
fastest?


Regards,

BTJ


В списке pgsql-general по дате отправления: