pgBackRest has some new features that allow you to bundle files in your backup repo and do a block incremental storage. These can really help with storage efficiency and performance. David has some sample code to help you get started.
CI/CD tools can help you deploy, test, and promote databases. Bob has a sample set up of using ArgoCD with Crunchy Postgres for Kubernetes. He even provides a really nice sidecar testing container for you to use.
Hyperloglog is a Postgres extension for doing high-compression storage and query approximations. Chris shows you how to get started building a metrics system inside your Postgres database while saving on storage space and query time.
Postgres 16 is in beta and we are all excited about the updated logical decoding features. You heard that right, you can now do logical replication from a non-primary database! Roberto takes us through an example setup for this.
We are excited to announce a new set of functions to generate svgs from Postgres and PostGIS! This gives you really easy maps, images, or charts directly from your database. Once you start reading through these samples, you'll want to start playing with images from your database.
Are you using tags in your database with some of your main database properties? Paul reviews some of the ways to store tags in a database from basic relational models to text arrays. He provides some performance tests, sample queries, and guidance on choosing the best path.
When was this table created? Greg dives into the 5 places where you can get information about Postgres object creation.
Postgres can be a great back end to powering your customer-facing analytics. Craig gives an overview of getting started with a metrics schema and then powering up to performance.
AI has exploded the amount of vector data being generated. Getting performance can be uncertain, until you know the keys. Chris explains the 3 basics you need to get performance out of vector data with Postgres.
Chris has some tips for working with Ruby on Rails and ActiveRecord and using better SQL to improve performance and avoid N+1 queries.
Greg is still working on some of the puzzles in the Advent of Code series. In this one he tackles some routes, shortest paths, and cost. These are great sample PostgreSQL functions withs some bonus tips on using pg_stat_user_functions to look at recursion.
Paul has some fast and easy tricks to show you how to get time series data into nice reportable data charts. Using functions like floor(), generate_series(), width_bucket(), and date_bin() you can bin your data in groups any way you like and retrieve charts in a flash.