> > 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"
> It is written by someone @firebirdsql.org so one assumes a few grains of salt
> necessary.
I know - but the guy does st
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 di
You, (Merlin Moncure) said:
> Technical discussions from the 80's are more or less historically interesting
> only.
I agree with your technical points - and the fact that I brought up "history".
I was replying to Justin in this context:
I wrote:
> AIUI, Michael Stonebraker suggested that the
>> AIUI, Michael Stonebraker suggested that the process model
>> would/should be "upgraded" to a threaded one at some point in the
>> system's developement?
> I am going to need a source on this. Process vs Threads: pro and cons are
> very well documented and proven today.
Ask, and it will be
> Though I would like to know what happened in mid 2010?:
> https://github.com/FirebirdSQL/firebird/graphs/contributors
Yes, indeed, WTF? I'm not a member of the FB Illuminati - so I can't say!
> > OK again. I'm just wondering if the single file per database isn't a
> > fundamental architectural
Hi, and thanks for your input,
Just before I reply - if you (at least here in Ireland - Google's
answers vary per location, unlike Duckduckgo's) search for "firebird
mvcc mechanism" the "AI assistant" tells me twice that FB's MVCC
implementation is "like PostgreSQL's"... I'll investigate further a
> Note: your link is wrong, corrected here:
Extra hyphen - sorry about and thanks for pointing it out!
> What the article is driving at is that postgres does not use rollback logs to
> handle updated records in the MVCC implementation. There are absolutely
> performance tradeoffs in that decis
