How We Made PostgreSQL Upserts 300x Faster on Compressed Data

A developer's customer challenge often becomes their own. In this case, one of the customers, Ndustrial, an industrial energy optimization platform, reported that they had to resort to workarounds due to suboptimal PostgreSQL upsert performance when using TimescaleDB. The solution was a 300x increase in upsert performance over compressed data by modifying the upsert process to use existing indexes to find all batches of rows that need to be decompressed. This optimization not only resolved the immediate performance issues but also opened the door for Ndustrial to manage their data more efficiently and confidently.