Latest posts from Craig Kerstiens
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.
10 min readIntroducing Database Insights: Effortless Postgres Management with Crunchy Bridge
Crunchy Bridge now has database insights to keep track of key performance indicators for your Postgres database. From database tools like slow queries and cache hit ratio, to machine stats like CPU and IOPS, and a production check. We are making database management easier than ever.
2 min readAnnouncing Crunchy Postgres for Kubernetes 5.4
We are excited to release version 5.4 of Crunchy Postgres for Kubernetes with support for ARM processors, pgvector, huge pages, Postgres tablespaces, and more.
5 min readPractical AI with Postgres
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.
9 min readBuilding Customer-Facing Real-Time Dashboards with Postgres
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.
5 min readThinking Fast vs. Slow with Your Data in Postgres
Craig gives us an introduction to working with Postgres in expanded contexts like analytics, metrics, log storage, and event data.
4 min readIs your Postgres ready for production?
Craig gets you ready for production with this quick checklist of Postgres essentials.
5 min readExposing Postgres Performance Secrets
Craig lays out four basic things to set up today to make finding and fixing performance faster in the future.
3 min readUsing Postgres FILTER
Craig dives into using FILTER and shows a query example using CTEs, CASE WHEN, and FILTER.
5 min readWill Postgres Use My Index? Hypothetical Indexing for Postgres
HypoPG is an extension to create hypothetical indexes and test if Postgres will use them. We think this tool is a good one to use in combination with our other favorites like EXPLAIN and pg_stat_statements.
3 min readPostgres + Tailscale – A database you can trust with a simple VPN
We are excited to announce that Crunchy Bridge has integrated with Tailscale to provide easy and secure access to your database from any of your devices.
3 min readEnums vs Check Constraints in Postgres
Enums or check constraints, which one is better? Craig breaks down why enumerated types aren’t common in Postgres.
3 min readSecurity and Team Management in Crunchy Bridge
Crunchy Bridge has a suite of features for managing teams, auditing team actions, data isolation, and single sign on. Read on about our approach to data safety and team management.
5 min readPostgres Databases and Schemas
Instances, database, and schemas are all ways to talk about your database. We have a deep dive into understanding these core fundamentals and what they really mean.
5 min readMaking Postgres More Affordable - New Low Cost Plans on Crunchy Bridge
We’re excited to announce our new hobby plans. Postgres instances now start at $10 per month. No charges for $5 or less a month. Get started on Crunchy Bridge today.
3 min readFun With Postgres Functions
Craig has pulled out some of his favorite functions from the Postgres toybox. He shows off date functions, aggregations, text functions, and math.
5 min readLearn Postgres at the Playground
Run Postgres in your local web browser with guided tutorials to help you grow your Postgres skills.
3 min read
Announcing Postgres Container Apps: Easy Deploy Postgres Apps
With Postgres Container Apps you can, from directly inside Postgres with a simple function call, spin up a container that is running right alongside your Postgres database!
6 min readFive Tips For a Healthier Postgres Database in the New Year
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
5 min read
Fully Managed Postgres for Kubernetes with Crunchy Bridge
Crunchy Bridge can now be deployed through the new Red Hat OpenShift Database Access (RHODA).
3 min read
