reduce limits on high loads and order results correctly

[nominatim.git] / utils / setup.php

diff --git a/utils/setup.php b/utils/setup.php
index 049ef860d2a9b933a9facee787e3ec92dc6be3a2..fb83dd0aa9fbc02aad2ed0c07075917f940395a5 100755 (executable)
--- a/utils/setup.php
+++ b/utils/setup.php
@@ -126,8 +126,9 @@
                        echo "Please download and build osm2pgsql.\nIf it is already installed, check the path in your local settings (settings/local.php) file.\n";
                        fail("osm2pgsql not found in '$osm2pgsql'");
                }
                        echo "Please download and build osm2pgsql.\nIf it is already installed, check the path in your local settings (settings/local.php) file.\n";
                        fail("osm2pgsql not found in '$osm2pgsql'");
                }

+               $osm2pgsql .= ' --tablespace-slim-index ssd --tablespace-main-index ssd --tablespace-main-data ssd --tablespace-slim-data data';

                $osm2pgsql .= ' -lsc -O gazetteer --hstore';
                $osm2pgsql .= ' -lsc -O gazetteer --hstore';

-               $osm2pgsql .= ' -C '.$iCacheMemory;
+               $osm2pgsql .= ' -C 16000';

                $osm2pgsql .= ' -d '.$aDSNInfo['database'].' '.$aCMDResult['osm-file'];
                passthruCheckReturn($osm2pgsql);
 
                $osm2pgsql .= ' -d '.$aDSNInfo['database'].' '.$aCMDResult['osm-file'];
                passthruCheckReturn($osm2pgsql);
 


@@ -320,6 +321,7 @@
                        echo '.';
                }
                echo "\n";
                        echo '.';
                }
                echo "\n";

+               pgsqlRunScript('ALTER TABLE place SET TABLESPACE "data"');

                echo "Reanalysing database...\n";
                pgsqlRunScript('ANALYSE');
        }
                echo "Reanalysing database...\n";
                pgsqlRunScript('ANALYSE');
        }