Переходные таблицы (Transition tables)!
Transition tables, a new feature in PostgreSQL 10, offer broad new capabilities including new ways to maintain materialized views. At the end of this talk, you will have seen new ways to use this feature and have it in your tool chest for the future.
Слайды
Видео
Другие доклады
-
90 мин
Ivan Panchenko Postgres ProfessionalПолнотекстовый поиск: от A до Ω
Tutorial on Full Text Seach in PostgreSQL, containing all recent improvemets. All recipies necessary for building an application will be given: dictionary and parser configuration, faceted search, fuzzy search, multilanguage search, ranking etc. Participants will be provided with a test database for exercises.
-
45 мин
Антон Дорошкевич Инфософт1С-Батл. PostgreSQL vs MS SQL
Comparison of capabilities of PostgreSQL and MS SQL to work with 1С. What does pg_restore mean for 1С user? Results of load testing for 1C database of more than 1TB size. The story of one 1C Production: 2 years, 500+ databases 1C, 4TB of data, cascading replication.
-
45 мин
Ivan Frolkov Postgres ProfessionalУправление потоками заданий в PostgresPro Enterprise
It is often required to asynchronously perform several transactions in a strictly defined sequence, not just a single transaction. There are several ways to achieve this, and one of the solutions available is the pgpro_scheduler module.
-
22 мин
Дмитрий Шитов ООО "ЦТП"Хроники 1Сников: миграция с Windows+1С+PostgreSQL на Linux+1C+PostgreSQL
What is a real cost of not paying for Windows for 1C-user? Is there life without COM? Addressing and other issues for the bunch of PostgreSQL. Scheduling disk resources. How to overcome OS CentOS crash.