PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Kumar Rajeev Rastogi |
| Schedule | |
|---|---|
| Day | Talks - Day 3 - Thursday - 2015-06-18 |
| Room | DMS 1140 |
| Start time | 10:00 |
| Duration | 00:45 |
| Info | |
| 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.