PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Kumar Rajeev Rastogi
Day Talks - Day 3 - Thursday - 2015-06-18
Room DMS 1140
Start time 10:00
Duration 00:45
ID 776
Event type Lecture
Track Performance
Language used for presentation English

Go Faster with Native Compilation

Schema-binding for 30% better response times

In this presentation I will briefly talk about the Native Compilation technology, its usage, its benefit and how it is important from current business standard.

Further to this I will elaborate Native Compilation of relation called "Schema Binding", which utilizes the information available about a TABLE schema during its creation to generate a specialized code to access/ store the tuple of the corresponding TABLE. Schema Binding technology gives around up to 30% performance improvement for TPC-H benchmark.

SQL engines are designed in a very generic way to handle all kinds of functionality but at the same time there are many invariant which does not change for every query execution. Native Compilation is a technology to identify such invariant and generate corresponding specific specialized code. One of the such example is table schema definition, once a schema is defined, its attribute length, data-type, size remains same. Hence access/ storage of data for this table is going to be always same irrespective of any data. So for this case instead of using the generalized code, we can generate specialized code for this table, which will have to execute much fewer instruction in order to access/ store data and hence much better performance.