Latest posts
Kubernetes Pod Tolerations and Postgres Deployment Strategies
Learn how to use Kubernetes taints, pod tolerations, and node affinity for designing and deploying production PostgreSQL topologies.
5 min read
Deep PostgreSQL Thoughts: The Linux Assassin
When Linux detects that the system is using too much memory, it will identify processes for termination and, well, assassinate them. The OOM killer has a noble role in ensuring a system does not run out of memory, but this can lead to unintended consequences.
11 min read
The Answer is Postgres; The Question is How?
Deciding to use Postgres is a great start, we like to think it’s the right start. As to how best to deploy it, you have a number of options.
7 min read
Change Data Capture in Postgres With Debezium
A step-by-step guide for how to setup PostgreSQL change data capture with Debezium and Apache Kafka.
9 min read
Postgres and Crypto Supply Chain of Integrity
How can you 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. If the proof required is more than a casual check, the process is not well documented as far as I can tell. Therefore I will attempt to address that deficiency here.
9 min read
Cleaning Up Your Postgres Database
Actionable steps on how to improve your Postgres database performance.
6 min read
Using GitOps to Self-Manage Postgres in Kubernetes
Deploy PostgreSQL clusters on Kubernetes with GitOps and the Postgres Operator!
6 min read
Deploy TLS for PgBouncer in Kubernetes
Learn how to deploy PgBouncer with TLS connections in Kubernetes using the Postgres Operator!
4 min read
Deploy PostgreSQL With TLS in Kubernetes
Secure communication for your Postgres clusters in Kubernetes by deploying them with TLS. Learn about the different TLS modes that PostgreSQL offers!
7 min read
Production PostGIS Vector Tiles: Caching
Building maps that use dynamic tiles from the database is a lot of fun. You get the freshest data, you don't have to think about generating a static tile set, and you can do it with very minimal middleware, using pg_tileserv.
3 min read
Postgres: The Friendly Relational Member of Your Data Management Toolbox
The recent selection of Postgres as the "Database of the Year" for the third time in four years is by no means an overnight success story, but is well deserved recognition for a database decades in the making. As organizations look for the relational database of the future, Postgres is ready and waiting. We are proud to be among the leading contributors and supporters of this important movement.
3 min read
R Predictive Analytics in Data Science Work using PostgreSQL
Today we are going to finish up by showing how to use that stored model to make predictions on new data. By the way, I did all of the Postgres work for the entire blog series in Crunchy Bridge. I wanted to focus on the data and code and not on how to run PostgreSQL.
8 min read
Announcing the Crunchy Data PostgreSQL Security Technical Implementation Guide
Crunchy Data is pleased to announce the publication of the Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) by the United States Defense Information Systems Agency (DISA). PostgreSQL was the first open source database to provide a published STIG, and Crunchy Data is proud to update and improve the STIG as PostgreSQL continues to advance and evolve.
3 min read
Crunchy Data PostgreSQL Security Technical Implementation Guide Now Available
This new guide is the result of ongoing collaboration with DISA and provides security guidance for PostgreSQL 9.6 through 12
3 min read
Using R in Postgres for Logistic Regression Modeling
Greetings friends! We have finally come to the point in the Postgres for Data Science series where we are not doing data preparation. Today we are going to do modeling and prediction of fire occurrence given weather parameters… IN OUR DATABASE!
8 min read
Loading Data into PostGIS: An Overview
There are a lot of ways to load data into a PostgreSQL/PostGIS database and it's no different with spatial data. If you're new to PostGIS, you've come to the right place. In this blog post, I'll outline a few free, open source tools you can use for your spatial data import needs.
8 min read
PostgreSQL 13 Benchmark: Memory Speed vs. TPS
Today I'm changing the memory speed on my main test system, going from 2133MHz to 3200MHz, and measuring how that impacts PostgreSQL SELECT results. I'm seeing a 3% gain on this server, but as always with databases that's only on a narrow set of in-memory use cases.
5 min read
Postgres Views with Django: A Quick Demo
In this series so far we've talked about how to get our Django application to save uploaded images as bytea in Postgres. We've also walked through an example of a PL/Python function that processes the binary data to apply a blur filter to the uploaded image. Now, we'll show how to retrieve the blurred image from Django.
4 min read
Postgres, PL/Python and SciPy/NumPy for Processing Images
I recently wrote about building a Django app that stores uploaded image files in bytea format in PostgreSQL. For the second post in this series, we're now going to take a look at applying a blur filter to the uploaded image using PL/Python.
7 min read
Active-Active PostgreSQL Federation on Kubernetes
Learn how to deploy an out-of-the-box multi-master PostgreSQL solution to federate your data on Kubernetes with the Postgres Operator.
15 min read
