PostgreSQL DBA

Vocabulary

Question

What is MVCC?

Answer

MVCC is PostgreSQL’s multi-version concurrency control model, where transactions use snapshots to determine which row versions are visible. Production impact. Long-lived snapshots can retain obsolete row versions, delaying cleanup and increasing table bloat.

This is 23 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples