Five years ago I joined Crunchy Data, shortly after I wrote about having unfinished business with Postgres. As part of @snowflake that journey is continuing. We've built some amazing things, but are just getting started. Increasingly a first class Postgres experience isn't

Postgres performance mistakes ... let's get after it 💪 Andrew Atkinson meetup.com/postgres-meetu…

Any pgBadger fans out there? I recently discovered you can run it with managed cloud Postgres / Crunchy Bridge - use the CLI to send logs to a local text fqzocnta3zvleomq > pglogs.txt - pgBadger reads the text file, provides html pgbadger -f syslog pglogs.txt -o out.html

Postgres has a robust range of support for reporting and analytics functions. There's a lot of options for date bins and rollups. See our hand's on tutorial for working with date bins. Examples that run right in your browser to try out different tools. ⬇️

Postgres indexing for queries with wildcards 🃏 . This is a bit different than the standard indexing. If you’re application queries exactly matches, often standard b-trees can work well. But if you’re often using the LIKE and ILIKE queries with %string% to wrap them in a

The Dave Stokes will be at Postgres Meetup for All tomorrow. Join us! meetup.com/postgres-meetu…

You could wire this all up yourself ... but why? Paul Ramsey puts it in a nice little package for 'ya.

Congrats ParadeDB 🥳

Using a lot of JSON in Postgres? JSON is notoriously tricky to index. —> GIN indexes can be great for speeding up general searches or searching across many keys. However, often you’ll have queries that need to repeatedly access JSON for specific filtering or sorting on

Great write up on Postgres performance in Postgres Weekly today - this is mostly about a queue system but some evergreen topics in here rudderstack.com/blog/scaling-p…

Fun byteofdev.com/posts/making-p…

oh, i get it now. the reason for docker is because it's literally easier to bundle an entire operating system than a single python package

I've been working on my DuckDB talk for Kansas City Developer Conference and I am just in love with the small data manifesto. First of all, its beautiful. Second of all, it talks about joy and we're not talking about joy nearly enough .....

I realized today why I love working with AI instead of a google search or independent research ... it is completely 100% advertising free.

Ahead of next week's #kcdc2025, I'm hosting a special #PostgreSQL meetup with Snowflake! The incomparable Frank Wiles will be speaking. Along with Tyler Benfield from Prisma Postgres. My new colleague Danica Fine will be there. RVSP and join us! meetup.com/kansas-city-po…

We have made a lot of new friends since we joined @snowflake. Learn about Postgres in our 🐘 🛝 Postgres Playground 🛝 🐘. 󠁯•󠁏󠁏 Postgres running in a web browser, no installs or compiling 󠁯•󠁏󠁏 Simple and complex Postgres examples 󠁯•󠁏󠁏 Get started with data

Ha! This is why it's important to follow folks like Crunchy Data and others who offer professional, expert advice about running Postgres and not hallucinated AI fluff

I think its appropriate that a blog about Postgres logs would trail on and on .... 🤣 But seriously - there's tons of goodies in here gathered from my own work plus great advice from support and architecture teams. Several of the A team Crunchy Data were involved in this one.

The upcoming Postgres 18 is set to include some nice improvements to EXPLAIN: * BUFFERS on by default with ANALYZE 🎉 * Fractional "actual rows" (huge in some cases) * Quite a few new fields (including the very cool Index Searches) We've now added support for all of them. 💛

Let’s talk about Postgres scan types. Most of us have been in EXPLAIN and read some plans. Here’s some details about the different scan types and a diagram for thinking about how they work. ❖ Sequential scan: reads the entire table, row by row checking to see what matches the