Analytic reports data processing optimization
Method of automated refresh of preprocessed results of analytis reports is provided. Preprocessing and caching of reports allows ability for fast response for big data reports. Author describes the way of reports cache refreshing with minimum server loads and tuned actualization rate.
Марат Фаттахов АО "БАРС Груп"Dmitry Boikov АО БАРС Груп
First working on Oracle, we could not ignore appearance and growth of PostgreSQL. I will describe how we came to PostgreSQL and share some experience of migrating a large medical system.
- developing a code converter;
- packages migration;
- our patches solving some of the migration problems.
Fabio Telles Rodriguez Timbira
Challenges and solutions found in documents dematerialization and bank cheque processing system used in the Bank of Brazil.
Dmitry Vasiliev Postgres Professional
The talk describes performance benchmarking results of PostgreSQL on modern Hi-End servers. The main attention was paid to the locks for shared data access and associated bottlenecks. The testing propose was to test the linear read scalability limits with an increase of cores number allocated for PostgreSQL. Testing was performed for different postgres versions (9.4, 9.5, 9.6) to check new features designed to increase performance on multiprocessing architectures.
Mikhail Tyurin Avito
My experience of working with PostgreSQL has provided clear understanding of its main advantages, making us choose and recommend choosing it.
4.1 Transactional DDL
4.2 WAL and True Physical Replication
4.3 Transactional Snapshot and True Logical Replication and PGQ
4.4 Exciting extensibility