Tag: performance tuning

The 2020 edition of Black Friday and Cyber Monday is now behind us. But smart organizations are still studying it closely. That’s because, for better or worse, Black Friday and Cyber Monday have a lot to say about how well…

Covering indexes in Postgres came up in our weekly tech call because of a query optimization review one of the teams has in progress. It seemed like some covering indexes weren’t working. I’ve been reading a book called Curious Moon,…

Indexing plays a quintessential role in database query performance and MongoDB is no exception. Choosing the best index for a query will improve its performance, while a bad one could lead to huge execution times and high memory utilization. In…

Memoization is a powerful technique that allows you to improve performance of repeatable computations. Although it would be a pretty handy feature, there is no memoization or result cache for UDFs in Spark as of today. In fact it’s something…

There is an interesting bug that was found during the latest performance tuning we performed for Spark 2.2 (2.3 is also affected). It was a batch Spark job scheduled to be executed hourly and to process about 1Tb worth of…

A huge but often overlooked aspect of tuning cluster databases is workload management. That means controlling on which and how many nodes a RAC database should actively work. The default service and most intuitive configuration is to spread the workload…

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, details Explain Plan on Oracle Live SQL.