Latest posts
Vehicle Routing with PostGIS and Overture Data
Paul walks through some sample code to use PostGIS and pgRouting with Overture maps. This uses the new spatial analytics capabilities of Crunchy Bridge which can connect to Postgres to a public S3 data stores.
14 min readReal World Performance Gains With Postgres 17 B-tree Bulk Scans
Brandur digs into one of Postgres 17's updates that make b-tree index scans faster. He's tested performance against the Crunchy Bridge API and the results are pretty impressive.
8 min readWindow Functions for Data Analysis with Postgres
Elizabeth has some sample queries and explanations for window functions like running totals, lag/lead, rolling averages, and more.
PostGIS meets DuckDB: Crunchy Bridge for Analytics goes Spatial
We have just added spatial features to Crunchy Bridge for Analytics. Marco has all the details about how to get public or private data into PostGIS.
8 min readPostgreSQL Snapshots and Backups with pgBackRest in Kubernetes
Backups are out and snapshots are in! Brian breaks down everything you need to know for how to use pgBackRest with snapshots in a Kubernetes environment.
6 min readPostgres Materialized Views from Parquet in S3 with Zero ETL
Marco breaks down how to pull Parquet, JSON, and CSV files into Postgres with materialized views. This workflow can be used as a simple data pipeline from object store directly into Postgres for a variety of use cases.
4 min readUnderstanding the Postgres Hackers Mailing List Language
Greg analyzed a year's worth of email exchanges on the Postgres hackers email list. He's got a primer on all the lingo and abbreviations used to help you follow along.
9 min readAnnouncing an Open Source Monitoring Extension for Postgres with pgMonitor
Keith announces a new metrics extension that collects metrics for Postgres and is ready for future version of Postgres.
5 min readPostgres Powered by DuckDB: The Modern Data Stack in a Box
Marco reviews the challenges and strengths of analytical and transactional workloads and what a modern data stack that merges the two might look like.
12 min readPostgres Troubleshooting - DiskFull ERROR could not resize shared memory segment
Jesse has some tips if you see the dreaded full disk memory segment error. He goes through the most likely causes and fixes.
7 min readSix Degrees of Kevin Bacon - Postgres Style
Paul Ramsey has some great examples of Postgres network analysis and graph theory in this sample code for playing the Kevin Bacon game. Both pgRouting and recursive CTE are used to solve graphing relationships.
10 min readThin Provisioning with Crunchy Postgres for Kubernetes
Greg walks through how to deploy our operator with minimal storage and set up autogrow features to automatically expand storage as you need it.
4 min readQuery Hugging Face Datasets from Postgres
Crunchy Bridge for Analytics now lets you automatically connect your database with Hugging Face. Elizabeth walks through an example with the IMDB data.
Magic Tricks for Postgres psql: Settings, Presets, Echo, and Saved Queries
Elizabeth has a set of tips for making your psql environment easier to work with. Find out how to save queries, echo back psql commands, and some of the psql settings to make your environment friendlier.
Running TPC-H Queries on Iceberg Tables from PostgreSQL
Önder walks through how to run TPC-H queries for benchmarking data warehouse workloads against Iceberg tables using Crunchy Bridge for Analytics.
6 min readCrunchy Bridge Adds Iceberg to Postgres & Powerful Analytics Features
Query Iceberg tables, list all of your S3 files, connect to a Hugging Face training set, and more. Marco digs in with the details on our newest release of Crunchy Bridge for Analytics.
11 min readParallel Queries in Postgres
Elizabeth breaks down the basics of what you need to know for using parallel queries in Postgres.
Crunchy Data PostgreSQL 16 Security Technical Implementation Guide Released by DISA
Crunchy Data, together with the United States Defense Information Systems Agency (DISA), is pleased to release the newest STIG for Postgres including versions 13 through 16.
3 min readKubernetes Operator Meets Fully Managed Postgres
Andrew walks you through the new API that lets you deploy Crunchy Bridge resources from inside Crunchy Postgres for Kubernetes.
10 min readAnnouncing Crunchy Postgres for Kubernetes 5.6: New Features for Seamless Postgres Management
Version 5.6 of Crunchy Postgres for Kubernetes is out and Greg has an overview of highlights. Autogrow storage volumes, create passwords, connect to Crunchy Bridge, and more.
4 min read
