Re: md5(large_object_id) - Mailing list pgsql-general

From Jim Nasby
Subject Re: md5(large_object_id)
Date
Msg-id 56155E05.7050500@BlueTreble.com
Whole thread Raw
In response to Re: md5(large_object_id)  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: md5(large_object_id)  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
On 10/7/15 10:34 AM, Karsten Hilbert wrote:
> Still, I'd welcome a native, streaming md5(loid) which is
> bound to be more optimized by design.

It would be nice if we had an interface to TOAST that allowed for
streaming (well, really chunking) data to a function. That wouldn't help
in this particular case, but it would significantly expand the
usefulness of a streaming version of md5 and all the other hash operators.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Try to understand VACUUM and its settings
Next
From: "Andrus"
Date:
Subject: Re: How to drop user if objects depend on it