Re:Sorting of integers and floats 23% faster in PostgreSQL 9...
by viraptor on Thursday August 02, 2012 @05:43AM
(#4327988)
Only if you actually can special case it automatically during compilation. It could still require a few tricks if your comparison comes from a user-defined query. At a minimum it would have to be something like: figure out which column type are you using, figure out what basic type does it map to, use that type in the template.
[ Parent
| on HN ]
Re:Sorting of integers and floats 23% faster in PostgreSQL 9...
by obtu on Thursday August 02, 2012 @06:06AM
(#4328048)
PostgreSQL is extensible enough that runtime specialisation would be best, I think. A JIT compiler, or a compiled type-safe multi-stage[1] programming language like MetaOCaml, would give the best performance.