questions about PG update performance - Mailing list pgsql-hackers

From Kisung Kim
Subject questions about PG update performance
Date
Msg-id CABF0Rr3k=s5uDsxh8d3AaJxDq4Z4Zycmgf6pdhevTE=WjdCTAA@mail.gmail.com
Whole thread Raw
Responses Re: questions about PG update performance
List pgsql-hackers
Dear,

I have a question about update performance of PG.

Because of the internal implementation of MVCC in PG
the update of a row is actually a insertion of a new version row.
So if the size of a row is huge, then it incurs some overhead compare to in-place update strategy.

Let's assume that a table has 200 columns, 
and a user updates one of the columns of one row in the table.
Then PG will rewrite the whole contents of the updated row
including the updated columns and not-updated columns.

I'm not sure about the implementation of Oracle's update.
But if the Oracle can overwrite only the updated column,
the performance difference between Oracle and PG in that case may be significant.

I researched about this issues in mailing list and google.
But I've not found anything related to this issues.

Thank you.

Kisung Kim.
 

                                                                                                                                                       


(C)Bitnine, Kisung Kim, Ph.D
https://sites.google.com/site/kisungresearch/
E-mail : kskim@bitnine.co.kr
Office phone : 070-4800-3321
Mobile phone : 010-7136-0834
Fax : 02-568-1332

pgsql-hackers by date:

Previous
From: Kouhei Kaigai
Date:
Subject: Re: [DESIGN] ParallelAppend
Next
From: Michael Paquier
Date:
Subject: Re: questions about PG update performance