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.
Use some of the newest AI tools for Postgres! Craig shows you how to use ChatGPT for schema creation, data creation, query writing, indexing and more.
A primer on working with time in Postgres. Covers data types, query formats, intervals, overlaps, range types, indexing, and roll ups.
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.
Craig gives us an introduction to working with Postgres in expanded contexts like analytics, metrics, log storage, and event data.
Chris has some tips for working with Ruby on Rails and ActiveRecord and using better SQL to improve performance and avoid N+1 queries.
Chris has some sample code for synching data from Postgres to MongoDB using Foreign Data Wrappers and Triggers.
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.
New in Postgres 15, sequences can be unlogged. Greg reviews unlogged sequences and provides some details about using them.
To continue to provide developers with the best Postgres experience, Crunchy Bridge now offers easy connectivity between managed Postgres and MongoDB.
Craig gets you ready for production with this quick checklist of Postgres essentials.
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.
A high level overview of the backup options in Postgres. Including pg_dump, pg_basebackup, and pgBackRest.
Integer overflow can happen if you have a sequencing data type exceeding integer limits. Jesse has a query to help you spot it and recommendations for a short term and long term fix.
Jacob walks you through the steps on how to set up a geocoder with the US census geocoding API inside your database with a plpython function and triggers.
Paul takes us through how rasters are stored and queried in Postgres/PostGIS. He gives us the must have tips for dealing with rasters inside a database using digital elevation mode (DEM) examples.
Chris is cooking up some examples for us on how to use AI inside Postgres. We have a simple demo of using pgvector and Open AI to grab relationships and query for other similar items.
Unlogged tables in Postgres can give you a big performance improvement but beware of the drawbacks. Here are some tips on how to safely give it a try.