Presented by:

4f90fa566643a3cddbf1ee2dbc4f0227

Nikita Malakhov

from Postgres Professional

Senior developer in the RnD department of Postgres Professional company

No video of the event yet, sorry!

PostgreSQL is the first relational database recognized the need of non-atomic data types in application development from science to Web. Jsonb in Postgres is the attractive feature for modern application wanted by developers as Json documents with a strong consistency and all the benefits of proven relational technology. At last SQL world has recognized the NoSQL and in 2016 released the new standard specifying the SQL/JSON data model and path language, as well as SQL commands for storing, publishing and querying JSON data. However, growing popularity of Jsonb unmasked all the hitherto hidden problems in TOAST and the way how postgres works with long values, leading to annoying performance degradation of queries with Jsonb. We will discuss and demonstrate how to overcome the problem and to make the Json TOASTs crispy and tasty! We hope to push some of the improvements to PG17 and make use of Jsonb easier and more attractive.

Date:
2024 February 29 - 14:45
Duration:
40 min
Room:
Grand Victoria B
Conference:
PGConf India, 2024
Language:
Track:
Database Engine Developers
Difficulty:
Medium

Happening at the same time:

  1. PostgreSQL Unboxed: Leveraging Containerization for Scalable Database Deployments
  2. Start Time:
    2024 February 29 14:45

    Room:
    Robusta + Arabica

  3. Postgres Monitoring: A Practical Peek Under the Hood
  4. Start Time:
    2024 February 29 14:45

    Room:
    Grand Victoria A