5 ms·
Postgres 17: Streaming I/O for sequential scans and ANALYZE
- brasetvik 2y agopganalyze's blog is a goldmine of Postgres tidbits, a lot of which is recapped in their YouTube channel: https://www.youtube.com/@pganalyze6516 https://www.youtube.com/@pganalyze6516 I'm not at all affiliated, just a happy consumer of their material.
- whoiscroberts 2y agoPostgres 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.
- adeptima 2y ago100% 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 https://pganalyze.com/blog Just look at the past 3 episodes - E118 https://pganalyze.com/blog/5mins-postgres-17-materialized-cte-scans https://pganalyze.com/blog/5mins-postgres-17-materialized-ct... - E117 https://pganalyze.com/blog/5mins-postgres-planner-join-equivalence-class-in-any-filters https://pganalyze.com/blog/5mins-postgres-planner-join-equiv... - E116 https://pganalyze.com/blog/5mins-postgres-17-beta1 https://pganalyze.com/blog/5mins-postgres-17-beta1 Scaling Postgres is a great too - https://www.youtube.com/@ScalingPostgres/videos https://www.youtube.com/@ScalingPostgres/videos - https://www.scalingpostgres.com/episodes/ https://www.scalingpostgres.com/episodes/ Postgres is eating the database world https://medium.com/@fengruohang/postgres-is-eating-the-database-world-157c204dcfc4 https://medium.com/@fengruohang/postgres-is-eating-the-datab... PG Feature Matrix https://www.postgresql.org/about/featurematrix/ https://www.postgresql.org/about/featurematrix/
- IamLoading 2y agoWhats the difference between DB OS vs Database?
- _hl_ 2y agoI 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.
- adeptima 2y agoLet 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."
- dewey 2y agoI'd also add https://postgres.fm 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.
- adeptima 2y agothnx!
- paulddraper 2y agoMySQL 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.