Re: MVCC and all that...

Rob Sargent <robjsargent@gmail.com>

From: Rob Sargent <robjsargent@gmail.com>
To: Ellen Allhatatlan <ellenallhatatlan@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-09-09T16:40:50Z
Lists: pgsql-general

> On Sep 9, 2025, at 10:27 AM, Ellen Allhatatlan <ellenallhatatlan@gmail.com> wrote:
> 
> 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!
> 

It is written by someone @firebirdsql.org so one assumes a few grains of salt necessary. 
>