Articles by craigkerstiens
34

How We Pushed CDC into Postgres (snowflake.com)

3

Count(distinct) Is Too Slow: Approximations and Sampling in Postgres (snowflake.com)

5

Things I would have done differently (consulting) (revsys.com)

4

How We Pushed CDC into Postgres (snowflake.com)

3

PostgreSQL Extension Catalog (pgext.cloud)

2

How We Pushed CDC into Postgres (snowflake.com)

5

The four horsemen behind Postgres outages (malisper.me)

3

How to Read Postgres Explain: A Guide to Scan Types (crunchydata.com)

3

Understanding Postgres 19 Property Graphs (neovintage.org)

2

Looking Ahead to Postgres 19 (snowflake.com)

3

Looking Ahead to Postgres 19 (snowflake.com)

2

Postgres Scan Types in Explain Plans (crunchydata.com)

2

Do You Need to Tune Postgres Vacuum? (snowflake.com)

1

Postgres Time Series (Open Source) Stack with Iceberg (snowflake.com)

5

Building a High-Performance Postgres Time Series Stack with Iceberg (snowflake.com)

1

Postgres Jsonb Columns and Toast: A Performance Guide (snowflake.com)

1

Postgres Scan Types (crunchydata.com)

1

Why Everyone Loves Japan (noahpinion.blog)

2

Snowflake Postgres Is Now Available in Public Preview (snowflake.com)

2

Snowflake Postgres Is Now Available in Public Preview (snowflake.com)

3

Postgres Internals Hiding in Plain Sight (crunchydata.com)

4

Postgres 18: Old and New Rows in the Returning Clause (crunchydata.com)

3

What's Coming in Postgres 18 (crunchydata.com)

1

What's Coming in Postgres 18 (crunchydata.com)

5

Get Excited About Postgres 18 (crunchydata.com)

4

I made Xcode's tests 60 times faster (searls.co)

1

My Heroku Values (2015) (brandur.org)

1

Archive Postgres Partitions to Iceberg (crunchydata.com)

1

Who do you want to be? (kyledaigle.com)

1

Hacking the Postgres Statistics Tables for Faster Queries (crunchydata.com)

1

Logical Replication from Postgres to Iceberg (crunchydata.com)

4

Pg_parquet v0.4.0: Google Cloud Storage, HTTPS storage, and more (crunchydata.com)

4

Another look into PostgreSQL CTE materialization and non-idempotent subqueries (shayon.dev)

1

Logical Replication from Postgres to Iceberg (crunchydata.com)

3

Logical Replication from Postgres to Iceberg (crunchydata.com)

4

Hacking the Postgres Statistics Tables for Faster Queries (crunchydata.com)

2

Hacking the Postgres Statistics Tables for Faster Queries (crunchydata.com)

1

Creating Histograms with Postgres (crunchydata.com)

1

Papercuts: The little fixes that made a big difference at GitHub (kathykorevec.substack.com)

9

An Argument for Logging Off (aaronfrancis.com)

2

Your Product Should Be Shiny. Your Stack Should Be Boring (judoscale.com)

1

Reducing Cloud Spend: Migrating Logs from CloudWatch to Iceberg with Postgres (crunchydata.com)

1

Reducing Cloud Spend: Migrating Logs from CloudWatch to Iceberg with Postgres (crunchydata.com)

2

Automatic Iceberg Maintenance Within Postgres (crunchydata.com)

1

Citus: The Misunderstood Postgres Extension (crunchydata.com)

3

The SSO Tax Is Smart Business, and Bad Security (alexgaynor.net)

7

A New Postgres Block Storage Layout for Full Text Search (paradedb.com)

1

DuckDB-airport-extension: Airport extension for Arrow Flight with DuckDB (github.com/query-farm)

1

A New Postgres Block Storage Layout for Full Text Search (paradedb.com)

5

Microsoft/documentdb: DocumentDB – NoSQL document database in Postgres (github.com/microsoft)

1

Turso Platform Changes (twitter.com/glcst)

1

Using State Machines to Run Databases (2016) (citusdata.com)

94

Postgres UUIDv7 and per-back end monotonicity (brandur.org)

2

Postgres UUIDv7 and per-back end monotonicity (brandur.org)

1

Setup-Postgres: Fast Postgres setup for GitHub Actions (github.com/bmizerany)

2

Can we use this index, please? – Why not? (hdombrovskaya.wordpress.com)

3

Pg_incremental: Incremental Data Processing in Postgres (crunchydata.com)

3

Show HN: Pg_incremental – Incremental Data Processing in Postgres (github.com/crunchydata)

1

Smarter Postgres LLM with Retrieval Augmented Generation (crunchydata.com)

2

Iceberg Ahead-Analyzing Shipping Data in Postgres (crunchydata.com)

2

Rails World 2024 Review (brandur.org)

1

Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics (crunchydata.com)

6

New Amazon S3 Tables: Storage optimized for analytics workloads (amazon.com)

1

Reputation Is Portable (aaronfrancis.com)

1

Failover Replication Slots with Postgres 17 (decodable.co)

1

The Next Generation of the Heroku Platform (heroku.com)

2

7 Databases in 7 Weeks for 2025 (blwt.io)

2

How Jane Street Does Code Review (janestreet.com)

1

Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics (crunchydata.com)

3

AWS randomly assigns AZ names differently across accounts (amazon.com)

2

Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics (crunchydata.com)

1

Workbrew 1.0 for Secure Software Delivery (workbrew.com)

2

A Change to ResultRelInfo – A Near Miss with Postgres 17.1 (crunchydata.com)

2

A Change to ResultRelInfo – A Near Miss with Postgres 17.1 (crunchydata.com)

3

Amazon S3 now supports up to 1M buckets per AWS account (amazon.com)

1

Thundering Herd Problem (wikipedia.org)

1

8 Steps in Writing Analytical SQL Queries (crunchydata.com)

1

The Future of Postgres? (craigkerstiens.com)

50

Moving Off Heroku, Slowly (ideasasylum.com)

1

It's the Future (2016) (circleci.com)

2

Moving Off Heroku, Slowly (ideasasylum.com)

36

Fuckthis.app – Software products for exasperated people (searls.co)

2

A Deep Dive into Statistics [pdf] (postgresql.eu)

28

The Japanese word ikigai refers to a passion that gives joy to life (2022) (japan.go.jp)

1

The Narrows Bridge: From Open Source to AI (redmonk.com)

30

Pg_parquet: An extension to connect Postgres and parquet (crunchydata.com)

1

Enhanced Postgres Release Notes (crunchydata.com)

1

Long Distance Relationships (blwt.io)

2

Enhanced Postgres Release Notes (crunchydata.com)

1

4B rows of data a day into Postgres (twitter.com/djdarkbeat)

1

My Heroku values (Adam Wiggins) (2013) (gist.github.com)

2

Engineering Management Tricks (gist.github.com)

2

Learning about Parquet (det.life)

1

Postgres Tips (crunchydata.com)

1

What is the deal with NULLs? (2009) (davisjeff.com)

2

Real World Performance Gains with Postgres 17B-Tree Bulk Scans (crunchydata.com)

3

Real World Performance Gains with Postgres 17B-Tree Bulk Scans (crunchydata.com)

2

Window Functions for Data Analysis with Postgres (crunchydata.com)

1

Postgres Materialized Views from Parquet in S3 with Zero ETL (crunchydata.com)

1

PostGIS Meets DuckDB: Crunchy Bridge for Analytics Goes Spatial (crunchydata.com)