Re: questions about PG update performance

From: Любен Каравелов <karavelov(at)mail(dot)bg>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: questions about PG update performance
Date: 2015-10-26 03:33:45
Message-ID: 1c7c7c43a56cebdfdbf7e1b21e5f229e.mailbg@mail.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


----- Цитат от Kisung Kim (kskim(at)bitnine(dot)co(dot)kr), на 26.10.2015 в 04:36 -----

> However, what I want to know is about the update performance difference
> between PG and Oracle if there any.
> The case I described is for exaggerating the difference between PG and
> Oracle.
>
> I want to explain for our clients that PG's update performance is
> comparable to Oracle's.
>

Oracle is also using MVCC but copies the old row in the rollback segment and
rewrites the values in-place. It is still 2 writes as in Postgres. The
difference is on roll-back and cleaning the row when it is not needed
anymore.

Regards,

--
Luben Karavelov

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ian Barwick 2015-10-26 04:07:45 Re: remaining open items
Previous Message Kisung Kim 2015-10-26 02:36:03 Re: questions about PG update performance