Postrelease
Talks
Talks archive
-
Andrey Borodin YandexThis 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
-
Mikhail Tyurin Independent entrepreneur in the field of data technology and predictive analytics< Query failed: ERROR: deadlock detected < DETAIL: Process 17371 waits for ShareLock on transaction 102733872; Blocked by process. < Process 10414 waits for ShareLock on transaction 102733874; Blocked by process 17371.
Such "unpleasant" messages from the server can seriously puzzle the developer. When working with locks, in particular, with transactions in general, it is necessary to take into account the features of the implementation of client libraries, which can cause the above exception.
In the short talk, the mechanics of the interaction of locks will be explained, main attention being paid to causes of deadlocks. References to the relevant documentation pages will be given. A technique of "bypassing" this problem of concurrent data access will be described and illustrated with some generalized examples from practice are shown. The talk will be interesting to database developers and administrators as well as the client-side application developers.
-
Igor Chizhevskiy SRC "Voshod"
Sergey Korolev MCST
Dmitry Pogibenko FGBU "NII Voskhod"
Stanislav Merzlyakov Scientific Research Institute "Voskhod"
Илья Космодемьянский Data Egret
Иван Богданов SRC "Voshod"Practical experience of carrying out import substitution with using PostgreSQL in government information system including not only the free software, but also the Russian hardware (Elbrus servers and other).
VIDEO
-
Peter Gribanov 1C LLC"1C:Enterprise" is the most popular in Russia/Eastern Europe business applications development framework supports PostgreSQL for 10+ years. We'll review some cases and pecularities of 1C and PostgreSQL tandem.
Photos
Photo archive