Postrelease
Доклады
Архив докладов
-
Philip Delgyado ООО «Лектон»
Distributed workflow specifics in PostrgeSQL
When working with a complex business logic, you often have to implement a workflow - a sequence of several processing steps, with each step implementing a separate part of the business logic. This is usually done with specialized queues, but if there are high reliability demands, it makes sense to do everything on PostgreSQL.
I will describe the tasks that require a workflow implementation, offer a solution, compare it with other options, and tell you about the implementation traps and pitfalls.
-
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
-
Alexey Mergasov НОКСА Дата Лаб
10+ PB efficient storage and processing via PostgreSQL. Novel paradigm of lean data infrastructure for Data-Driven Enterprise
Alexey will present technical details and share hands-on experience of extreme data normalization application for data infrastructure with exceptional parameters design and development. Extreme normalization-based data infrastructures has the following competitive advantages in comparison with market leaders: - Real-time data processing for 10 PB of data and more - 2-6 times better overall performance - 100% data consistency through total data landscape - Almost linear scalability - 4-10 lower cost of ownership - etc The abovementioned approach has been successfully utilized out of Russian market in telecommunication, retail, fin-tech, manufacturing (Industry 4.0, industrial IoT), and government institutions.
VIDEO
-
Alexander Alekseev Postgres Professional
ZSON, PostgreSQL extension for transparent JSONB compression
ZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS.
VIDEO
Фотографии
Архив фотографий