Turning to Postgres for 1C: overcoming the fears
During the tutorial we will explore the following cases:
- discovering troublesome areas using 3rd party extensions made by the PG community;
- debugging algorithms in Vagrant environments prior to placing them in production;
- using Jenkins to run performance degradation checks on the existing algorithms;
- exploring various extensions for the out-of-the-box PostgreSQL that facilitate productivity of 1C systems, including search for "hypothetical" indexes;
- handling backup & recovery with Barman;
- troubleshooting problematic queries and formulating approaches toward refactoring;
- studying how proper mount points in the structure of a PG cluster influence performance of 1C.
And for dessert — how to use Docker and Flocker for 1C-based information systems.
During the tutorial we will explore the following cases:
- discovering troublesome areas using 3rd party extensions made by the PG community;
- debugging algorithms in Vagrant environments prior to placing them in production;
- using Jenkins to run performance degradation checks on the existing algorithms;
- exploring various extensions for the out-of-the-box PostgreSQL that facilitate productivity of 1C systems, including search for "hypothetical" indexes;
- handling backup & recovery with Barman;
- troubleshooting problematic queries and formulating approaches toward refactoring;
- studying how proper mount points in the structure of a PG cluster influence performance of 1C.
And for dessert — how to use Docker and Flocker for 1C-based information systems.
The tutorial consits of 4 sections:
- review of the necessary software that has to be installed on computers of 1C maintenance engineers and performance experts, and the order in which it should be applied;
- classic 1C behavioural patterns and their visualisation with pgBadger;
- troubleshooting of problematic queries in order to formulate approaches toward refactoring;
- influence that versions of PG and the platform cast on durability of the production environment.
