Writing in PostgreSQL at sub-light speed: 1 host, 1 day, 1TB
Recently, I discussed how to boost the performance of 'read' SQL queries from a PostgreSQL database using standard recipes. Today, we will focus on how to make database writes more efficient without using any 'tweaks' in the config — simply by correctly organizing data flows. #1. Partitioning This article is about how and why it is worth organizing application partitioning 'in theory' […]
