Alexey Fadeev
Alexey Fadeev Sibedge
09:00 23 September
22 мин

ORM for .Net development, PostgreSQL and performance

Several years ago it was like that, you say “.Net developer” mean Windows and Microsoft SQL Server developer. But time flies, things change. Microsoft became a platinum member of the Linux Foundation, real .Net Core applications work on Linux/Unix servers, PostgreSQL's popularity goes up including .Net projects.

In my speech I will compare several popular ORM frameworks and tell how to make them work faster. I’ll tell about Dapper-Dot-Net “micro ORM” in a nutshell, that doesn’t generate SQL commands, it just maps DB-records to C# objects, but does it very fast. Also, it’s possible to combine different ORM frameworks with each other to improve performance.

The most interesting thing I want to talk about is how to accelerate insert and update operations using the peculiar properties of «Multi Insert» and «Upsert» in PostgreSQL. I’m gonna make a real-time demo of inserting and then updating one million records to PostgreSQL instance running on ordinary notebook with Windows in a just a few seconds, using ORM.

Другие доклады

  • Михаил Кулагин
    Михаил Кулагин Postgres Professional
    45 мин

    PostgreSQL and high availability

    The highly available configurations for PostgreSQL are usually mode with the help of binary replication and some third party utilities. This talk will review the existing solutions, including a simple one based on corosync/pacemaker, which is supported by Postgres Pro. A live demo will be presented.

    Another hight availability approach is proposed by the multimaster Postgres Pro extension, which provides high availability without any third-party products. A live demo and description of multimaster caveats will be presented.

  • Anton Doroshkevich
    Anton Doroshkevich ИнфоСофт
    45 мин

    1C platform and PostgreSQL

    The file-based storage for 1C should be left in the past. We will compare SQL Express and PostgreSQL on Windows platform, outlining some useful features of MS SQL, still lacking in PostgreSQL, discuss usage of tablespaces in PostgreSQL and MS SQL. Then we'll discuss the important configuration settings and critical operations for running 1C platform, replication, cascades, a fast way for creating developer copies of the databases, and make backups and check their integrity.

  • Anastasia Lubennikova
    Anastasia Lubennikova Postgres Professional
    45 мин

    What's new in PostgreSQL 10.0

    PostgreSQL 10.0 is to be released in autumn 2017. This talk describes the development and release cycle of PostgreSQL, and new features of the upcoming release, including logical replication, declarative partitioning, ehanced statistics and many other.

  • Dmitry Ivanov
    Dmitry Ivanov Postgres Professional
    45 мин

    Pathman - the effective way to table partitioning in PostgreSQL

    Table Partitioning is a highly demanded functionality of PostgreSQL. The existing possibility to make partitioning through inheritance has several serious disadvantages, such as ineffective planning, missing runtime optimization, need to manage triggers and sections manually.

    This talk describes the pg_pathman extension developed by our team. pg_pathman supports HASH and RANGE partitioning and performs query optimization during planning and execution stages, allows fast includes by using custom executor nodes instead of triggers, supports FDW, lock-free data migration and other possibilities.

    In conclusion I will describe the new features, expected in next releases, and our plans for integration with PostgreSQL 10.