Long running query during import process(more than 10.hrs) about nominatim HOT 4 CLOSED

With a dozen questions you're overusing the free community support. If your server runs out of memory you can add more memory (hardware). The installation instructions are clear that 64GB isn't enough.

from nominatim.

With a dozen questions you're overusing the free community support. If your server runs out of memory you can add more memory (hardware). The installation instructions are clear that 64GB isn't enough.

you are doing great work by answering the questions really fast and accurate , appreciating your time and efforts, sorry for overasking the question

running postgres and import process as a separate machine

Here is the postgres configuration

RAM: 128GB
number of CPUs: 64CORE
type and size of disks: nvme and 1.5TB

from nominatim.

I've seen this query run for a very long time on our production machines as well but can't reproduce it on my development server. This indicates that the queries themselves are not really the issue. My guess is that we are running into a forced vacuum again. The query updates a lot of lines in the word table. Lets see if it helps to create a new word table instead.

I don't think the memory out of bound issues are directly Nominatim's fault. Sounds more like a misconfiguration of Postgres and I tend to agree with @mtmail here that you have used up your quota for these kind of generic support questions.

from nominatim.

Closed by #3328

from nominatim.