Skip to content

Comment on Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io

Comments

I see lots of similarities between the (newer) Postgres wait analysis logging/views and Oracle AWR/ASH. I suspect it was heavily inspired.

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

Inspired, or solving similar problems in a similar tool leading to similar solutions?

Indeed, shouldn't patents be checked to ensure there isn't any risk here?

No. Oracle can go bankrupt for all I care. Criminal business practices.

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.