Plurrrr

a tumblelog
Wed 03 Jun 2020

PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage

PostgreSQL 9.5 introduced a feature called block range indexes (aka BRIN) that is incredibly helpful in efficiently searching over large time series data and has the benefit of taking up significantly less space on disk than a standard B-tree index. A block range index entry points to a page (the atomic unit of how PostgreSQL stores data) and stores two values: the page's minimum value and the maximum value of the item to be indexed.

In fact, when used appropriately, a BRIN index will not only outperform a B-tree but will also save over 99% of space on disk!

Source: PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage, an article by Jonathan S. Katz.

Task-based async/await in swift

In this post we’ll go over asynchronous APIs in general and some of their issues, what the async/await model of concurrency gives us, some of the primitives that Apple provides, and how Tasker can work for your existing code, new code, and future code when swift actually gets async/await.

Source: Task-based async/await in swift, an article by Æli Akhtarzada.

Colors in CSS: The present and future

In a previous blog post with LogRocket, I covered the RGB and HSL color models and how to manipulate their various color properties. One aspect that I did not have the chance to cover was some of the upcoming models coming to CSS. This post will overview all of the color models, new and old, that will be a part of the CSS Color Module Level 4, their properties, and when they might be useful.

Source: Colors in CSS: The present and future, an article by Adam Giese.