4 ms·
Most tools allow you to jump down to low level stuff. Isn’t it weird that I can’t just write the query plan for Postgres? My theory is people would understand
by rtpg 4y ago
Most tools allow you to jump down to low level stuff. Isn’t it weird that I can’t just write the query plan for Postgres?
My theory is people would understand indexes and the like way more if they were writing up the lookups
- Nihilartikel 4y agoThat's what I want too. To make a loose metaphor, if SQL is like high level opengl, then I want the low level Vulkan and shader APIs for hand optimization. I would like this especially for Apache Spark sql, since a bad plan that isn't aware of the data shape can blow gigabytes over the network unnecessarily.
- tormeh 4y agoSpark has datasets, which I think lets you do this, although it’s only supported in Java and Scala, not Python.
- tonnydourado 4y ago> Most tools allow you to jump down to low level stuff Eeehhh, kinda. Sure, a compiler will let you just write some assembly by hand, but it won't let you write a optimization step, or even directly configure it. You have to tweak your code or the compiler flag to give the right hints so the compiler generates the binary code you want. Doesn't look much different than a query planner.