![Igor Vedyohin Igor Vedyohin](/media//2017/02/28/vedexin500.jpg.180x180.jpg)
Skala-SR / Postgres Pro — preconfigured high-performance database engines
Слайды
Vedekhin_IBS.pptxВидео
Другие доклады
-
Peter van Hardenberg Heroku
The History of Postgres
The PostgreSQL community is over 20 years old, but the history of PostgreSQL dates back even farther. In this talk, we'll learn about the roots of the Postgres project, learn about some of the people who contribute to it, study how it has changed over time, and pay special attention to the many contributions of Russian people.
-
Oleg Ivanov Postgres Professional
Adaptive query optimization in PostgreSQL
Query optimization is an important problem, which solution has a great influence on DBMS performance, especially for complex queries. In this talk we consider PostgreSQL query optimizer and specifically cardinality estimation problem for correlated clauses, which is one of the most well-known drawbacks of query optimizers in general. In the talk we propose our solution for this problem which involves machine learning methods and is available for PostgreSQL 9.6 as an extension with a patch. We discuss the experimental evaluation, advantages, disadvantages, and fields of application of the proposed approach as well.
VIDEO
-
Oleg Bartunov Postgres Professional
PostgreSQL JSON Roadmap
The new ISO/IEC 9075-2:2016 standard specifies JSON data and operations syntax and semantics specifics for SQL. This talk overviews the requirements of this standard, and focuses on the differences between them and the actual implementation of JSON/JSONB in PostgreSQL. Special attention will be paid to JSON Path (XPath analogue), SQL/JSON functions and our plans to make Postgres compliant with this standard.
VIDEO
-
Andrey Borodin Яндекс
GiST speedup: patches, hacks and tweaks
This report overviews some ideas and implementations to speedup different parts of generalized search trees (GiST): 1. Intrapage indexing 2. Fractal tree technology 3. Modern algorithms for spatial indexing (RR*-tree) 4.. Possible advancements of GiST API
VIDEO