Home > mailing lists

Re: How to do faster DML - Mailing list pgsql-general

From	Dominique Devienne
Subject	Re: How to do faster DML
Date	February 12 13:30:09
Msg-id	CAFCRh-8MwD-jj1-EPB4QfD1BBQKv3RcCu16WHkzFk6--BOsp3A@mail.gmail.com Whole thread Raw
In response to	Re: How to do faster DML (veem v <veema0000@gmail.com>)
List	pgsql-general

On Mon, Feb 12, 2024 at 7:50 AM veem v <veema0000@gmail.com> wrote:

I think that's not much of a concern with PostgreSQL because you can't
update a row in-place anyway because of MVCC.

Good to know. So it means here in postgres, there is no such concern like "row chaining", "row migration" etc.

which we normally have in a non mvcc database (like Oracle say).

Don't confuse MVCC (Multi-Version Concurrency Control), and various DB-specific MVCC implementation details.

BOTH Oracle and PostgreSQL *are* MVCC (read Tom Kyte). But they happen to use very different implementations.

SQLite in WAL mode is also MVCC, but using yet another implementation.

All (MVCC) DBs do it differently, but achieve the same effect; albeit with different trade-offs. --DD

From: Justin Clift
Date: 12 February, 13:15:31
Subject: Re: Safest pgupgrade jump distance

From: Johnathan Tiamoh
Date: 12 February, 16:31:02
Subject: Re: Safest pgupgrade jump distance