Comment on Degrees of Kevin Bacon Using PostgresComments−anotherevan2yFor slow changing, read-heavy scenarios like this, make your recursive CTE a materialised view and whack some indexes on it for big performance gains.
Comments
For slow changing, read-heavy scenarios like this, make your recursive CTE a materialised view and whack some indexes on it for big performance gains.