[MM3-users] Re: moving from sqlite3 to postgresql

2025-04-20 Thread Mihai Moldovan
* On 4/20/25 11:24, Stephen J. Turnbull wrote: This sounds to me like your runners are crashing, as Mark suggested. But even if that's resolved, you're still going to have a performance issue (lock contention for seconds or even minutes maybe[1]) even if you don't get stuck for days. > Fair en

[MM3-users] Re: moving from sqlite3 to postgresql

2025-04-20 Thread Stephen J. Turnbull
Michael Richardson writes: > Stephen J. Turnbull wrote: > > that they're stable. Unfortunately, the email and web > > environments are not, and dealing with changes in them is > > often quite impractical given the Debian release cycle. > > Yes, I'm aware of this tusscle. > Th

[MM3-users] Re: moving from sqlite3 to postgresql

2025-04-19 Thread Michael Richardson
Stephen J. Turnbull wrote: >> I installed via debian packages, and I'd really prefer to stay with that. >> (Not what many maintainers would say, I know. Essential that it work if >> mailman3 is going to take over) > That's really Debian's problem, and it's a hard one since the w

[MM3-users] Re: moving from sqlite3 to postgresql

2025-04-18 Thread Andreas Barth
* Michael Richardson (m...@sandelman.ca) [250418 18:55]: > So I tried to switch last week from sqlite3 to postgresql. I did that migration and cannot recommend it, rather direct start with postgres. Having said this, I wrote in 2021 ==<== Stop all external connections to your systems for the whol