We'are using Postgis to manage our geo data. They are coming from several sources, like Open street map, VPF, Shape and so on. We have defined constraints on the tables, and spatial indexes on geometry. When we perform big import or updates, it slows the process, so i drop constraints and index, do the big changes and when done i restore them.
Is it the good way to do it?
If not, is there other strategies? I've thought of using views, and defining key and index only on the views, but i don't know if it is a good idea (or even if it makes sense)
(Obviously I'm far from being a guru of PostgreSql or Postgis)
أكثر...
Is it the good way to do it?
If not, is there other strategies? I've thought of using views, and defining key and index only on the views, but i don't know if it is a good idea (or even if it makes sense)
(Obviously I'm far from being a guru of PostgreSql or Postgis)
أكثر...