Postgres 17: Streaming I/O for sequential scans and ANALYZE | Hacker News Reader

Postgres 17: Streaming I/O for sequential scans and ANALYZE

pganalyze.com

111 pointssamaysharma12 comments

pganalyze's blog is a goldmine of Postgres tidbits, a lot of which is recapped in their YouTube channel: https://www.youtube.com/@pganalyze6516

I'm not at all affiliated, just a happy consumer of their material.

I didn't realize they had a YT channel, thanks for the share!

100%!

100% agree with brasetvik! So much efforts put in it!

Postgres is not just a database, but "database OS"

Discovered it a few months ago, and going through its last year posts and videos.

Postgres ecosystem is clearly booming with all its extensions like pgvector, paradedb and many many amazing tools, and derived projects

All videos annotated and accompanied with summary article

https://pganalyze.com/blog

Just look at the past 3 episodes

- E118 https://pganalyze.com/blog/5mins-postgres-17-materialized-ct...

- E117 https://pganalyze.com/blog/5mins-postgres-planner-join-equiv...

- E116 https://pganalyze.com/blog/5mins-postgres-17-beta1

Scaling Postgres is a great too

- https://www.youtube.com/@ScalingPostgres/videos

- https://www.scalingpostgres.com/episodes/

Postgres is eating the database world

https://medium.com/@fengruohang/postgres-is-eating-the-datab...

PG Feature Matrix https://www.postgresql.org/about/featurematrix/

Whats the difference between DB OS vs Database?

I don’t think “DB OS” is a standard term, but what I believe the commenter means is that postgres has evolved to become an incredibly mature, well built set of DB building blocks that are exposed via extension APIs etc to implement whatever kind of database you want.

Sure, there’s the core row-major RDBMS you get out of the box, but could easily turn that into a distributed column-oriented analytics data warehouse if you wanted to.

Let me do a lazy copy-paste "The phrase "Postgres is the database OS" is often attributed to Bruce Momjian, a co-founder of the PostgreSQL Global Development Group and a prominent figure in the PostgreSQL community. He has frequently used this phrase to highlight the extensibility and versatility of PostgreSQL, comparing it to an operating system in terms of its ability to support a wide range of functionalities through extensions and customizations."

I'd also add https://postgres.fm to the list if you are looking for a Postgres in production podcast that explains a lot of things. I always feel like I learn something new even if it's just something small.

thnx!

MySQL has had pluggable storage since at least 2010. A decade and a half later, PostgreSQL still doesn't (although I believe some forks do).

PostgreSQL is a good piece of software. And really good pieces of software -- git, Linux, Redis, tend to collect ecosystems.

Since Postgres 12, there's been support for “Pluggable Storage” where you could even define different storage engines for tables individually. Think of the Oriole extension which bought by Supabase in April 2024.

Postgres is making continual strides, it’s great to follow. It looks like there are some incremental backup improvements on the roadmap too.

I’ll have to dig in deeper, I’m still running 15.

Reply on news.ycombinator.com