1C:Enterprise business platform: working with PostgreSQL
"1C:Enterprise" is the most popular in Russia/Eastern Europe business applications development framework supports PostgreSQL for 10+ years. We'll review some cases and pecularities of 1C and PostgreSQL tandem.
Материалы к докладу
Слайды
20170317H1_Gribanov.pptxВидео
Другие доклады
-
Hans-Jürgen Schönig Cybertec Schönig & Schönig GmbH
Processing 1 BILLION rows per second with PostgreSQL
Database systems are increasing in size and so is the need to process huge amounts of data in real time. As commercial database vendors are bragging about their capabilities we decided to push PostgreSQL to the next level and exceed 1 billion rows per second to show what we can do with Open Source. To those who need even more: 1 billion rows is by far not the limit - a lot more is possible. Watch and see how we did it.
VIDEO
-
Alexander Korotkov Postgres ProfessionalБорис Нейман MellanoxAndrei Nikolayenko Скала-Р
-
Dmitry Yuhtimovsky Gilev.ru
Debugging 1С code in PostgreSQL DBMS
- 1C:Enterprise 8 and PostgreSQL 9 interoperability 1.1 Changes in new 1C platform versions 1.2 v81c_data and v81c_index schemas 1.3 Sending 1C queries to SQL 1.4 Using 1C technological log events for PostgreSQL diagnostics
- Analyzing queries that affect PostgreSQL performance 2.1 A free tool for automating log parsing 2.2 Pareto principle in action 2.3 Installation and configuration of the tool 2.4 A case study of query optimization 2.4.1 An issue in a PostgreSQL query 2.4.2 Finding non-optimal operations in a query 2.4.3 Resolving inefficiencies
- PostgreSQL statistics for performance diagnostics 3.1 Comparing Postgres with MS SQL Server 3.2 Troubleshooting locks 3.3 Operating load diagnostics 4 Case studies by the gilev.ru team
-
Igor Vedyohin IBS