Postrelease
Доклады
Архив докладов
-
Anton Sikerin ООО "Транспортная интеграция"
PostgreSQL in tasks of transport analysis during the design of master plan for 2018 FIFA World Cup in Ekaterinburg
1) About 2018 FIFA World Cup and tasks set; 2) Tools of the department of modeling and analytics; 3) Passenger traffic analysis in Koltsovo airport and on railway transport (long distance and suburb trains); 4) Population and employment analysis; 5) Routes design for client groups with automated metainformation display and assembling of the final reports; 6) Deployment of a map server to give access for the costumer to the client group routes
VIDEO
-
Dmitry Melnik ИСП РАН
Dynamic Compilation of SQL Queries in PostgreSQL Using LLVM JIT
Currently, to execute SQL queries PostgreSQL uses interpreter, which implements Volcano-style iteration model. At the same time it’s possible to get significant speedup by dynamically JIT-compiling query “on-the-fly”. In this case it’s possible to generate code that is specialized for given SQL query, and perform compiler optimizations using the information about table structure and data types that is already known at run time. This approach is especially important for complex queries, which performance is CPU-bound.
-
Maksim Viharev Alytics
Using PostgreSQL in automating contextual advertising by Alytics for near real-time processing of mixed OLTP/OLAP load
In the data persistence layer, using PostgreSQL from the very start of development, we went all the way from a small cluster on a virtual machine to a multi-host system that provides near real-time processing of mixed OLTP/OLAP load. In this talk, I’m going to tell you about the main development stages of our analytical solution at the application and infrastructure levels, and describe the specifics of using PG that we encountered.
VIDEO
-
Alexander Korotkov Postgres ProfessionalAndrei Nikolayenko Скала-РБорис Нейман Mellanox
Фотографии
Архив фотографий