We store scientific information in PostgreSQL, and some of that is bytea and large, thus we must "chunk it" both for performance, and not be limited to 1GB (we do exceed that, in rare occasions).
Recently I added md5/sha1 hashing support for such values (for various reasons, to track corruptions in our ETLs, now fixed, but also in the future for custom smart sync and such), and was surprised to discover there are no aggregate versions of those functions, neither the built-in md5 one (now with bytea overload), nor for pgcrypto. Did I miss something? Any chance this might be added in the future? Seems so logical to me, that these hashing functions were available are aggregates, I can't be the first one to think of that, can it? Thanks, --DD PS: The holly-grail IMHO, would be built-in support for hashing, with intelligent lazy-compute and persistence correctly reset on changes. Probably opt-in. PPS: Built-in Support for xxh64, or at least in official pgcrypto, would also be nice. With aggregate! PPPS: I remember Oracle LOBs supporting a built-in implicit mime-type attribute on them, which was used as the content-type with served over the built-in WebDAV extension for the DB. I wish PostgreSQL had something like that too. PPPPS: the lo extension is not viable for us, FWIW. All the above should be opt-in on bytea columns IMHO.
