Remove tag histogram
article thumbnail

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Scalegrid

If you store each of the keys as columns, it will result in frequent DML operations – this can be difficult when your data set is large - for example, event tracking, analytics, tags, etc. For the purposes of this blog, when we refer to JSON support in PostgreSQL, we will refer to JSONB going forward.

Storage 321
article thumbnail

Rapid development in R with lots of help from ChatGPT

Adrian Cockcroft

The rest of this blog post is an edited version of the conversation I had with ChatGPT, that also acts as documentation of the code I’ve open sourced. This work built on my previous blog post —  Percentiles Don’t Work — Analyzing the Distribution of Response Times. The logfile I started with had several minutes of data in it. .

article thumbnail

The Performance Inequality Gap, 2024

Alex Russell

The blog you're reading loads over a single connection in ~1.2 As inequality grows, averages and "generation" tags can become illusory and misleading. One option is to use a population-level assessment of medians from something like the Speedtest.net data and then construct a histogram from median speeds.