Deep PostgreSQL Thoughts: Resistance to Containers is Futile - Having recently run across sweeping statements that suggest containers are not ready for prime time as a vehicle for deploying your databases, Joe Conway explains why those statements are patently false.
Cleaning Up Your Postgres Database - You don’t need to understand how MVCC underlies Postgres or how to determine during a failover that it is safe to failover to have a well tuned Postgres database. This post walks through several monitoring tools and options available to take actionable steps on how to improve your database performance.
Helm, GitOps and the Postgres Operator - Methods demonstrated in a previous blog post showed how direct creation and manipulation of the PostgreSQL custom resources allow for GitOps workflows. Tools like Helm can take this a step further by providing simpler encapsulation to both get started and further refine a PostgreSQL cluster.
The Answer is Postgres; The Question is How? - Deciding to use Postgres is a great start, in fact we like to think it’s the right start. As to how best to deploy it, you have a number of options. So which deployment model is appropriate for you? As usual, it depends.
Fuzzy Name Matching in Postgres - A surprisingly common problem in both application development and analysis is: given an input name, find the database record it most likely refers to. It's common because databases of names and people are common, and it's a problem because names are a very irregular identifying token.
Query Optimization in Postgres with pg_stat_statements - When it comes to query optimizing, how should you pick your battles? Luckily, in PostgreSQL we have a way to take a system-wide look at database queries and this blog post dives into shining a light on using pg_stat_statements.
Change Data Capture in Postgres with Debezium - Debezium is built upon the Apache Kafka project and uses Kafka to transport the changes from one system to another. This blog post takes a look at how this works.
ArcGIS Feature Service to PostGIS: The QGIS Way - Kat Batuigas takes local open data and shows how to move data from ArcGIS to PostGIS. Learn more about ArcGIS Feature Services and ogr2ogr.
Kubernetes Pod Tolerations and Postgres Deployment Strategies - Take a look at how to use Pod tolerations with the PostgreSQL Operator to create different production topologies, starting with how Kubernetes taints, tolerations, and node affinity can work together.
Deep PostgreSQL Thoughts: The Linux Assassin - For years the PostgreSQL community has made recommendations on how to set up Linux systems to keep the Linux Assassin away from PostgreSQL processes. This blog dives into those steps and an explanation of experiments and observations made.
Postgres and Crypto Supply Chain of Integrity - How do I get PostgreSQL to use FIPS 140-2 crypto? The answer, to some extent, depends on how rigorously you need to be able to prove your answer. Joe Conway dives into this process.