Latest posts
Phases 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 readParquet and Postgres in the Data Lake
Have too much static data? Paul has a idea of moving some of it to a datalake. He provides a walk-through of setting up Parquet with Postgres using the parquet_fdw.
8 min readEasy Postgres Major Version Upgrades Using PGO v5.1
Today we’re excited to introduce support for major PostgreSQL upgrades in PGO v5.1. Using the new PGUpgrade API, you can now seamlessly upgrade your clusters across major versions of PostgreSQL.
7 min readPGO Version 5.1 Release Comes With Powerful New Capabilities
We're excited to announce the general availability of version 5.1 of PGO, the open source Postgres Operator from Crunchy Data. In addition to providing a seamless upgrade experience across both PGO and PostgreSQL versions, this feature-packed release also introduces many powerful new capabilities.
4 min read
PostGIS For Newbies
Load some PostGIS data, import a shape file and publish a map to the web. Easy peasy lemon squeezy.
Announcing Postgres Container Apps: Easy Deploy Postgres Apps
With Postgres Container Apps you can, from directly inside Postgres with a simple function call, spin up a container that is running right alongside your Postgres database!
6 min read
Spatial Filters in pg_featureserv with CQL
In this post we'll show some examples of spatial filtering using CQL with pg_featureserv.
5 min readPostGIS vs GPU: Performance and Spatial Joins
Paul takes a recent example of GPU-assisted spatial joins project to see how PostGIS stacks up in the same situation. He goes through the steps of joining a large record set of parking data with neighborhood data.
5 min read
CQL Filtering in pg_featureserv
Recently Crunchy Data added pg_featureserv support for most of CQL2. Here we'll describe the powerful new capability it provides.
4 min readHow to Cheat at WORDLE with PostgreSQL
Fun with PostgreSQL! Using the French Wordle list, this post shows you some sql to find out the most often used letters in a table, how to reduce possibilities once you’ve found some letters, and how to solve wordle puzzles using the back end.
13 min readCloud Data Sources for the Postgres Operator for Kubernetes
New feature release for PGO v5.0.5 Initializing your Postgres database with backups from AWS S3, GCS or Azure.
5 min readSafer Application Users in Postgres
Risk management for Postgres. A guide to changing application user permissions so they can't delete your production database.
8 min read
