Diving into some lesser-known Java tools to analyse how much memory is being consumed in the code cache
Performance comparison of wide vs narrow table for fuzzy searching of track durations in PostgreSQL
How we tracked down a memory problem in an unusual situation.
When joining multiple tables to a single table, rows can get duplicated. I evaluated a number of solutions to eliminate the duplication when using JSON, to find the most performant one.
How we sped up loading a MusicBrainz data dump into PostgreSQL on RDS.