Re: update non-indexed value is slow if some non-related index/fk are enabled

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Philippe Doussot <philippe(dot)doussot(at)up(dot)coop>
Cc: rob stone <floriparob(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: update non-indexed value is slow if some non-related index/fk are enabled
Date: 2021-09-06 14:13:07
Message-ID: CAKFQuwZXBg4C6CH7nJWO-C2qvjtkJq=MgvHN8_SYWydX7SNkng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday, September 6, 2021, Philippe Doussot <philippe(dot)doussot(at)up(dot)coop>
wrote:

> I whas hopping the same optimisation as you: Write in place.
>
>
>
How exactly would you expect “update-in-place” to work given the nature of
MVCC?

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Westermann (DWE) 2021-09-06 14:18:16 Behavior change in PostgreSQL 14Beta3 or bug?
Previous Message Tom Lane 2021-09-06 13:38:27 Re: pg_upgrade - fe_sendauth: no password supplied