Managing PostgreSQL table partitioning in Ruby - Honeybadger Developer Blog

PostgreSQL table partitioning is a great way to improve database bloat but is hard to manage. The pg_partition_manager gem can help you maintain partitions.As your application usage grows, so does your data. At some point, that growth starts to hurt your database, and in turn, your application performance (in which case, you will hopefully be alerted by your Ruby application monitoring tool). Massive database tables in PostgreSQL can cause all sorts of headaches. At some point, you'll notice slower queries, bloated indexes, and even long-running DELETE operations. You can buy yourself a lot of time by adding the right indexes and tuning your queries, but eventually, the sheer volume of rows can still degrade performance over time. We use partitioned tables at Honeybadger in our primary PostgreSQL database to efficiently expire old data, since deleting a bunch of data from our huge tables was causing database performance to suffer.