MVCC in PostgreSQL — Part 3. Row Versions
In Postgress, if you access a row in transaction T0, then delete that row on transaction T1, then that row is still accessible in transaction T0. How Postgres maintain that view of row? Where does that data sit on disk? Check out other articles in this series such as Forks, files, pages. Let’s level up our database knowledge.
PostgreSQL: detecting slow queries quickly
Performance tuning does not only mean adjusting postgresql.conf properly, or making sure that your kernel parameters are properly tuned. Performance tuning also implies that we have to find performance bottlenecks first, isolate slow queries and understand what the system is doing.
Extreme HTTP Performance Tuning: 1.2M API req/s on a 4 vCPU EC2 Instance
Be aware that you won’t be able to use these setting and immediately bring your RPS up magically. This is a post about customize many low level for a specific workload. Eg, disable Spectre mitigation, syscall blocking. Imagine setting your code to a happy path to eliminate all logging, all if/else auth checking. It’s purely a research to show how fast we can push the machine.
Boosting Dropbox upload speed and improving Windows’ TCP stack
To Dropbox, One of the best ways to find ways to improve performance, we’ve found, is to work closely with our customers. We love shared troubleshooting sessions with their own engineering teams to find and eliminate bottlenecks. They share a story how they are able to work with Window Core TCP team to improved the Windows implementation of the TCP RACK-TLP algorithm
Constant-Time Big Numbers: An Introduction
Most of time when dealing with numbers, we deal with number upto 64 bits and we usually have thing like int32, int64 in our code. The max of these are 2^64. For thing bigger than that, we use Big Number. The use of Big Numbers in Cryptography is actually what makes us care about being Constant-Time.
Behind the scenes of 1Password for Linux
1Password is a password manager app and they finally release Linux support. Their app leverage Rust for backend, Electron, TypeScript, React, Neon to build the UI with HTML technologies.
Teardown of a PC power supply
The task of a PC power supply is to convert the power from the wall (120 or 240 volts AC) into stable power at the DC voltages that the computer requires. The power supply must be compact and low-cost while transforming the power efficiently and safely. To achieve these goals, power supplies use a variety of techniques and are more complex inside than you might expect.
Code to read
Simple Rails & AWS Lambda Integration
GBA emulator written in golang.
A SQL linter and auto-formatter for Humans
14 videos about Postres: backup, recovery, Write ahead logs trade off and more
Imagine your SSH server only listens on an IPv6 address, and where the last 6 digits are changing every 30 seconds as a TOTP code…
Bring in a search bar like Spotlight to any GTK+ app
A simple and complete feature flag solution, without any complex backend system to install, you need only a file as your backend. 🎛️
Get any text on your screen into your clipboard.
A terminal UI Dashboard for monitoring requests for code review across several Github repositories and pull requests.
Kubernetes powered PaaS that runs in your own cloud.
That's it for this round, have a great day! If you like this newsletter, please tell the world, or
tweet about this