Другие доклады
-
Dmitry Beloborodov UIS, CoMagic
Опыт использования PostgreSQL в проектах UIS, CoMagic
Using PostgreSQL since 2003, we went all the way from a database of a couple of GB to a cluster of more than 5TB. At the moment, we have more than 700 tables and about 1500 stored procedures. We are ready to share with you the following: - Problems encountered at different development stages and how we resolved them. - Best practices in database administration. - Our own extension to work with several closely related databases. - Best known methods and tools that enable our several teams to work together without interference. - How we set up test equipment of different types. And, of course, we'll talk about optimization, and how we identify bottlenecks and high-load use cases.
VIDEO
-
Alexander Korotkov Postgres Professional
RUM-индексы и их применение
I want to present a new custom access method, which extends the current GIN capabilities using additional information stored in posting tree/list. For example, positional information as an additional information allows new AM returns results in relevance order, which could considerably improve execution time of full text queries.
-
Peter Gribanov 1С
PostgreSQL в 1С:Предприятии и в облачной системе 1С:Fresh
"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.
-
Ivan Frolkov Postgres Professional
Отчуждаемые таблицы в PostgresPro
With big data threads, even the upload of data to a database can often be problematic – apart from the data upload itself, you need to create indexes, perform VACUUM after the upload for correct Index-only scans, etc. From this talk, you will learn how to avoid most of such problems (if not all of them).
VIDEO