Latest posts from Craig Kerstiens
Citus for Postgres on Any Cloud: Announcing Citus Support for Crunchy Bridge
We are now supporting Citus on Crunchy Bridge. Craig walks through how to set it up and what to know before you get started.
3 min readThe Postgres Playground: BYOS (Bring Your Own SQL)
Craig has tips for using our Postgres playground with your own SQL.
2 min readPostgres + Citus + Partman, Your IoT Database
Craig digs into the architecture behind a slick IoT data platform including Postgres, the Citus extension, and pg_partman partitioning. Add these together with columnar compression and you've got a fully open source and scalable IoT data stack.
8 min readDesigning Your Postgres Database for Multi-tenancy
Craig digs into multitenancy applications, sharding, and the Citus extension. He gives several approaches to the data design so that you're ready to scale if and when that time comes.
6 min readWhen 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 read
