Conference 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


Fedor Sigaev