DatabasesPlanet PostgreSQL
Databases
Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency control: reads never block writes, and writes never block reads. Its locking system has 8 table-level lock modes and 4 row-level lock modes, and the…
The engineering team at Meta recently outlined how the company migrated a data ingestion platform that transfers several petabytes of MySQL social graph data daily to improve reliability and operational efficiency. The team used techniques…
PostgreSQL 14 unified query-id computation across all subsystems, but defaulting to always-on would tax every backend.
PostgreSQL finally has an open-source Transparent Data Encryption option.