My Writing

I asked ChatGPT what are some advanced Postgres tricks I should learn about, and one of the things that came up was pg_trgm. After a bit more reading, I'm convinced this plugin should be an essential part of any database engineers toolkit.

I've been reading PostgreSQL documentation for fun lately, and I'd like to share what I've learned. Right now, that means advanced indexes and how to work with collection fields efficiently.

If you've ever worked prexisting array or JSON column and needed a complex WHERE clause for the latest feature, you might have worried about query performance. Or maybe you didn't worry about it, only to find out later that it was glacially slow.