New answers tagged

1

Partitioning is most beneficial when you can couple it with a constraint that will allow the planner to exclude certain child tables entirely from most queries. Unfortunately, this currently isn't possible to do with a spatial constraint, but you might be able to take advantage of it by partitioning roads by country or state, and including the state or ...


1

One other hint is to look at the logfiles for temporary files as spatial queries are sometimes very large memory wise. You can log queries that run longer than for example 2seconds (log_min_duration_statement = 2000ms) and check if there are temporary files generated (log_temp_files =0). If you see any temporary files you can set your working memory higher. ...



Top 50 recent answers are included