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.
10
like