Craig Kerstiens - Finger lime evangelist @craigkerstiens Twitter profile

Pinned Tweet

Craig Kerstiens - Finger lime evangelist

9 months

Just gonna leave this here - Unfinished business with Postgres

7 years ago I left Heroku. Heroku has had a lot of discussion over the past weeks about its demise, whether it was a success or failure, and the current state. Much of this was prompted by the...

www.craigkerstiens.com

7

5

44

Last Seen Profiles

@ndcenzo

@exWvGF6S3l7199

@ltsbivy

@MALEFICA1973

@rayacrumbs

@ItsMeAshliB

@fantasi_emak

@hai_niinnnss

@Baddiekeish

@TomanTrad

@beyond_capital

@jokeonair

@nagaragroup

@EllieMcCormack6

@bokeplokalmalam

@meac_mike

@amarianabecker

@Dam_UL

@alsbr_bshayr

@_shah_rizal

@D_deeki

@Mbahmaryono77

@tadriuknow2

@dscott1_

@robknox_

@BBRich88

@owDiyaa

@Burrow43

@vkylogs

@BipedGame

@yaraaduaaa

@52_indian

@kuwait00660830

@ssaayaap

@BretPatton_4

@CleoMilon31399

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 months

Every time I've encountered a database without foreign key constraints and let the "app layer handle it" I've found data inconsistencies, every single time.

51

54

561

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Devs will do anything but learn SQL

39

37

439

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

Y'all this new JSON subscript syntax in Postgres 14 is sweet. Super excited to see Postgres just getting better bit by bit -

Better JSON in Postgres with PostgreSQL 14 | Crunchy Data Blog

A feature highlight of the new JSON subscript support within PostgreSQL 14.

www.crunchydata.com

7

104

410

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

And here it is, come join us @crunchydata and learn some Postgres at our playground -

Learn Postgres at the Playground | Crunchy Data Blog

Run Postgres in your local web browser with guided tutorials to help you grow your Postgres skills.

www.crunchydata.com

19

75

286

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

What you should do to preemptively help future performance on a new Postgres database? These tips will save the day for you when you need to investigate performance 🧵

5

49

273

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Talking with some folks about worry on scaling and how far Postgres can really go... benchmarked our $35 a month database plan pushing 5,000 transactions per second. That's 432,000,000 per day. When you see numbers X million or Y billion transactions, do the math. $35/mo 432m

12

29

230

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

This is so simple yet brilliant, if you want JSON/documents in a particular form here's a great post on how to let Postgres do the heavy lifting of returning it for you -

Cut Out the Middle Tier: Generating JSON Directly from Postgres | Crunchy Data Blog

PostgreSQL has built-in JSON generators that can be used to create structured JSON output right in the database, upping performance and radically simplifying web tiers.

www.crunchydata.com

6

42

195

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

8 months

An overview of distributed Postgres architectures

An Overview of Distributed PostgreSQL Architectures | Crunchy Data Blog

Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the...

www.crunchydata.com

2

47

179

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 years

SQL has been one of the most valuable skills I’ve picked up in my career, here are a few thoughts on why the return on investment of learning it is well worthwhile:

12

61

171

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 months

If you think SQL can't be readable... you probably haven't used CTEs (common table expressions) or "WITH" clauses to write SQL with composable blocks. CTEs and proper indentation and you SQL can start to look more like code and way less scary.

13

22

168

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Way back at Heroku we had this idea of team swaps/internships. You could swap teams for a short period of time to get a sense of their world of engineering. For a lot of engineering teams with similar toolsets this worked out pretty well.

6

5

142

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Postgres Container Apps: With a single command you can launch a container from inside Postgres -

Announcing Postgres Container Apps: Easy Deploy Postgres Apps | Crunchy Data Blog

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!

www.crunchydata.com

10

39

139

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Is Heroku in a good spot? No. If you can't appreciate what Heroku did for developer experience then you shouldn't be talking how you're creating a great developer experience. Respect your elders.

9

4

138

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

Excited to have joined @crunchydata to help build our their managed service offering, apparently the only thing I know how to do is run Postgres for people, at least it's Postgres though

11

6

132

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Unfinished Business with Postgres:

Unfinished Business with Postgres

7 years ago I left Heroku. Heroku has had a lot of discussion over the past weeks about its demise, whether it was a success or failure, and the current state. Much of this was prompted by the...

www.craigkerstiens.com

6

29

127

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Postgres is so underrated as a metrics/analytics database.

17

4

125

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Legit curious on peoples views, was Heroku a huge success or failure?

85

5

125

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

11 months

PgBouncer 1.21.0 - "The one with prepared statements" - this is absolutely huge

Release PgBouncer 1.21.0 - "The one with prepared statements" · pgbouncer/pgbouncer

2023-10-16 - PgBouncer 1.21.0 - "The one with prepared statements" Features Add support for protocol-level named prepared statements! This is probably one of the most requested fea...

github.com

1

36

124

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

I love the metrics of people "my app is scaling amazing because of shiny new serverless tech"... when the metrics are like 10k transactions in a day... And I'm just over here watching Postgres (a single server) push several 100k transactions per second.

5

12

122

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

It's easily 99% of all companies in the world 😏

13

5

118

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

Final day at Microsoft as part of the Azure Postgres team. I'd say lets catch up but well getting out not so much an option these days. Drop me a note would love to say hi virtually. Ready to unplug for a while for a good break and build quite a few lego sets.

8

1

116

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 months

ORMs aren't bad, but they do get over-used at times. Great for: Simple updates, CRUD operations, very simple aggregations, managing your migrations Mixed results on: Joins, subqueries Bad results: Generating reports Don't be afraid of jumping to SQL *when you need it*.

14

13

115

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

I work with Postgres daily and sometimes it still takes a bit for me to parse the output of an explain plan, this walkthrough is so handy if you're not a full time DBA in understanding a bit more about your Postgres query performance

Explaining Your Postgres Query Performance | Crunchy Data Blog

The EXPLAIN command helps you look even closer into an individual query. If you're already proficient in EXPLAIN, great! Read on for an easy refresher. If you're less familiar with it, this will be a...

www.crunchydata.com

2

17

111

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

Really excited to announce Crunchy Bridge - a modern Postgres as a service from @crunchydata There is a lot already in here and a lot more to come. Excited to make Postgres available and even more awesome for devs

Announcing Crunchy Bridge: A modern Postgres as a service | Crunchy Data Blog

Crunchy Bridge delivers on the premise of a managed database service allowing you to focus on your application not your database, but we go several steps further.

www.crunchydata.com

13

32

114

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 years

Been a good journey and still plenty more to do, looking forward to this next chapter with Microsoft -

22

5

111

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 month

Conversation with a VC last night... VC: Oh, you know some about Postgres Me: Yep VC: I was at LinkedIn way back, we bet on MySQL Me: Not crazy for that time VC: Postgres really came out of nowhere in last few years, any thoughts on how that happened? Me: How much time you got?

15

3

113

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 years

Funny thing is if you learned SQL 15 years ago it’s just as valuable today, that’s rare for a programming lang to retain that kind of value

6

56

108

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

If I were a VC or PE I'd be pulling together some money to see if I could buy Heroku off Salesforce. It still solves a problem that nothing else has come close to at that scale. (Lots of earlier smaller players, but if you want to place a big bet it would be a good one)

10

8

110

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

25 days

The number one cause of production database outages I see these day is because of CDC tools. Generally the lifecycle of a tech company goes something like: We start building an app and choose Postgres (duh.) Fast forward a little and "we need to get insights to the business".

16

17

103

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

5 years

Give me back my monolith:

6

38

99

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

Said it before, but (cause people) feel like I need to say it again... the make money stack: Rails/Django and Postgres Throw in tailwind for design for good measure It just works. You can build a really good business that way.

7

98

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 months

Code is easy. People are hard.

6

16

98

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Postgres JSON just keeps getting better and better -

JSON Updates in Postgres 16 | Crunchy Data Blog

Chris digs into some example code for the new JSON features that just launched with Postgres 16 last week. A new check for finding json objects and some new object and array functions.

www.crunchydata.com

0

11

95

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 years

Welcome to the newest member of the family

45

0

95

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

11 months

Pgbouncer getting prepared statement support may be the biggest thing for Postgres since JSONB support

2

3

89

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 months

Did you know you can name/save queries in your psqlrc that are common database tasks? Inside your psqlrc: \set long_running 'SELECT pid, now() - pg_stat_activity.xact_start AS duration, query, state FROM pg_stat_activity WHERE (now() - pg_stat_activity.xact_start) > interval ''5

2

22

89

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

pg_stat_statements - easily most useful Postgres extension that exists. Without becoming an expert in Postgres you can still get a sense of how queries perform and what to optimize -

Query Optimization in Postgres with pg_stat_statements | Crunchy Data Blog

I want to work on optimizing all my queries all day long because it will definitely be worth the time and effort. That's a statement that has hopefully never been said. So when it comes to query...

www.crunchydata.com

1

19

85

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

5 years

Repeat after me: New shiny tech/framework does not magically solve all the problems from yesterday, it is more likely a layer of abstraction and complexity. Boring tech is great for building real businesses.

4

19

82

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

IOPS are a thing that baffle a ton of folks, providing massive IOPS out of the box for all Bridge customers has been one of the single biggest performance wins our customers see in migrating to us. Here we breakdown IOPS and what it means for your DB -

Understanding Postgres IOPS: Why They Matter Even When Everything Fits in Cache | Crunchy Data Blog

John gives us the basics of i/o in Postgres from how it works, to what parts of the database use IOPS, how to measure it, and what to do to optimize it. John also explains new view for pg_stat_io...

www.crunchydata.com

2

21

84

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

When did Postgres become cool?

When Did Postgres Become Cool? | Crunchy Data Blog

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.

www.crunchydata.com

11

22

83

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 months

What you should do to preemptively help future performance on a new Postgres database? These tips will save the day for you when you need to investigate performance, spend 5 minutes now and get your database production ready. 1. Install pg_stat_statements, no matter what it'll

5

14

84

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 months

How we fused DuckDB together with Postgres -

How We Fused DuckDB into Postgres with Crunchy Bridge for Analytics | Crunchy Data Blog

Marco reveals some of the components behind Crunchy Bridge for Analytics, which extends PostgreSQL for high performance analytics workloads using DuckDB.

www.crunchydata.com

1

17

82

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 years

Also we couldn’t have gotten this far without Postgres and the community itself so especially excited for this to have been a thing -

4

19

81

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Super excited for this, lower entry @crunchydata plans starting at $10 a month for an awesome Postgres experience -

Making Postgres More Affordable - New Low Cost Plans on Crunchy Bridge | Crunchy Data Blog

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.

www.crunchydata.com

3

22

81

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Just heard from a customer that migrated to us from Aurora because they were having connection management and scaling issues on it. What solved their problems? Vanilla Postgres. You probably don't need Amazon or Google scale, you just need Postgres.

2

9

77

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Just Postgres.

4

11

76

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

10 months

Few Postgres psql config recommendations (set in your .psqlrc in your home directory): \set QUIET 1 \pset null '👻' \x auto \timing \set HISTFILE ~/.psql_history- :DBNAME \set HISTCONTROL ignoredups \set COMP_KEYWORD_CASE upper \unset QUIET

3

13

76

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 months

Tech is a very small world, treat people well, do good work. The game is a lot longer than you think and you'll reap benefits for doing the right thing or pay the price for taking shortcuts.

6

10

75

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

5 years

It is well known I’m a psql guy personally, but super excited to see @Microsoft bringing some of their expertise of graphical editors to the @PostgreSQL community -

4

25

74

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

7 years

Wow, quite the response from people about Postgres’ hidden gems:

Postgres hidden gems

Postgres has a rich set of features, even when working everyday with it you may not discover all it has to offer. In hopes of learning some new features that I didn’t know about myself as well as...

www.craigkerstiens.com

6

33

74

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 months

Devs enforcing constants at the app layer and not the database

4

10

74

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

If you're on Heroku: Rotate all config var creds. Change password. Rotate API Key and 2FA. Audit as much as you can of Heroku releases and deploys. It's not gonna be fun, but do it.

1

31

72

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Have a cousin in college that took a DB course, they just shared their slides and lab exercises with me. No wonder devs hate databases and SQL, we can do so much better on educational content. Anyone have favorites for learning SQL/DBs?

28

10

69

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

23 days

Postgres for analytics has always been a huge question mark. By using PostgreSQL's extension APIs, integrating DuckDB as a query engine for state-of-the-art analytics performance without forking either project could Postgres be the analytics database too? Bringing an analytical

4

9

70

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

@coryodaniel

2

9

69

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Feels like we're breaking every rule of "don't do this with Postgres" @crunchydata and it's working out just fine. Using it for analytics/metrics✅ Storing logs in it ✅ Launching docker containers from inside it ✅ Running with pl/python ✅

7

9

69

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

7 months

Announcing Postgres Insights in Your CLI 💥

Crunchy Bridge: Announcing Postgres Insights in Your CLI | Crunchy Data Blog

Craig announces a suite of useful queries for Postgres in our command line tool. Quickly find cache hit ratio, table sizes, locks, long running queries, indexes, and more in the new query menu for...

www.crunchydata.com

1

8

68

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Ingesting 50m events per day, on a $190 a month database, providing dashboards and reports ranging in response time from 1-2ms up to 100ms all depending on the range and amount of data reported back, here's how. Along with future optimizations -

Building Customer-Facing Real-Time Dashboards with Postgres | Crunchy Data Blog

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.

www.crunchydata.com

2

13

68

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

This breakdown of subqueries, materialized views, CTEs, window functions and lateral is amazing!

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.

www.crunchydata.com

1

11

66

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

This blog post on full text search in Postgres had me nodding from the start -

Postgres Full-Text Search: A Search Engine in a Database | Crunchy Data Blog

With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try,...

www.crunchydata.com

4

13

66

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Postgres 16 has a new feature count of 200! For a "boring old database" that "just works", 200 new features in a release.

E.5. Release 16

E.5. Release 16 # E.5.1. Overview E.5.2. Migration to Version 16 E.5.3. Changes E.5.4. Acknowledgments Release date: 2023-09-14 E.5.1. Overview # PostgreSQL 16 …

www.postgresql.org

2

12

66

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Pro-tip #PostgreSQL tip, trying to use psql more, but still missing a richer editor when writing SQL? Set your $EDITOR or $PSQL_EDITOR to the editor of your choice. Then use \e to open the last executed SQL in that editor, close and save, it'll execute the query.

4

13

65

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

To recap: ✅ pg_stat_statments ✅ log queries over 100ms ✅ log explain plan of queries over 100ms ✅ auto-kill queries over 30s And your Postgres will be 💯

2

7

66

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

Happy Postgres 14 release day (). Excited to already have it officially supported on Crunchy Bridge (). If you want to get your hands dirty with PG 14 feel free to create and account and give it a spin.

Crunchy Bridge - Managed, Cloud Postgres

Cloud-hosted, fully-managed Postgres on AWS, GCP, Azure, or Heroku. Customize performance based on your needs. If you have questions, our support team are Postgres experts.

www.crunchydata.com

2

13

65

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 months

RIP Heroku Postgres

8

3

64

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

21 days

For as powerful as it is, SQL isn't exactly a user friendly language to work in. Debugging SQL can be slow and painful. But, you can write more legible SQL by taking advantage of one of the least used functionalities: CTEs (Common Table Expressions). CTEs are essentially a

3

14

64

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

@isamlambert Yeah, just needs dark mode

2

0

63

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

Tell me you’re a Postgres fan without telling me you’re a Postgres fan

84

3

61

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Working on something fun for @crunchydata website update that I think will be one of the most useful Postgres resources in a single place over past 10 years. Few weeks off, but this should be fun to get out the door. 🔥

3

8

59

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

There are lot of interesting trends in the data space lately, here’s just a few that are going to displace relational databases a 🧵

8

5

59

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Excited to announce @Tailscale integration for @crunchydata with Crunchy Bridge today!

Postgres + Tailscale – A database you can trust with a simple VPN | Crunchy Data Blog

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.

www.crunchydata.com

4

11

58

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

1/ In every startup I've ever encountered the most challenging thing is focus. The first step is to understand what you're building, what your model is, and then how you sell it. Once you do that perfect it.

2

4

58

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

I frequently get on calls with folks wondering how their Postgres database is doing, this is the playbook I run through in 10-15 minutes for how healthy things are and finding low hanging fruit -

Cleaning Up Your Postgres Database | Crunchy Data Blog

Actionable steps on how to improve your Postgres database performance.

www.crunchydata.com

2

13

59

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

My tweet on what could be improved in Postgres got way more response than I anticipated. While I agree with a ton of it, feels worth laying out Postgres is awesome, so here goes:

6

16

57

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Are you even a Postgres DBA if you can't directly read WAL?

Postgres WAL Files and Sequence Numbers | Crunchy Data Blog

Go inside the WAL file with this in-depth look at WAL file Log Sequence Number (LSN), WAL segment positions, WAL file names, and pg_switch_wal.

www.crunchydata.com

1

4

57

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

One of the biggest features that we were wrong about at Heroku Postgres was dataclips. It was the vision of a single person that pushed it through against all the collective teams opinion.

8

5

57

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 months

Beyond excited to announce the release of Crunchy Bridge for Analytics–easily working with your data lake. You get the Crunchy Bridge experience plus * Seamless S3 integration * Easily query CSV/Parquet data * Vectorized query execution All in Postgres -

Crunchy Bridge for Analytics: Your Data Lake in PostgreSQL | Crunchy Data Blog

Today Crunchy Data announces a new analytics engine to read cloud object storage files like CSV, JSON, and Parquet with Postgres.

www.crunchydata.com

3

12

56

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

I have failed as a parent... My daughter just now: Jedi's don't have powers they just use lightsabers I'm taking tomorrow off and my kid is gonna be out sick, we're starting at episode 4 at 7am...

2

0

55

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

4 years

I bet most folks didn't even know there has been an entire machine learning extension () for Postgres for 10 years now... Why? Because none of the providers of Postgres have supported it... Changing that starting today -

Announcing Crunchy Bridge: A modern Postgres as a service | Crunchy Data Blog

Crunchy Bridge delivers on the premise of a managed database service allowing you to focus on your application not your database, but we go several steps further.

www.crunchydata.com

3

16

53

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

8 months

1

3

55

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

🧵 on all the terrible things about Postgres:

10

8

54

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

7 years

This looks really interesting: Dexter - automatic indexing for Postgres

Introducing Dexter, the Automatic Indexer for Postgres

Your database knows which queries are running. It also has a pretty good idea of which indexes are best for a given query. And since…

medium.com

0

35

53

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Want advice to help your team ship as an engineering manager? Here's your cheatsheet, every one of these is pure gold -

engineering-management-tricks.md

GitHub Gist: instantly share code, notes, and snippets.

gist.github.com

0

7

52

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

9 years

End of an era, final day at @heroku

25

2

52

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

8 months

Me when someone says Postgres

2

52

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 months

Back at Heroku when we built dataclips most of the Heroku Postgres team was against it and thought it was a terrible idea. One person on the team pushed it through. The rest of the team was wrong, it turned out to be brilliant, like github gist for your data–against a live

5

3

53

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

3 years

Thinking about my angel investment thesis... tempted to go with I invest in the make money stack "Rails/Django, Postgres/MySQL, Heroku, GitHub" If you're building on this you've just increased your chances of success 10-fold

5

53

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Postgres 15 available available on @crunchydata about 5 hours after the community release.

3

9

53

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Postgres 16 lays the groundwork for a lot of interesting things, namely much closer to supporting active-active natively in Postgres -

Active Active in Postgres 16 | Crunchy Data Blog

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...

www.crunchydata.com

3

12

53

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

10 months

Lots of talk with customers lately about multi-tenant database design patterns, took a few minutes to highlight the approaches with a special guest star of Citus -

Designing Your Postgres Database for Multi-tenancy | Crunchy Data Blog

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.

www.crunchydata.com

2

5

51

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Lots of backchannel talk on @heroku . Many of us don't want to speak out when things happen, incidents happen, it sucks. But let them manage it and root for them. But a lot of us feeling strong sense of responsibility to what we once built because the comms/response not okay.

1

51

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

It's at least once a week I talk with someone that "loves Postgres" but isn't sure why... which evolves into me ranting for 2 minutes on all the awesome features. In hopes sharing a little broadly here it goes 🧵

4

7

51

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 months

Gonna pour one out for Simon tonight, had a huge impact over a very long committed period to Postgres -

Remembering Simon Riggs

The PostgreSQL Core Team is deeply saddened by the loss of our long-time friend and colleague Simon Riggs on the …

www.postgresql.org

2

7

51

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

A launch is distinct from shipping. You can ship any time, launches are coordinated. You can launch after you ship.

3

8

51

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

11 months

In case you missed it, PgBouncer got support for prepared statements - This is huge!

Prepared Statements in Transaction Mode for PgBouncer | Crunchy Data Blog

The newest version of PgBouncer lets you run prepared statements while using a connection pooler. Greg breaks down the performance gains of prepared statements, why they have traditionally been a...

www.crunchydata.com

4

6

51

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

7 years

Always a good idea to periodically check your bloat of your Postgres database, here’s a query to help:

3

16

51

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

0

6

50

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

6 months

Want a tip as a early in your career developer, learn SQL. You'll have this mysterious super power that most others on your team don't comprehend.

2

5

48

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

2 years

Exposing Postgres Performance Secrets 👀

Exposing Postgres Performance Secrets | Crunchy Data Blog

Craig lays out four basic things to set up today to make finding and fixing performance faster in the future.

www.crunchydata.com

3

18

48

Craig Kerstiens - Finger lime evangelist

@craigkerstiens

1 year

Having a lot of conversations with folks lately "can Postgres be used for metrics/analytics?" Short answer is yes. Some deeper blog posts coming, but we dogfood our own stuff @crunchydata and just checked... we're handling 50m events daily currently for Crunchy Bridge.

4

5

48