Does frequent update of a row affects performance

Поиск
Список
Период
Сортировка
От Rakesh Kumar
Тема Does frequent update of a row affects performance
Дата
Msg-id 562917870.1031824.1461675316534.JavaMail.yahoo@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Does frequent update of a row affects performance  (Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>)
Re: Does frequent update of a row affects performance  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Pardon me if this has been discussed before.

I believe that PG back-end does not version index rows the way it does the data rows. Assume that the app updates a row frequently (several times in a second). For each update, PG will create a new version.  However I believe the primary key index pointing to that row will point to only the first row and the back end has to work its way traversing the list until it finds the appropriate row matching the xmin/xmax.  Does frequent vaccum take care of this by removing the dead rows and hence reducing the commute.


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

Предыдущее
От: "Wetzel, Juergen (Juergen)"
Дата:
Сообщение: Re: Intemittendly get "server process (PID 5884) exited with exit code 3"
Следующее
От: Alvaro Aguayo Garcia-Rada
Дата:
Сообщение: Re: Does frequent update of a row affects performance