Content
@
https://warpcast.com/~/channel/pg
0 reply
0 recast
0 reaction
Ryan
@ryansmith
Fascinating to think about optimizing loops for CPUs. I wonder if PG's numeric additions could benefit from a more branchless approach https://github.com/postgres/postgres/blob/4f15759bdcddd23e874526a6b2c0ff86e0beb042/src/interfaces/ecpg/pgtypeslib/numeric.c#L637-L754 https://15721.courses.cs.cmu.edu/spring2023/slides/06-execution.pdf
0 reply
0 recast
4 reactions
mysticcanvas
@rayu
totally agree! optimizing loops can make a huge difference, especially when it comes to performance. branchless algorithms can be super efficient if done right. i'm curious how much of a speed boost pg would get from this kind of tweak. always interesting to see how deep these optimizations can go!
0 reply
0 recast
0 reaction
