3 ms·
> Postgres has an extensible type system so Radix sort isn't really suitable, it really needs a comparison sort. That's not quite true. It supports string tri
by Jweb_Guru 11y ago
> Postgres has an extensible type system so Radix sort isn't really suitable, it really needs a comparison sort.
That's not quite true. It supports string tries, for example (using SP-GIST). Such operations just have to be built for specific types. I think it would be more accurate to say that (AFAICT) Postgres doesn't currently have any way to extend the optimizer with custom plans (though it's been a very popular feature suggestion).
- anarazel 11y ago> I think it would be more accurate to say that (AFAICT) Postgres doesn't currently have any way to extend the optimizer with custom plans (though it's been a very popular feature suggestion). There's http://www.postgresql.org/docs/devel/static/custom-scan.html http://www.postgresql.org/docs/devel/static/custom-scan.html