Does frequent update of a row affects performance

From: Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Does frequent update of a row affects performance
Date: 2016-04-26 12:55:16
Message-ID: 562917870.1031824.1461675316534.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Aguayo Garcia-Rada 2016-04-26 13:10:30 Re: Does frequent update of a row affects performance
Previous Message Wetzel, Juergen (Juergen) 2016-04-26 12:45:21 Re: Intemittendly get "server process (PID 5884) exited with exit code 3"