pganalyze's blog is a goldmine of Postgres tidbits, a lot of which is recapped in their YouTube channel: <a href="https://www.youtube.com/@pganalyze6516" rel="nofollow">https://www.youtube.com/@pganalyze6516</a><p>I'm not at all affiliated, just a happy consumer of their material.
100% agree with brasetvik! So much efforts put in it!<p>Postgres is not just a database, but "database OS"<p>Discovered it a few months ago, and going through its last year posts and videos.<p>Postgres ecosystem is clearly booming with all its extensions like pgvector, paradedb and many many amazing tools, and derived projects<p>All videos annotated and accompanied with summary article<p><a href="https://pganalyze.com/blog" rel="nofollow">https://pganalyze.com/blog</a><p>Just look at the past 3 episodes<p>- E118 <a href="https://pganalyze.com/blog/5mins-postgres-17-materialized-cte-scans" rel="nofollow">https://pganalyze.com/blog/5mins-postgres-17-materialized-ct...</a><p>- E117 <a href="https://pganalyze.com/blog/5mins-postgres-planner-join-equivalence-class-in-any-filters" rel="nofollow">https://pganalyze.com/blog/5mins-postgres-planner-join-equiv...</a><p>- E116 <a href="https://pganalyze.com/blog/5mins-postgres-17-beta1" rel="nofollow">https://pganalyze.com/blog/5mins-postgres-17-beta1</a><p>Scaling Postgres is a great too<p>- <a href="https://www.youtube.com/@ScalingPostgres/videos" rel="nofollow">https://www.youtube.com/@ScalingPostgres/videos</a><p>- <a href="https://www.scalingpostgres.com/episodes/" rel="nofollow">https://www.scalingpostgres.com/episodes/</a><p>Postgres is eating the database world<p><a href="https://medium.com/@fengruohang/postgres-is-eating-the-database-world-157c204dcfc4" rel="nofollow">https://medium.com/@fengruohang/postgres-is-eating-the-datab...</a><p>PG Feature Matrix <a href="https://www.postgresql.org/about/featurematrix/" rel="nofollow">https://www.postgresql.org/about/featurematrix/</a>
Postgres is making continual strides, it’s great to follow. It looks like there are some incremental backup improvements on the roadmap too.<p>I’ll have to dig in deeper, I’m still running 15.