| From: | Reece Hart <reece(at)harts(dot)net> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | digest data types? |
| Date: | 2007-04-12 14:18:52 |
| Message-ID: | 1176387532.4888.1.camel@snafu.site |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Does anyone have postgresql types for message digests, especially md5
and sha1?
Obviously I could store these as text (as I currently do), but I'm
particularly interested in custom types that store digests as binary
blobs and provide conversion to/from text.
Am I correct in assuming that the space saved by storing digests as
binary (1/2 size of hex) will substantially impact index ins/upd/del
performance or when the digest itself is a large fraction of the rest of
the row size?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2007-04-12 15:10:30 | Re: SQL - finding next date |
| Previous Message | Tom Lane | 2007-04-12 14:01:05 | Re: Increasing the shared memory |