Re: MVCC and all that...

2025-09-11 Thread Rob Sargent
> On Sep 9, 2025, at 10:27 AM, Ellen Allhatatlan > 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

Re: MVCC and all that...

2025-09-11 Thread Pavel Stehule
Hi > Final thoughts on this: firebird (fmrly interbase) did not achieve the > level of success in the market that postgres, even though they may have > been similarly positioned. My take: that disparity in success has more to > do with postgres having a more open development model, stronger comm

Re: Re : Fast switchover

2025-09-11 Thread Laurenz Albe
On Tue, 2025-09-09 at 05:07 +, legrand legrand wrote: > > > what could we expect (in term of downtime in both worlds) ? > > > Usually seconds, so plan for ten minutes. > > Brrr, I was thînking about a more reliable process. If you want more reliable numbers, make a test run on your system.

Re: MVCC and all that...

2025-09-11 Thread Ellen Allhatatlan
>> 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

Re: [Announcement] ​A Bitemporal Solution for PostgreSQL (Beta)

2025-09-11 Thread Lorusso Domenico
sorry here the link https://github.com/DomenicoL/table-versioning/ Il giorno gio 11 set 2025 alle ore 17:08 Lorusso Domenico < domenico@gmail.com> ha scritto: > Dear all, > > I am gald to share an open-source project I've been developing in my free > time. It's a bitemporal solution built en

Re: Fast switchover

2025-09-11 Thread Ron Johnson
On Mon, Sep 8, 2025 at 11:03 AM legrand legrand wrote: > Hello all the readers, > > For some projects we need a fast *manual* switchover to address Near Zero > downtime maintenance > (not speaking here about automated failover like those provided by HA > tools, but just planned, controlled operat