Don't pick a partial index for speed
Four index strategies on a 10M-row Postgres queue table: the winner didn't win for the reason I gave, and one setting turned it into a 1,673x loss.
All posts 
Category
Tools & Technologies
Developer tools: Git, Composer, npm, build tools, Docker, databases, messaging, search, CI/CD and debugging.
This category has 21 posts.
Git in Production: A Senior Engineer's Practical Guide
From workflow selection to bug hunting with bisect, rebase discipline, worktrees, and signed commits — things I noticed after years of using Git.
Did Someone Say GitHub Actions?
An introduction to CI/CD with GitHub Actions: how to set up workflows and automate your deployment process.
Getting Started with Big Data Using Elasticsearch and Kibana
An introduction to Elasticsearch and Kibana: the fundamentals of full-text search, data analysis, and visualization at scale.
RabbitMQ with PHP
Using RabbitMQ with PHP: creating a message queue, publishing messages, and consuming them.
Docker containerization: installation and basic usage
A hands-on beginner's guide to Docker's container architecture, core commands, and the concepts of volumes and networking.