The blog post details the process of migrating specific tables between PostgreSQL instances using native logical replication, as Google’s Database Migration Service (DMS) does not support this. It outlines steps including granting...
About:
The website 'Anantha Kumaran · random thoughts' suggests that it is a personal blog or platform where Anantha Kumaran shares his random thoughts and ideas.
Website:
Outgoing Links:
Subscribe to RSS:
Overlay bar charts effectively visualize dependent metrics like ad impressions and clicks, offering clarity and compactness compared to traditional bar chart formats.
The post discusses the process of upgrading a multi-terabyte PostgreSQL database from version 13 to 16 in Google Cloud Platform using Google's Database Migration Service (DMS). It covers lessons learned, DMS setup, limitations, mi...
The author discusses building a hybrid query engine at work, using PostgreSQL and ClickHouse. They explain the challenges they faced with data consistency and caching, and how they overcame these challenges by using an intermediat...
The author discusses how to address system bottlenecks in the Erlang Virtual Machine. They describe how they identified the root cause of high CPU usage and used the lcnt tool to measure VM-level lock issues. The author also expla...
0ETS vs Redis
2024-10-26 • optimization bottleneck identification
The author discusses the process of identifying and fixing a bottleneck in a system that resulted in a 40% CPU reduction. They detail the steps taken to profile the system in production, identify the bottleneck, and make optimizat...
0Sad Servers
2023-10-29 • web development docker debugging network management
The text is about a website called sadservers, which has 28 problems, each presenting a broken server. The author shares their solutions to some of the problems, including issues with log files, counting IPs, finding secret combin...
The post discusses the N + 1 queries problem in depth, providing a detailed explanation of the problem, its sequence of queries, and potential solutions. It also explores band-aid solutions, attempts to fix the problem, and an ide...
The text describes a situation where the author receives an alert about a high failure rate on a microservice. He investigates the issue by checking logs and raw HTTP requests, eventually finding that an expired API key was causin...
The text discusses the standard practice of caching dependencies and compiled artifacts to improve CI build time for Elixir apps. It explains an issue with test coverage computation and the process of tracing the function calls to...
The post explains how to capture traces and integrate them with Sentry for performance monitoring in Elixir applications using OpenTelemetry. It discusses the context propagation, OTEL Collector configuration, fine-tuning, and kno...
The text discusses the author's experience with NixOS, an OS setup that allows for easy version control, replication on new machines, and management of software packages. The author highlights the benefits of NixOS but also points...
The text discusses setting up a workflow where the code resides on a remote machine and the development happens from a macbook pro laptop. It explores two approaches, tramp and terminal client over SSH, and the issues and solution...
0Dark Mode Toggle
2020-05-09 • macos automation themes applescript
The text explains how the author automated the process of switching between dark and light themes on macOS. It includes the code for enabling dark mode in the OS, terminal, tmux, and Emacs.