From fd448170c5b5b8870d5e54f0622a8f151dceca34 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 13 May 2012 10:50:08 +0200 Subject: [PATCH 1/1] remove intermediate ANALYSE while indexing Autovacuum does a much better job. --- utils/setup.php | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) diff --git a/utils/setup.php b/utils/setup.php index b40bad3a..4b60815c 100755 --- a/utils/setup.php +++ b/utils/setup.php @@ -431,11 +431,7 @@ $sOutputFile = ''; if (isset($aCMDResult['index-output'])) $sOutputFile = ' -F '.$aCMDResult['index-output']; $sBaseCmd = CONST_BasePath.'/nominatim/nominatim -i -d '.$aDSNInfo['database'].' -t '.$iInstances.$sOutputFile; - passthru($sBaseCmd.' -R 4'); - pgsqlRunScript('ANALYSE'); - passthru($sBaseCmd.' -r 5 -R 25'); - pgsqlRunScript('ANALYSE'); - passthru($sBaseCmd.' -r 26'); + passthru($sBaseCmd); } if ($aCMDResult['create-search-indices'] || $aCMDResult['all']) -- 2.39.5