Parallel index builds in postgres thanks to work by @petervgeoghegan and others!
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=9da0cc35284bdbe8d442d732963303ff0e0a40bc …
FWIW, not having thought this through, it doesn't sound hard: Create jit context, use it to create wrapper function calling pg_qsort with constant comparator, force inlining to be enabled, use created function. ~30-60 LOC.
-
-
In the case of CIC TID sorts, I actually got it down to 8 bytes per "SortTuple" -- in fact, Tuplesort was sorting raw Datums. 3x memory saving was quite nice.
-
Not bad. But I've to admit I'm a bit more interested in making tuplesorts used in analytics queries faster ;)
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.