[HN Gopher] Waiting for Postgres 16: Cumulative I/O statistics w...
       ___________________________________________________________________
        
       Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
        
       Author : lfittl
       Score  : 125 points
       Date   : 2023-02-17 16:26 UTC (6 hours ago)
        
 (HTM) web link (pganalyze.com)
 (TXT) w3m dump (pganalyze.com)
        
       | trollied wrote:
       | I see lots of similarities between the (newer) Postgres wait
       | analysis logging/views and Oracle AWR/ASH. I suspect it was
       | heavily inspired.
        
         | yjftsjthsd-h wrote:
         | Inspired, or solving similar problems in a similar tool leading
         | to similar solutions?
        
           | DBAOneDay wrote:
           | Indeed, shouldn't patents be checked to ensure there isn't
           | any risk here?
        
         | anarazel wrote:
         | Wait events are perhaps inspired by oracle's stuff, at least
         | indirectly. It was developed by Robert Haas and Amit Kapila,
         | working for EDB. Traditionally a lot of their customers have
         | migrated from Oracle.
         | 
         | The redesigned way of storing stats in memory and pg_stat_io
         | aren't inspired by Oracle. Melanie, who authored pg_stat_io,
         | has never used oracle. I haven't used oracle in ~15 years, and
         | the only thing I remember is fighting crashes in connect_by (I
         | influenced the design of pg_stat_io, and authored large
         | portions of the shared memory stats stuff).
         | 
         | Edit: noted Amit's co-authorship of wait events
        
       | fswd wrote:
       | Does anyone know if 16 will bring back JSON_TABLE from Postgres
       | 15? They initially had it in the beta, then at the last moment,
       | removed it.
        
         | anarazel wrote:
         | Not yet clear. A lot of the infrastructure needed to support
         | JSON_TABLE et al in a cleaner fashion, has now been added.
        
       | [deleted]
        
       | dboreham wrote:
       | Good to see this part of the performance problem space being
       | addressed.
        
       | sgt wrote:
       | Was thinking of upgrading to 15. So should I wait for 16?
        
         | 1500100900 wrote:
         | While waiting for PG 16 you can upgrade to 15.
        
           | sgt wrote:
           | Agreed. I also see PG 16 is scheduled for release later in
           | the fall. Also, you don't want to put the first 16.0 version
           | on a production system, rather wait until 16.1, 16.2 etc.
        
             | Tostino wrote:
             | That's always for the best. So now that 15 has had some
             | time to settle, it's a good time to adopt.
        
               | vlod wrote:
               | Great opportunity to test your db backup process. :)
        
       | ggregoire wrote:
       | Unrelated with the topic but pganalyze seems great (never heard
       | about it before).
       | 
       | That's how you make a good home page.
        
         | [deleted]
        
         | lfittl wrote:
         | OP here - thanks for noting!
         | 
         | We've recently invested effort to make the homepage better
         | (added the animation, revised the messaging, etc), so that
         | makes me happy to hear & will forward to the team as well.
        
       ___________________________________________________________________
       (page generated 2023-02-17 23:00 UTC)