Hacker News new | ask | show | jobs
by Jweb_Guru 3778 days 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).

1 comments

> 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