#mvcc

VACUUM: dọn dead tuple để tái dùng chỗ, không trả disk cho OS VACUUM là câu lệnh bảo trì...

MVCC trong Postgres: vì sao UPDATE không ghi đè, mà mọi bảng update-nóng đều đi kèm...

Read Committed: snapshot mỗi statement, và vì sao hai SELECT trong cùng transaction có thể...

ACID transaction trong Postgres: vì sao một BEGIN quên COMMIT đủ để hạ cả service Một...

When working with PostgreSQL, especially in applications requiring high concurrency, correctly...

https://www.youtube.com/watch?v=fY-pGkrLXg4 You're building a RAG app. Your team says: Postgres for...

Database selection is a critical decision, especially for indie hackers developing their own...

In high-concurrency systems, traditional locking mechanisms often become performance bottlenecks....

MongoDB uses the WiredTiger storage engine, which implements Multi‑Version Concurrency Control (MVCC)...

YugabyteDB uses PostgreSQL code to handle SQL queries without the challenges associated with...

SQL databases store the current state and enough information to read about a previous state with...

Beware possible locks on large updates/deletions Historically, traditional databases dealt...