Schedule - PGConf.EU 2019
May the Force of hierarchical data be with you
Date: 2019-10-18
Time: 10:50–11:40
Room: Manzoni
Level: Intermediate
How to work with hierarhical data in relational databases? PostgreSQL suggests to use standard SQL way: WITH RECURSIVE common table expression, it's very flexible way to operate with such data. And it is so flexible and powerful that it makes it difficult for the optimizer, so it could demonstrate unimpressive performance. There is a more straightforward way to work with hierarhical data, the way is a ltree extension. Ltree has a long success story and I would like to show new improvements of it, such as new syntax and new index support
Slides
The following slides have been made available for this session: