Craig Kerstiens

Just gonna leave this here - Unfinished business with Postgres craigkerstiens.com/2022/05/18/unf…

The total cost of shipping something is key to keep in mind. This is most obvious when focusing on team local estimates. "It's easy for my team" often misses the other pieces, sales, marketing, support, operations. Effort should always be viewed in aggregate over long term.

It's always rewarding when the very first giphy comes out perfect

When one of your meetings starts off with a 10 minute detour of the tiki mugs in the background because they were at the exact same place a few weeks ago it's gonna be a good friday.

Giving a conference talk in a few weeks. Considering going with 0 slides and spending the whole time in SQL. I did this nearly 10 years ago but it's been a while. First time was terrifying, this time feels like it could be fun.

One of the best sales leaders I've every worked with taught me the idea of "get to no as fast as possible" In other words, don't try to make everything work. Identify the hard blockers on while a deal is dead from the outset. Don't hand waive, don't try to get to well...…

My focus from day one was production ready Postgres out of the box with @crunchydata. We started on production ready, then layered on an amazing developer experience. Often when you start on the developer experience and try to build into enterprise readiness you have a bumpy…

Uh oh ... CPU is at 100% ... what happened? Did an analyst write a recursive CTE and forget to put a limit on it? Eeek .... something is running and we need to get it stopped. Let’s get into Postgres, find, and kill a runaway transaction. Let's start with looking at Postgres'…

The hardest part of focus isn't picking what to do. It's sticking with it when the shiny stuff starts knocking.

Good engineers chase edge cases. Great ones ask - Do we even need this feature?

Excited to be celebrating the 4th where the first Americans finished their journey across the country near Donner Pass

No system hits the sweet spot of allowing for extensibility while maintaining systems safety. It would be nice if there was a standard plugin API (think POSIX) that allows compatibility across systems. Thanks to @marcoslot + @dave_andersen for their collaboration on this project

.@abigale_kim's paper is unleashed! It's the most complete eval of DB extensions/plugins. We analyze @PostgreSQL, @MySQL, @mariadb , SQLite, @duckdb, @Redis. TLDR: Postgres ecosystem is fraught w/ footguns. Other DBMSs have fewer extns but less problems. DuckDB has cleanest API.

When in a meeting and we're 15 minutes in and seems to just be going around in circles, chime in: "What problem are we trying to solve?"

Someone in the neighborhood was walking by and said they're ready for the hearse to come out (referring to halloween decor, we may not even wait til August this year)

When in doubt focus on the best experience for the user.

generate_series within Postgres is incredibly handy for creating a series of data within Postgres. It's common for generating fake/test data, but can also be used for practical purposes like creating buckets for charts - when you have missing data. Let's dig into an example...…

Was planning on a weekend in the mountains with some pool time for the kids, don’t think the pool is happening

Less than two weeks ago @crunchydata was acquired by @Snowflake. Having been through this before it's always a lot to process. But less than two weeks in and I'm more bullish and optimistic than perhaps any point ever in my career. The amazing enthusiasm from the teams and the…

If you ask long-time Postgres users about their favorite features, you'll almost always hear about Common Table Expressions (CTEs). CTEs both let you do really complex operations and table changes and with the added benefit of being easy to read and simple SQL. CTEs are great…

The biggest thing I've learned watching all of our contact me submissions over the years is how many office cleaning companies exist in the world.