Re: Database selection - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Database selection
Date
Msg-id E479B652-9356-41D2-87E9-56D6C9555163@thebuild.com
Whole thread Raw
In response to Re: Database selection  (veem v <veema0000@gmail.com>)
List pgsql-general

> On Sep 20, 2023, at 14:11, veem v <veema0000@gmail.com> 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
vacuumingare largely overstated, though, and alternative system for concurrency control have their own issues. 

> Does Aurora Mysql opt for a similar strategy for transaction management? or any different/better ones?

That's probably best addressed to a MySQL-oriented list, or directly to Amazon.

It should be noted that Aurora is a commercial product, and much of it is closed-source.  User communities will have
somewhatlimited ability to offer advice about it. 


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
Next
From: "David G. Johnston"
Date:
Subject: Re: Changed functionality from 14.3 to 15.3