Blog

Published by Baron Schwartz on Feb 1, 2019 11:04:00 AM

Covering Indexes in MySQL, PostgreSQL, and MongoDB

A covering index is a fantastic query performance optimization. An index covers a query when the index has all the data needed to execute the query, so the server can retrieve the query’s data without reading any rows or documents. Covered queries are usually SELECT queries, but in addition to reads, indexes can cover portions of what a write query needs to do its work.

In this article I’ll explain what a covering index is in a bit more detail; the technical implementation and caveats in MySQL, PostgreSQL, and MongoDB; and how to check that a query is using a covering index.

Read More
Published by Baron Schwartz on Jan 28, 2019 2:36:00 PM

What is Concurrency in a Database?

Databases are confusing! Not only are they complicated bits of software, but database jargon is really complicated. Part of this comes from the number of words that have multiple meanings: depending on which community you spend time in, there are multiple meanings for words like schema, cluster, and even database.

Read More
Published by Baron Schwartz on Jul 30, 2018 1:47:27 PM

What is Cardinality in Monitoring?

I wrote a couple of “definitions and nuances” posts about terminology in databases recently (cardinality, selectivity), and today I want to write one about cardinality in monitoring, as opposed to cardinality in databases. If you’ve seen discussions of “high-cardinality dimensions” or “observability requires support for high-cardinality fields” this is what we’re talking about today. So what does it mean?

Read More
Published by Samantha Toet on Jul 10, 2018 12:43:04 PM

VividCortex Welcomes Amena Ali as CEO

Exciting news: today we announced the appointment of Amena Ali as Chief Executive Officer and member of the Board of Directors. Company founder Baron Schwartz will now assume the role of Chief Technology Officer. “I am proud of the product and culture we’ve built,” said Baron. “I’ve always believed that the keys to a rewarding career are being challenged, making a meaningful impact, and working with delightful people. Amena joins at the perfect time to scale the company and team, while I redouble my focus on our customers and the product vision for the next wave of monitoring needs.”

Read More
Published by Baron Schwartz on Jul 6, 2018 12:11:30 PM

What is Cardinality in a Database?

Databases have a lot of jargon, and cardinality is one of those words that experienced people tend to forget that they didn’t know once upon a time. But if you don’t know it—and it takes a while to really get comfortable with cardinality—it’s super confusing when the DBA just drops it into the middle of a sentence without slowing down! Fear not: I’ve got you, as they say.

Read More

Recent Posts

Posts by Topic

see all