[Perf] Improve PostGIS performance by removing CTEs

StationA / tilenol

Scalable, multi-backend geo vector tile server

MIT License

22 stars 6 forks source link

[Perf] Improve PostGIS performance by removing CTEs #46

Closed jerluc closed 3 years ago

jerluc commented 3 years ago

This small changeset dramatically improves the performance of several classes of SQL queries by using a simple sub-query for tableExpression rather than a CTE.

madhulikajc commented 3 years ago

Looks great, thanks for including me! Should the comment in line 49 change?