Find (and Safely Drop) Unused Indexes in PostgreSQL
A quick query to find PostgreSQL indexes nobody uses, the four checks to run before dropping one, and how to drop it without blocking writes.
PMM Percona Monitoring and Management – Docker Volume illustration
Here is an illustration of using docker volume to run PMM. Also shown is a constrast of using bind mount. Recommended method is to use docker volume with flag -v to persist data on the Host machine.
Kafka Fundamentals
Apache Kafka is a powerhouse for real-time data streaming, acting like a superhighway for data that never sleeps. For database engineers dipping their toes into streaming, it’s your bridge from batch processing to instant insights. Kafka Basics Picture Kafka as a distributed post office for massive data volumes. Producers (apps sending data) drop messages into…
Something went wrong. Please refresh the page and/or try again.
About Me
Hi, I’m Vinay Are. Principal Database Engineer at Teladoc Health Inc. I spend my time with my daughter and wife when I am not working. In my spare time, I do landscape and macro photography as a hobby. This blog is for my love of databases, a place to store important things I want to remember about databases
Subscribe to My Blog
Get new content delivered directly to your inbox.
