Search for a command to run...
Articles tagged with #software-architecture
PostgreSQL guarantees durability using Write-Ahead Logging (WAL). WAL ensures that once a transaction is committed, its changes survive crashes, even if the actual table or index pages were never written to disk at the time of failure. This article g...
PostgreSQL Locks — A Detailed Guide When working with PostgreSQL, understanding locks is essential for reasoning about concurrency and troubleshooting blocking queries. Postgres uses two main categories of locks: row-level locks and table-level locks...
Background Sequential integer for primary keys/unique IDs has been the default choice in most database systems around the world. It has proven to be effective given the int type selected is large enough to not cause any overflow issues.UUIDs (Univers...
