Alexander DunkelToday, I discovered that Postgres materialized views do _not_ inherit their parent table's indexes. This is why my spatial query is still running after 24hours.. 9000 × 50,000,000 = 450 billion geometry comparisons. Doh!
Today, I discovered that Postgres materialized views do _not_ inherit their parent table's indexes. This is why my spatial query is still running after 24hours.. 9000 × 50,000,000 = 450 billion geometry comparisons. Doh!