| From: | Peter Geoghegan <pg(at)heroku(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Greg Stark <stark(at)mit(dot)edu>, Noah Misch <noah(at)leadboat(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thom Brown <thom(at)linux(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: B-Tree support function number 3 (strxfrm() optimization) |
| Date: | 2014-07-31 18:54:05 |
| Message-ID: | CAM3SWZQGMX1uit3-5dmSDaPezp5V2FWCnsCh9V_xWO24OxVcDQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jul 31, 2014 at 11:41 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> I certainly like that better than poor-man; but proxy, to me, fails to
> convey inexactness. Perhaps we can work that idea in somehow. Or
> maybe "pre"-something, to indicate that we do this before comparing
> the regular key, in the hopes of not needing to.
Well, these normalized keys are sometimes sufficient to give correct
answers, or are sufficient to determine that that isn't possible with
just their representation. That is pretty exact.
How about "delegate key"? That's a similar term to proxy key, but is
more strongly suggestive of the idea that these keys are in some sense
inferior to original keys.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marti Raudsepp | 2014-07-31 19:14:25 | Re: B-Tree support function number 3 (strxfrm() optimization) |
| Previous Message | Robert Haas | 2014-07-31 18:50:25 | Re: pgaudit - an auditing extension for PostgreSQL |