Inquiry on Future Plans for Enhancements to PostgreSQL MVCC Model and Vacuum Process

From: 송영욱 <pidaoh(at)g(dot)skku(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Inquiry on Future Plans for Enhancements to PostgreSQL MVCC Model and Vacuum Process
Date: 2024-11-01 12:56:55
Message-ID: CAK9ZnjOD+EeGrx9rAFVGEopCEBHTz2bYaxT7=Uity3JatwKoQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

I’m currently studying the internals of PostgreSQL, specifically the vacuum
process.

I've learned that PostgreSQL’s MVCC model has had issues in the past, such
as XID wraparound and table bloating problems. It seems that these issues
may have been mitigated by implementing features like autovacuum.

However, from my understanding, the current MVCC model seems to have more
negative effects than positive ones. Is there any plan to modify the MVCC
model in future versions?

I’m still learning about PostgreSQL, so there may be some inaccuracies in
my understanding. If there are, please let me know.

Thank you

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Karlsson 2024-11-01 13:08:07 Re: Collation & ctype method table, and extension hooks
Previous Message Peter Eisentraut 2024-11-01 12:53:58 Re: Time to add a Git .mailmap?