Re: Database selection

2023-09-20 Thread Laurenz Albe
On Thu, 2023-09-21 at 02:41 +0530, veem v wrote: > However, One of the things regarding the transaction management, which I see > in > most postgres blogs is 'mvcc'(multiversion concurrency control) being an issue > at times in a heavy concurrent system, in postgres as its maintaining exact > copi

Re: Database selection

2023-09-20 Thread Christophe Pettus
> On Sep 20, 2023, at 14:11, veem v wrote: > > Does AWS aurora postgres depend on the same vacuuming technology for > maintaining the transactions? Yes. Aurora has replaced the PostgreSQL storage engine, but the MVCC part is largely the same. The issues with vacuuming are largely oversta

Re: Database selection

2023-09-20 Thread veem v
Thank you. Yes feature wise postgres seems rich as I read multiple blogs. And right now, I can't think of any other reason for opting mysql though as opposed to postgres. However, One of the things regarding the transaction management, which I see in most postgres blogs is 'mvcc'(multiversion con

Re: Database selection

2023-09-20 Thread Laurenz Albe
On Thu, 2023-09-21 at 01:17 +0530, veem v wrote: > I see multiple docs on the internet, stating the difference between Mysql and > postgres. > But I want to understand the real views of the experienced folks here. > > While we are on AWS and planning to opt for one of the relational databases >