Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: MVCC and all that...
Date: Tue, 9 Sep 2025 10:40:50 -0600
Message-Id: <C1E6A3DC-C13C-4051-AE27-10E83E42AA8E@gmail.com>
References: <CAMLfE0MAVH5YORs0OKmD=fFWH9EtuNsnhViti=+hkp3Kbz-Gfw@mail.gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
In-Reply-To: <CAMLfE0MAVH5YORs0OKmD=fFWH9EtuNsnhViti=+hkp3Kbz-Gfw@mail.gmail.com>
To: Ellen Allhatatlan <ellenallhatatlan@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/C1E6A3DC-C13C-4051-AE27-10E83E42AA8E%40gmail.com>
Precedence: bulk


> On Sep 9, 2025, at 10:27=E2=80=AFAM, Ellen Allhatatlan <ellenallhatatlan@g=
mail.com> wrote:
>=20
> =EF=BB=BFReading this article
> https://firebirdsql.org/migrating-from-firebird-to-postgresql-what-can-go-=
wrong-
> I'm a bit confused (not the first time...)
>=20
> In part 1. Differences in MVCC implementation - he's saying that "It=E2=80=
=99s
> not that the PostgreSQL implementation of MVCC is bad=E2=80=89=E2=80=94=E2=
=80=89it=E2=80=99s just
> fundamentally different"
>=20
> 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!
>=20
>=20
> --
>=20
> El!
>=20

It is written by someone @firebirdsql.org so one assumes a few grains of sal=
t necessary.=20
>=20