PgConf.Siberia 2018

When implementing 1c, they immediately started using the postgreSQL database. During operation, problems with the program's performance have repeatedly been noted, which manifest themselves when using certain functions. Analysis of the problems showed that in all cases the “fault” was not the DBMS or even the 1C platform, but the configuration.

The talk describes the new features of the 11th PostgreSQL and Postgres Pro releases, as well as soome trends and features, related to 12th release, including: parallel query execution, partitioning, sharding, incremental backup, JIT compilation, SQL/JSON, Merge, etc.

The using of PostgreSQL in the development of an automated University management system is considered.