My is Overpass server is running slowly after re-populating the database

Hi all,

I have just populated the full planet file into my database (on top of an existing UK database install) and I'm now having some problems:

1. Calling an is_in area query does not return any results for any new areas my database should now cover. It still returns the old UK areas however, but this leads me onto my second problem (possibly the same problem!)
2. An is_in area call (in the UK or otherwise) does not return any admin_level 1 or 2 information, like it does on the Overpass API public server. This didn't happen pre-full planet installation but I assumed this was due to only having the UK installed, not multiple countries.
3. The server now runs really slow! When it was just the UK, the server would process requests in a matter of milliseconds, now, since installing the planet, it takes 4-5 SECONDS to process a request! The RAM usage has escalated from ~75% while idle to ~99%. This happened before to me from populating a full UK install on top of an England only install on a different server. Restarting the server does not help.

The planet file I used is http://ftp.heanet.ie/mirrors/openstreetmap.org/planet/planet-latest.osm.bz2

I am baffled on this one and have no idea how to overcome it besides completely reinstalling the planet database. Is there a better way to solve this? Thanks!