Latest posts
Rise of the Anti-Join
Find me all the things in set "A" that are not in set "B". Paul has some suggestions of when to use the anti-join pattern in queries with some impressive results.
5 min readCrunchy Bridge Terraform Provider
Terraform brings IaC practices to our fully managed cloud service, Crunchy Bridge. Find out how to get started with our Terraform provider.
Accelerating Spatial Postgres: Varnish Cache for pg_tileserv using Kustomize
Rekha offers a step-by-step guide for deploying Varnish Cache for pg_tileserv using Kustomize and the Postgres Operator for Kubernetes on OpenShift.
5 min readPartitioning with Native Postgres and pg_partman
Partitioning is a handy tool for managing size and performance as your database scales. Elizabeth offers a tutorial of native partitioning and pg_partman using a sample IoT dataset. This tutorial contains the sql and steps for you to try out partitioning yourself with Postgres.
Postgres Indexing: When Does BRIN Win?
Wondering about how to choose between BRIN and BTree indexes? Read about the best cases for BRIN indexes with some testing against BTree.
6 min readChoosing a PostgreSQL Number Format
Paul does a deep dive on number data types. Read about how to choose a number type that's most efficient for your data and storage requirements.
5 min readData To Go: Postgres Logical Replication
Logical replication means you can take your data wherever you need it - for reporting, analytics, or testing. This is a tutorial on the basics of setting up logical replication.
Postgres Locking: When is it Concerning?
Seeing locks in your Postgres monitoring but don't know what it means? David takes a look at locks and what to take into consideration.
8 min readSnap Clones with the Postgres Operator on Kubernetes
For customers using Postgres Operator for Kubernetes, Brian details the steps to create storage snapshots using pgBackRest delta restores for non-production use cases. This solves the need for frequent data copies combined with minimizing storage and thin provisioning.
14 min readPostgres Indexes, Selectivity, and Statistics
Paul looks under the covers at Postgres query plans, indexes, filters, and statistics.
6 min readQuick and Easy Postgres Data Compare
Brian offers a quick and efficient way to compare data between two different Postgres sources using the Postgres Foreign Data Wrapper (postgres_fdw).
9 min readPhases of Database Growth and Cost
When it comes to database performance, many think they are solving technical problems, but are solving a money problem. There are 2 phases to database-cost management, and understanding which phase you are in will help you understand your options for growth.
6 min readEffective PostgreSQL Cluster Configuration & Management Using PGO v5.1
A review of PGO 5.1 features including rolling database restarts, pod disruption budgets, and manual switchovers/failovers.
5 min readExporter2Perfdata - Connecting Postgres Monitoring Tools
Crunchy Data is excited to release a new open source tool, Exporter2Perfdata. This connects Prometheus Exporters with Icinga2/Nagios. This also allows pgMonitor users to connect monitoring information from Prometheus to Icinga2 and Nagios.
3 min readPostgres Query Optimization: LEFT JOIN vs UNION ALL
David optimizes a slow query by splitting up a left join into two calls and using UNION ALL to combine them. The proof is in the pudding.
6 min readInstant Heatmap with pg_featureserv
Use your spatial data with this lightweight web server to make an instant heatmap! Paul sets up a demo using locations, name data, and our new container apps feature to run the pg_featureserv right inside the database.
5 min readPostgres Traceability: Use SQL Comments Like a Stacktrace
Which of my applications ran this SQL statement? Use SQL comments to track which application ran which queries.
4 min readThe Vectors of Database Encryption
Keith offers a high level review of the vectors of attack on databases and database encryption types including Data-At-Rest, Data-In-Transit, and Data-In-Use.
7 min readDemystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
9 min readSeamless pgAdmin 4 Deployments Using PGO v5.1
Need a GUI for your Postgres cluster? PGO 5.1 introduces a new feature to let you create a pgAdmin 4 pod alongside your other database services managed by the Kubernetes Operator.
3 min read
