Postrelease
Talks
Talks archive
-
Michael Shurutov Postgres Professional- What is an autonomous transaction?
- An overview of autonomous transactions in "big" DBMS: Oracle.
- Autonomous transaction logic in Postgres Pro.
- An overview of emulation methods for autonomous transactions in PostgreSQL.
- Comparing performance of the built-in Postgres Pro autonomous transaction mechanism and PostgreSQL emulation methods.
VIDEO
-
Dmitry Cremer Federal State Unitary Enterprise Rossiya Segodnya- why we build PostgreSQL from sources?
- choice build options
- dependencies
- creation system environment
- how to customise Linux for work with PostgreSQL
- extra soft for PostgreSQL DBA
VIDEO
-
Yury Zhukovets ЗАО Дилжитал-ДизайнThis talk is about migrating an electronic document management system from MS SQL to PostgreSQL 9.5 or higher as part of the import phaseout initiative. We will touch upon architecture specifics, as well as describe the problems we encountered when migrating T-SQL code to pgsql, and how we resolved them.
Learn more at https://pgconf.ru/news/94168
VIDEO
-
Arthur Zakirov PostgresPro
Teodor Sigaev PostgresProFull text search in PostgreSQL is probably the most advanced one among relational DBMS. This tutorial will explain how to setup full text search configurations and dictionaries and how to build a ful text search system using an example of a simple popular science web site, with demonstration of various ranking functions. Also I will tell about new RUM index, which allows to accelerate execution of some kinds of full text queries and implements a new improved ranking function.
Photos
Photo archive