Active Active in Postgres 16

Postgres 16 is out and it has some exciting updates to logical replication. Using a new WAL origin filter, you can avoid loopback transactions. Brian lays out the updates and how to get started with an active active cluster.

When Did Postgres Become Cool?

Craig takes a look at the history of Postgres. From the origins of the project through some of the key production features that make Postgres what it is today.

PostGIS Day is Nov 16th, Call for Papers and Registration Open

PostGIS Day serves to highlight the features and uses of the PostGIS spatial database as a part of the GIS ecosystem. Join us for a full day of talks about open-source Geospatial applications and tools.

Top 10 Postgres Management Tasks

The must know Postgres management tasks to look at for any scale. Plus a bonus image included showing the recent and upcoming Postgres release schedule.

Fun with PostgreSQL Puzzles: Recursive Functions with Animations

Greg continues with Advent of Code series in Postgres with puzzle 19. This one uses recursive functions to follow blueprints and return the results.

Postgres Subquery Powertools: CTEs, Materialized Views, Window Functions, and LATERAL Join

Wondering when to use a Materialized View or a CTE? Elizabeth has summaries, example queries, and comparisons for the most popular subquery tools.

Use CI/CD to Automatically Update Postgres Images with Argo CD

Bob continues his series on using Argo CD to create GitOps workflows with Crunchy PostgreSQL for Kubernetes. In this post, he shows you how to create automated image updates.

Scaling Vector Data with Postgres

pgvector for AI in Postgres catch your eye? Start thinking about scaling and performance now. Chris has some tips about partitioning and truncating data to strike that perfect balance between performance and accuracy.

HNSW Indexes with Postgres and pgvector

pgvector for Postgres recently got a big upgrade with the new HNSW indexes. Chris explains what they are, how to use them, and what the accuracy and performance implications are for adding these.

Random Geometry Generation with PostGIS

Did you know you can use random() with spatial data types? Paul has sample code for generating random points, lines, polygons, hulls, and even some shapes using a Voronoi diagram. 

banner

Upcoming events

Crunchy Data is exciting to be sponsoring the following upcoming events: 

Rails World, Amsterdam, Oct 5

FOSS4G NA, Baltimore, Oct 23

Red Hat Summit: Connect London, Nov 7

Red Hat Government Symposium, Washington D.C., Nov 15

Red Hat Summit: Connect Darmstadt, Nov 30

PGConf EU,  Prague, Dec 12 

Red Hat Summit: Connect Zurich, Jan 17

Crunchy Data | 843-737-6045 | crunchydata.com

unsubscribe manage preferences