Re: How to do faster DML

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: How to do faster DML
Дата
Msg-id CAFCRh-8MwD-jj1-EPB4QfD1BBQKv3RcCu16WHkzFk6--BOsp3A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to do faster DML  (veem v <veema0000@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: Safest pgupgrade jump distance
Следующее
От: Johnathan Tiamoh
Дата:
Сообщение: Re: Safest pgupgrade jump distance