Changes between Initial Version and Version 1 of Ticket #3739, comment 29


Ignore:
Timestamp:
Jun 5, 2017, 10:50:26 PM (7 years ago)
Author:
komzpa

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #3739, comment 29

    initial v1  
    1010 - kill postgis statistics using CLUSTER. Vacuum will come anyway and re-collect it, so a short-term thing to use in scripts;
    1111 - bump work_mem to tremendously large values (20GB on my machine), so it thinks the intermediate result will fit into it anyway;
     12 - filter the admin boundaries into separate table, with separate smaller statistics;
    1213 - repeat the operator more times. Selectivity is still < 100%, each repeat will multiply it by itself, getting it lower and lower.
     14
     15Not tested myself but worth a try:
     16 - create a partial gist, `create index on planet_osm_polygon using gist (way) where ap.tags?'ISO3166-1';`