Latest posts
Postgres Postmaster File Explained
Greg explains what is inside the postmaster file and why it matters. He also references each part of the postmaster file to the Postgres source code.
6 min readCitus for Postgres on Any Cloud: Announcing Citus Support for Crunchy Bridge
We are now supporting Citus on Crunchy Bridge. Craig walks through how to set it up and what to know before you get started.
3 min readAn Overview of Distributed PostgreSQL Architectures
Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the pros and cons of each approach.
16 min readPostgres TOAST: The Greatest Thing Since Sliced Bread?
Elizabeth gives us an overview of the Postgres TOAST (The Oversized Attribute Storage Technique) system and what it means for your data types and storage.
Using acts_as_tenant for Multi-tenant Postgres with Rails
Chris walks through using the acts_as_tenant gem. He shows some example code to get started with this gem, how to migrate, and other tips for working with B2B or multi-tenant applications.
6 min readPostGIS Clustering with DBSCAN
Paul walks through creating cluster maps with ST_ClusterDBScan. He grabs some geographic name data, creates the clustered data, and retrieves a population density map for the U.S.
4 min readThe Postgres Playground: BYOS (Bring Your Own SQL)
Craig has tips for using our Postgres playground with your own SQL.
2 min readpgAdmin for All of Your Postgres Kubernetes Clusters
We just released version 5.5 of Crunchy Postgres for Kubernetes and have a new pgAdmin experience. Now you can run all of your Postgres clusters in one interface across your Kubernetes fleet. We have a really cool way to manage this and it includes automatic new cluster detection.
8 min readUse Github Actions on Pull Requests to Automate Postgres on Crunchy Bridge
Automate Postgres with your review apps! Chris offers up some sample code for GitHub actions and getting a test Postgres database created, getting the connection string to your review app, and closing it down.
6 min readPostGIS Day 2023 Summary
Highlights and notes from this year's PostGIS day talks including the ideal GIS stack, PostGIS for emergency services, MobilityDB, and PostGIS functions for Star Wars.
Announcing Crunchy Postgres for Kubernetes 5.5
Version 5.5 of Crunchy Postgres for Kubernetes is out and Andrew has an overview of highlights. We have a really cool new pgAdmin set up, streamlined metrics features, updated pgBouncer and more.
5 min readAdvent of Code in PostgreSQL: Tips and Tricks from 2022
Thinking about solving the Advent of Code in Postgres? I did it last year and I have summary of how to get started and some tips and tricks for writing your own solutions.
8 min readFun with Postgres ASCII Map and Cardinal Directions
Greg has more solutions to the last Advent of Code, this is day 23. Here he takes an ASCII map of dots and hashes and looks for free spaces with cardinal directions. Some fun SQL in here with table rebuilds and ANSI color charts all inside plain PostgreSQL.
25 min readFun with Postgres Text File Mazes, Charts, and Routes
Greg has more solutions to the last Advent of Code. He takes the text input file and solves the puzzle by charting a route through a maze. With some cool settings, these animations run inside psql.
21 min readFun with Postgres Looped Functions and Linear Progressions
More Advent of Code solutions in PostgreSQL, this is day 21. Greg separates out the monkey speak and creates looped functions to predict what they're saying. For bonus points, Greg shows off the new friendly big number inputs in Postgres 16 that use a format like BIGINT = 1_000_000_000.
8 min readPostgres + Citus + Partman, Your IoT Database
Craig digs into the architecture behind a slick IoT data platform including Postgres, the Citus extension, and pg_partman partitioning. Add these together with columnar compression and you've got a fully open source and scalable IoT data stack.
8 min readDesigning Your Postgres Database for Multi-tenancy
Craig digs into multitenancy applications, sharding, and the Citus extension. He gives several approaches to the data design so that you're ready to scale if and when that time comes.
6 min readFun with Postgres Floats, Positioning, and Sequencing
Greg continues to amaze us with solutions to the 2022 Advent of Code, this is day 20. Using only PostgreSQL he decrypts data, gets it sequenced, and gets back on his journey to meet up with the Elves.
11 min readRuby on Rails Neighbor Gem for AI Embeddings
Thinking about using pgvector to power some AI data in your Rails app? Chris walks through the very handy Neighbor gem and how it helps for vector data types and ActiveRecord.
3 min readTuple shuffling: Postgres CTEs for Moving and Deleting Table Data
David has some tricks and sample code for using CTEs to manipulate data and move things around inside your database. This can be especially handy for sorting, moving, or labeling data and moving it to an archive.
5 min read
