Bruce Momjian
Bruce Momjian EnterpriseDB
15:45 25 October
45 мин

Future Postgres Challenges

Postgres has been a vibrant project for decades, and probably will be popular for decades to come. However, as with any complex endeavor, challenges are always lurking. This talk explores the many project, competitive, and technical challenges in the future that could derail its success. By exploring these challenges, we will be better able to avoid them.



Видео доступно участникам мероприятия, выполнившим вход в личный кабинет

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

  • Mikhail Tsvetkov
    Mikhail Tsvetkov Intel
    45 мин

    PostgreSQL on new Xeon CPUs and Optane Persistent Memory

    Intel® Xeon® Scalable Gen 3 - new commands have been added to speed up the database: vector bit manipulation instructions to enable data compression without losses, vector instructions to make TLS protocols faster and SGX enclaves for secure code execution. We will also discuss the new generation of persistent memory Intel® Optane™ PMem 200 series. We will explain what these new technologies including oneAPI tools can give to the PostgreSQL project community

  • Alexandra Kuznetsova
    Alexandra Kuznetsova Postgres Professional
    22 мин

    Mamonsu 3.0: New Features

    Mamonsu is an active monitoring agent for PostgreSQL based on Zabbix. Mamonsu 3.0 Major Update includes new metrics and more possibilities for data visualization via Zabbix screens. It also introduces the improved functionality of Mamonsu tools for interacting with the DBMS. In addition to the new functionality overview, I will also share the nuances of upgrading to the 3.0 version.

  • Oleg Bartunov
    Oleg Bartunov Postgres Professional
    45 мин

    JSON or not JSON. Pros and cons of JSON usage

    JSON is now the de facto standard for startup developers. Why is this happening and what should be done? Should we teach application developers how to properly design a database according to the canons of relational theory (which Postgres complies very well with) or make the DBMS more JSON-friendly?

  • Ekaterina Sokolova
    Ekaterina Sokolova Postgres Professional
    22 мин

    PG_QUERY_STATE: Everything about the inner life of your queries

    When working with PostgreSQL, we regularly encounter queries that take suspiciously long to be executed. What if it's too late to enable statistics or auto explain, and cancellation of the query doesn't look sensible, but you still need to find out what caused the issue or see at what stage execution the query is? pg_query_state is an open source PostgreSQL extension, which can give you access to the query execution plan in real time. It also makes available statistics for each node, including the number of processed rows.