News for hackers. Stuff that matters.

A comment on Sort improvements in PostgreSQL since 1997 [pdf]. Parent comment

Re:Sort improvements in PostgreSQL since 1997 [pdf] by Jweb_Guru on Friday February 19, 2016 @12:42AM (#11131838)
> 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).

[ Parent | on HN ]
Re:Sort improvements in PostgreSQL since 1997 [pdf] by anarazel on Friday February 19, 2016 @03:22AM (#11132329)
> 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

[ Parent | on HN ]