title

text

March 15 – 17 , 2017

Postrelease

  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 63 talks
  • offline
    format

Talks

Talks archive

PgConf.Russia 2017
  • Anton Doroshkevich
    Anton Doroshkevich InfoSoft

    1. Why is it time to consider switching to PostgreSQL?
    2. 1С and PostgreSQL interoperability.
    3. Why should we start with Windows?
    4. The first experience of migrating big enough 1С databases to Postgres.
    5. Large-scale projects on high-load systems, in figures.

  • Dmitry Yuhtimovsky
    Dmitry Yuhtimovsky Gilev.ru

    1. 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
    2. 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
    3. 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

  • Gregory Smolkin
    Gregory Smolkin Postgres Professional
  • Alexander Alekseev
    Alexander Alekseev PostgresPro

    ZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS.

    VIDEO

All talks