DEV Community

Syed Anzar profile picture

Syed Anzar

404 bio not found

Location Srinagar ,J&K Joined Joined on 
Why Increasing Database Connections Makes Queries Slower: Process Overhead, Little’s Law, and Pool Sizing Math
syed_anzar profile

Why Increasing Database Connections Makes Queries Slower: Process Overhead, Little’s Law, and Pool Sizing Math

#postgres #database #performance #systems
Comments
8 min read

Want to connect with Syed Anzar?

Create an account to connect with Syed Anzar. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Why UPDATE Is Secretly an INSERT: How Postgres MVCC, xmin/xmax, and Table Bloat Actually Work
syed_anzar profile

Why UPDATE Is Secretly an INSERT: How Postgres MVCC, xmin/xmax, and Table Bloat Actually Work

#postgres #database #performance #systems
Comments
7 min read
How Linux Zero-Copy Actually Works: sendfile, DMA Scatter-Gather, and Page Cache Internals
syed_anzar profile

How Linux Zero-Copy Actually Works: sendfile, DMA Scatter-Gather, and Page Cache Internals

#linux #systems #performance #networking
Comments
6 min read
How Model Context Protocol (MCP) Actually Works: JSON-RPC 2.0, Stdio IPC, and Low-Level Tool Calling
syed_anzar profile

How Model Context Protocol (MCP) Actually Works: JSON-RPC 2.0, Stdio IPC, and Low-Level Tool Calling

#ai #programming #architecture #systems
Comments
8 min read
How LoRA Actually Works: Low-Rank Decomposition, Weight Merging, and Memory Breakdown Under the Hood
syed_anzar profile

How LoRA Actually Works: Low-Rank Decomposition, Weight Merging, and Memory Breakdown Under the Hood

#ai #machinelearning #programming #performance
Comments
8 min read
Why Write-Heavy Databases Use LSM-Trees: MemTables, SSTables, Bloom Filters, and Compaction Under the Hood
syed_anzar profile

Why Write-Heavy Databases Use LSM-Trees: MemTables, SSTables, Bloom Filters, and Compaction Under the Hood

#database #systems #performance #programming
Comments
9 min read
How SQLite WAL Mode Actually Works: The 3 Files, Shared Memory, and Lock-Free Reads
syed_anzar profile

How SQLite WAL Mode Actually Works: The 3 Files, Shared Memory, and Lock-Free Reads

#sqlite #database #programming #performance
Comments
9 min read
How eBPF Actually Runs Inside the Linux Kernel: The Verifier, JIT, and BPF Maps
syed_anzar profile

How eBPF Actually Runs Inside the Linux Kernel: The Verifier, JIT, and BPF Maps

#linux #systems #performance #programming
Comments
7 min read
How Structured Outputs Actually Work: Grammar-Constrained Decoding and Logit Masking Under the Hood
syed_anzar profile

How Structured Outputs Actually Work: Grammar-Constrained Decoding and Logit Masking Under the Hood

#ai #machinelearning #programming #performance
Comments
7 min read
What Actually Happens During Speculative Decoding in LLMs
syed_anzar profile

What Actually Happens During Speculative Decoding in LLMs

#ai #machinelearning #performance #programming
Comments
8 min read
Python 3.13 Free-Threading: What Actually Happens When the GIL Is Removed
syed_anzar profile

Python 3.13 Free-Threading: What Actually Happens When the GIL Is Removed

#python #programming #performance #systems
Comments
5 min read
Why LLMs Run Out of VRAM: KV Cache Fragmentation and How PagedAttention Fixes It
syed_anzar profile

Why LLMs Run Out of VRAM: KV Cache Fragmentation and How PagedAttention Fixes It

#ai #machinelearning #performance #programming
1
Comments 1
8 min read
Why kill -9 Cannot Be Trapped: The Kernel's Unstoppable SIGKILL Path
syed_anzar profile

Why kill -9 Cannot Be Trapped: The Kernel's Unstoppable SIGKILL Path

#linux #systems #devops #programming
1
Comments 1
3 min read
Why CPU Branch Prediction Fails: Pipeline Bubbles, Speculative Execution, and Branchless Code
syed_anzar profile

Why CPU Branch Prediction Fails: Pipeline Bubbles, Speculative Execution, and Branchless Code

#performance #systems #computerscience #programming
3
Comments 4
9 min read
What Actually Happens Inside OverlayFS: How Docker Layers, Copy-Up, and Whiteouts Really Work
syed_anzar profile

What Actually Happens Inside OverlayFS: How Docker Layers, Copy-Up, and Whiteouts Really Work

#docker #linux #devops #systems
1
Comments 1
7 min read
What Actually Happens During a Linux Context Switch: Registers, TLB Flushes, and the True Cost of Multithreading
syed_anzar profile

What Actually Happens During a Linux Context Switch: Registers, TLB Flushes, and the True Cost of Multithreading

#linux #systems #performance #programming
1
Comments
9 min read
What Actually Happens During Garbage Collection: Tri-Color Marking, Write Barriers, and Why RSS Stays High
syed_anzar profile

What Actually Happens During Garbage Collection: Tri-Color Marking, Write Barriers, and Why RSS Stays High

#programming #computerscience #performance #systems
1
Comments
8 min read
What Actually Happens Between malloc() and Physical RAM: Virtual Memory, Page Faults, and the MMU
syed_anzar profile

What Actually Happens Between malloc() and Physical RAM: Virtual Memory, Page Faults, and the MMU

#linux #systems #performance #programming
Comments
8 min read
Epoll vs Select vs Poll: How the Linux Kernel Actually Handles 100k Concurrent Connections
syed_anzar profile

Epoll vs Select vs Poll: How the Linux Kernel Actually Handles 100k Concurrent Connections

#linux #networking #systems #performance
Comments
9 min read
Why Hash Tables Collide: Swiss Tables, Robin Hood Hashing, and CPU Cache Lines
syed_anzar profile

Why Hash Tables Collide: Swiss Tables, Robin Hood Hashing, and CPU Cache Lines

#programming #computerscience #performance #systems
1
Comments
9 min read
Compiler vs Interpreter vs JIT: What Actually Happens When Code Executes
syed_anzar profile

Compiler vs Interpreter vs JIT: What Actually Happens When Code Executes

#programming #computerscience #javascript #performance
Comments
8 min read
Why 0.1 + 0.2 != 0.3: What Actually Happens in IEEE 754 Memory
syed_anzar profile

Why 0.1 + 0.2 != 0.3: What Actually Happens in IEEE 754 Memory

#programming #computerscience #javascript #python
1
Comments
7 min read
Stack vs Heap: What Actually Happens in Physical Memory and CPU Registers
syed_anzar profile

Stack vs Heap: What Actually Happens in Physical Memory and CPU Registers

#programming #linux #systems #performance
1
Comments
8 min read
CORS Is Not Server Security: What Actually Happens When a Browser Blocks a Request
syed_anzar profile

CORS Is Not Server Security: What Actually Happens When a Browser Blocks a Request

#webdev #security #javascript #programming
Comments
7 min read
What Actually Happens When an LLM Generates a Single Token
syed_anzar profile

What Actually Happens When an LLM Generates a Single Token

#ai #machinelearning #programming #performance
Comments
8 min read
Postgres Indexes Under the Hood: B-Trees, Page Splits, and Why the Query Planner Ignores You
syed_anzar profile

Postgres Indexes Under the Hood: B-Trees, Page Splits, and Why the Query Planner Ignores You

#postgres #database #performance #programming
Comments
10 min read
What Actually Happens When You Open a TCP Socket in Linux
syed_anzar profile

What Actually Happens When You Open a TCP Socket in Linux

#linux #networking #systems #programming
Comments
8 min read
Cookies vs LocalStorage vs SessionStorage: The Difference Developers Actually Need to Know
syed_anzar profile

Cookies vs LocalStorage vs SessionStorage: The Difference Developers Actually Need to Know

#javascript #webdev #security #frontend
Comments 1
5 min read
What Model Quantization Actually Does: From Float16 to 4-Bit Weights
syed_anzar profile

What Model Quantization Actually Does: From Float16 to 4-Bit Weights

#ai #llm #quantization #machinelearning
1
Comments 3
6 min read
What Actually Happens When You Run `git push`
syed_anzar profile

What Actually Happens When You Run `git push`

#git #programming #devtools #systems
Comments
7 min read
Your Filesystem Is Lying to You: Why fsync() Doesn't Guarantee Durability
syed_anzar profile

Your Filesystem Is Lying to You: Why fsync() Doesn't Guarantee Durability

#linux #systems #database #programming
Comments
3 min read
What Actually Happens When You Run `npm install`
syed_anzar profile

What Actually Happens When You Run `npm install`

#npm #node #dependencies
Comments
5 min read
Your Budget Alert Won't Save You: Building a Real Cloud Spend Circuit Breaker
syed_anzar profile

Your Budget Alert Won't Save You: Building a Real Cloud Spend Circuit Breaker

#aws #cloud #devops
Comments
6 min read
What Actually Happens When You Run `npm install`?
syed_anzar profile

What Actually Happens When You Run `npm install`?

#javascript #node #devtools #internals
1
Comments
6 min read
What Actually Happens When You Run `git push`
syed_anzar profile

What Actually Happens When You Run `git push`

#git #devops #internals #versioncontrol
1
Comments
7 min read
What Actually Happens When You Run `curl https://example.com`
syed_anzar profile

What Actually Happens When You Run `curl https://example.com`

#networking #http #devops #webdev
1
Comments
8 min read
What Actually Happens When You Run `docker run`
syed_anzar profile

What Actually Happens When You Run `docker run`

#docker #containers #linux #internals
3
Comments 1
4 min read
The 3-File Local MCP Server That Tames Your Agent's Tool Sprawl
syed_anzar profile

The 3-File Local MCP Server That Tames Your Agent's Tool Sprawl

#mcp #python #ai #tutorial
3
Comments
6 min read
Your LLM Returns JSON That Isn't JSON: A Robust Structured-Output Pipeline for Local Models
syed_anzar profile

Your LLM Returns JSON That Isn't JSON: A Robust Structured-Output Pipeline for Local Models

#llm #python #ollama #json
2
Comments 1
7 min read
Your Agent's Memory Is a Lie: A Durable, Queryable Memory Layer for Local LLM Agents
syed_anzar profile

Your Agent's Memory Is a Lie: A Durable, Queryable Memory Layer for Local LLM Agents

#aiagents #python #llm #sqlite
1
Comments
7 min read
Your Cron Job Is Lying to You: A Dependency-Free Watchdog for Silent Failures
syed_anzar profile

Your Cron Job Is Lying to You: A Dependency-Free Watchdog for Silent Failures

#devops #bash #python #automation
1
Comments
7 min read
10 Open-Source GitHub Repositories That Challenge Expensive Paid Apps
syed_anzar profile

10 Open-Source GitHub Repositories That Challenge Expensive Paid Apps

#opensource #github #webdev #programming
1
Comments
3 min read
TCP vs UDP Explained Simply: Why Video Calls Glitch and Downloads Don't
syed_anzar profile

TCP vs UDP Explained Simply: Why Video Calls Glitch and Downloads Don't

#networking #webdev #architecture #programming
Comments
3 min read
How to Build a $0 Fully Automated Tech Video Pipeline with Open-Source Tools
syed_anzar profile

How to Build a $0 Fully Automated Tech Video Pipeline with Open-Source Tools

#opensource #ai #automation #python
Comments 4
3 min read
loading...