<story><title>JITing PostgreSQL using LLVM [pdf]</title><url>http://anarazel.de/talks/fosdem-2018-02-03/jit.pdf</url></story><parent_chain></parent_chain><comment><author>assface</author><text>AFAIK, there are only a handful of DBMSs that do complete query compilation with the LLVM:&lt;p&gt;* MemSQL (&lt;a href=&quot;http:&amp;#x2F;&amp;#x2F;highscalability.com&amp;#x2F;blog&amp;#x2F;2016&amp;#x2F;9&amp;#x2F;7&amp;#x2F;code-generation-the-inner-sanctum-of-database-performance.html&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;highscalability.com&amp;#x2F;blog&amp;#x2F;2016&amp;#x2F;9&amp;#x2F;7&amp;#x2F;code-generation-the...&lt;/a&gt;)&lt;p&gt;* Tableau&amp;#x2F;TUM HyPer (&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;blog.acolyer.org&amp;#x2F;2016&amp;#x2F;05&amp;#x2F;23&amp;#x2F;efficiently-compiling-efficient-query-plans-for-modern-hardware&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;blog.acolyer.org&amp;#x2F;2016&amp;#x2F;05&amp;#x2F;23&amp;#x2F;efficiently-compiling-ef...&lt;/a&gt;)&lt;p&gt;* CMU Peloton (&lt;a href=&quot;http:&amp;#x2F;&amp;#x2F;db.cs.cmu.edu&amp;#x2F;papers&amp;#x2F;2017&amp;#x2F;p1-menon.pdf&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;db.cs.cmu.edu&amp;#x2F;papers&amp;#x2F;2017&amp;#x2F;p1-menon.pdf&lt;/a&gt;)&lt;p&gt;* Vitesse (&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;watch?v=PEmVuYjhQFo&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;watch?v=PEmVuYjhQFo&lt;/a&gt;)&lt;p&gt;I think Greenplum was talking about doing this too, but that was about a year ago (&lt;a href=&quot;http:&amp;#x2F;&amp;#x2F;engineering.pivotal.io&amp;#x2F;post&amp;#x2F;orca-profiling&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;engineering.pivotal.io&amp;#x2F;post&amp;#x2F;orca-profiling&amp;#x2F;&lt;/a&gt;)&lt;p&gt;Most systems just compile the predicates (Impala, SparkSQL).&lt;p&gt;A lot of companies are talking about adding this now. The performance gains are significant.</text></comment>
<story><title>JITing PostgreSQL using LLVM [pdf]</title><url>http://anarazel.de/talks/fosdem-2018-02-03/jit.pdf</url></story><parent_chain></parent_chain><comment><author>dfox</author><text>For me this is great demonstration of how SSDs have changed the performance landscape. Exactly this idea was discussed on P2D2 10 or so years ago and generally dismissed as too much work for negligible performace gain because the disk IO will still dominate. Today I believe that this makes sense.&lt;p&gt;Edit: and probably it is not only about SSDs, but also about cheap DRAM as today in most deployments I know about most queries only touch indices and tuples that are in RAM (and in fact often the whole pg_base is smaller on disk than RAM of the server).</text></comment>