search

CartoDB / CartoDB-basemaps

CartoDB basemaps
http://cartodb.com/basemaps
Other
55 stars 13 forks source link

Indexes on planet #49

Closed pnorman closed 8 years ago

pnorman commented 8 years ago

The mat views currently require a seq scan, filter, and sort for each update.

This might be faster with appropriate indexes, particularly for mat views which select a small portion of the table

pnorman commented 8 years ago

Alternative idea: Use non-materialized views + partial indexes for high-zoom, as performance should be similar, then low-zoom mat views will make use of those partials