NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi,
We've installed Nominatim with world data on our Kubernetes cluster. It has worked fine for several weeks, but since few days, the update is very very slow (from 4 hours to about 22 hours for the daily update).

There are no visible errors, but it seems to be stucked on the following requests at the beginning and end of ranks 26 and 30:

2012915 | nominatim | | 2019-11-04 09:09:20.100902+00 | active | select geometry_sector,count() from placex where rank_search = $1 and indexed_status > 0 group by geometry_sector order by geometry_sector
2049039 | nominatim | | 2019-11-04 09:09:20.100902+00 | active | select geometry_sector,count(
) from placex where rank_search = $1 and indexed_status > 0 group by geometry_sector order by geometry_sector
2049040 | nominatim | | 2019-11-04 09:09:20.100902+00 | active | select geometry_sector,count(*) from placex where rank_search = $1 and indexed_status > 0 group by geometry_sector order by geometry_sector

We currently use Nominatim 3.3.0, postgresql 11.2 (on a separate machine) and postgis 2.5.2
Update command : update.php --import-osmosis --osm2pgsql-cache 5000

Postgre:
Database is 700GB on SSD
cpu: 4*2.3Ghz
memory: 14GB

Updater:
cpu: 2*2.3Ghz
memory: 8GB

Postgre custom parameters:
- "shared_buffers=5GB"
- "effective_cache_size=9GB"
- "maintenance_work_mem=128MB"
- "work_mem=32MB"
- "checkpoint_completion_target=0.9"
- "random_page_cost=1.1"
- "effective_io_concurrency=500"

Thanks for any idea about why it became suddenly so slow!

asked 04 Nov '19, 09:56

web_heredis's gravatar image

web_heredis
11112
accept rate: 0%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×263
×199

question asked: 04 Nov '19, 09:56

question was seen: 1,171 times

last updated: 04 Nov '19, 09:56

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum