Pavel Stehule
Pavel Stehule freelancer
18:00 04 February
45 мин

The performance problems related migrations from PL/SQL to PL/pgSQL

Porting applications from Oracle to Postgres is common work today. Unfortunately it is not without problems. In presentation I'll try to show the basic performance problems related to differences between Oracle and Postgres and PL/SQL and PL/pgSQL.



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

  • Gregory Smolkin
    Gregory Smolkin Postgres Professional
    90 мин

    Database backup with pg_probackup

    pg_probackup is a flexible tool that allows choosing the backup strategy depending on the write load of the PostgreSQL cluster, as well as offers a number of other features that can facilitate this vital aspect of database maintenance. In this tutorial, we will see how to apply this tool in practice.

  • Teodor Sigaev
    Teodor Sigaev Postgres Professional

    Postgres Pro Enterprise features

    Postgres Pro Enterprise features description from the developers.

  • Esteban Zimányi
    Esteban Zimányi ULB
    Mahmoud SAKR
    Mahmoud SAKR université libre de bruxelles
    45 мин

    MobilityDB: Managing Mobility Data in PostgreSQL

    MobilityDB is an open source moving object database system (https://github.com/ULB-CoDE-WIT/MobilityDB). Its core function is to efficiently store and query mobility tracks, such as vehicle GPS trajectories. It implements the Moving Features specification from the Open Geospatial Consortium (OGC). MobiltyDB is engineered up from PostgreSQL and PostGIS, providing spatiotemporal data management via SQL. It thus integrates with the postgreSQL eco-system allowing for complex architectures such as mobility stream processing and cloud deployments.

    The presentation will explain the architecture of MobilityDB, its database types, indexes, and operations. We will highlight the PostgreSQL features that enable this extension, and the would like to have features. This presentation will be of special interest to the PostgreSQL community, and to professionals in the transportation domain.

  • Vasiliy Puchkov
    Vasiliy Puchkov ООО
    45 мин

    PostgreSQL Database operational experience in enterprise-level network.

    · Enterprise network traits, known problems and workarounds.

    · Year-long background of maintaining 24x7 1C + PostgreSQL systems

    · Pros and cons in comparison with MS SQL from DBA point

    · Stories of 1C systems migration from MS SQL to PostgreSQL