MVCC and all that...

From: Ellen Allhatatlan <ellenallhatatlan(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: MVCC and all that...
Date: 2025-09-09 16:27:10
Message-ID: CAMLfE0MAVH5YORs0OKmD=fFWH9EtuNsnhViti=+hkp3Kbz-Gfw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Reading this article
https://firebirdsql.org/migrating-from-firebird-to-postgresql-what-can-go-wrong-
I'm a bit confused (not the first time...)

In part 1. Differences in MVCC implementation - he's saying that "It’s
not that the PostgreSQL implementation of MVCC is bad — it’s just
fundamentally different"

But, I thought Firebird had SWEEP instead of VACUUM (how much closer
can the words be?) and that FB's implementation of MVCC was
essentially similar.
Is this correct? Then why is he pointing out the performance diffs
because of MVCC? I'm puzzled!

--

El!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2025-09-09 16:40:50 Re: MVCC and all that...
Previous Message Laurenz Albe 2025-09-09 05:22:02 Re: Re : Fast switchover