How to make a Django + PostgreSQL recursive query?

Question

PostgreSQL

Hello!
There is a model:

class Task(models.Model):
    title = models.CharField()
    relates_to = models.ForeignKey('self')

Is it possible to get the chain with a single request?

Answer 1

Might be worth considering MPTT ( django-mptt ). Natively, without crutches, without recursions, the fastest read requests, a subtree with 12 levels and 4 sons for each internal node, is obtained in one request (instead of 5.5 million requests).
Of the minuses - a long time to record.