> On Sep 20, 2023, at 14:11, veem v <veema0...@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 vacuuming are 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 somewhat limited ability to offer
advice about it.
