/ blog
-
Practical Partitioning in Production with Postgres [Postgres Vision 2021]
Has your table become too large to handle? Have you thought about chopping it up into smaller pieces that are easier to query and maintain? What if it's in constant use?
Read more... -
Changing your huge table's data types in production [FOSDEM 2021]
You have a huge table, and it is necessary to change a column's data type, but your database has to keep running with no downtime. What do you do? Here's one way to perform this change, in as unobtrusive a manner as possible while your table keeps serving users, by avoiding long DDL table locks and leveraging procedural transaction control.
Read more... -
Keep your libraries updated and nobody gets hurt
Sometimes skipping an update or two for a library means that we can trigger unexpected breakages in other software that are very hard to troubleshoot.
Read more...