Postgres Internals I
This document discusses a few high-level concepts of PostgreSQL’s internals. Even though these are not needed in day-to-day activities, knowing them would certainl...
Page 3 of 11
This document discusses a few high-level concepts of PostgreSQL’s internals. Even though these are not needed in day-to-day activities, knowing them would certainl...
The Log-Structured Merge Tree, also known as an LSM tree, is one of the most popular storage engines, focusing on performant write operations. The benefit over the B+ ...
The Byzantine consensus problem is an interesting problem in distributed systems, even though it dates back to medieval times. The idea originates in medieval battle s...
The transaction isolation level is one of the vital aspects to understand how transactions influence each other when run concurrently. Isolation level establishes a ba...
Distributed systems consist of a set of loosely coupled services that end users perceive as a single coherent system. However, due to the loose coupling between compon...
Concurrency and Paralleism - these terms sound similar; however, from a software engineer’s perspective, they denote two different concepts. Concurrency is the abilit...
In this wiki, we will explore an approach to designing a notification service. Requirements What type of notifications do we need to send? => Push, SMS, email ...
In this wiki, we will explore an approach to designing a Web-crawling service. Requirements What is the purpose of the crawler here? Search engine indexing, data m...
In this wiki, we will explore an approach to design a URL shortener service. Requirements: Shortened URLs’ length should be as short as possible Shortened URL sh...
In this wiki, we will explore how various services generate unique IDs. Requirements: Characteristics of the unique ID required IDs must be unique and s...