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 >

Database selection

2023-09-20 Thread veem v
Hello All, 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 out of mysql and postgres for our application(It is