Another one for the Quick Tips category – have you ever needed to see what queries are running against your Postgres database? Perhaps a nightly process hasn’t finished yet and you’re curious if it’s deadlocked? Or maybe the database server is using 100% CPU and you’re not sure why? These, along with many others, are all reasons I have needed to peek under the hood of Postgres.
Building distributed, scalable, systems is complex – and, even more common thanks to the growing number of IoT and mobile devices. A problem I routinely see is developers attempting to treat distributed systems like monolithic systems. Specifically, developers who hold on to patterns such as ACID.