[HN Gopher] Postgres 17: Streaming I/O for sequential scans and ...
       ___________________________________________________________________
        
       Postgres 17: Streaming I/O for sequential scans and ANALYZE
        
       Author : samaysharma
       Score  : 91 points
       Date   : 2024-06-13 16:45 UTC (6 hours ago)
        
 (HTM) web link (pganalyze.com)
 (TXT) w3m dump (pganalyze.com)
        
       | brasetvik wrote:
       | 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.
        
         | cpursley wrote:
         | I didn't realize they had a YT channel, thanks for the share!
        
         | adeptima wrote:
         | 100%!
        
       | whoiscroberts wrote:
       | 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.
        
       | adeptima wrote:
       | 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/
        
         | IamLoading wrote:
         | Whats the difference between DB OS vs Database?
        
           | _hl_ wrote:
           | 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.
        
         | dewey wrote:
         | 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.
        
         | paulddraper wrote:
         | 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.
        
       ___________________________________________________________________
       (page generated 2024-06-13 23:01 UTC)