Brian steps through reviewing WAL history files and a sample recovery scenario.
Greg debugs Postgres that is not starting and there are no logs, no pg_ctl start up file, and no output anywhere.
Craig announces a suite of useful queries for Postgres in our command line tool. Quickly find cache hit ratio, table sizes, locks, long running queries, indexes, and more in the new query menu for Crunchy Bridge.
Postgres data delivered straight into Google Sheets! Walk through using pg_featureserv to create JSON and pg_svg to create accompanying SVG images directly from your database and into spreadsheets.
One process can lock your Postgres database, dominating all will, blocking other processes and queries. Jesse shows you how to find that one process that’s ruling them all. Once you’ve grabbed this lock and held it close to your chest, he’ll help you on your quest to cast it into the depths of Mt Doom.
We are now supporting Citus on Crunchy Bridge. Craig walks through how to set it up and what to know before you get started.
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.
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.
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.
Craig has tips for using our Postgres playground with your own SQL.
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.
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.
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.
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.