|
From: | Jeroen van Rijn |
Subject: | Re: [Maposmatic-dev] maposmatic.org unreachable ? |
Date: | Thu, 4 Apr 2013 21:54:46 +0200 |
Hello Maxime,
Le 04/04/2013 20:45, Maxime Petazzoni a écrit :Yes, that's strange! Those database issues are out of my knowledge but I nonetheless think this vacuum behaviour should not occur.
Isn't postgresql vacuum process supposed to do that? Do we need aVacuum takes an exclusive lock on the database and takes (interestingly)
>cleanup process at application level?
longer than doing a full planet import.
>Doing an import on a regular basis is not sustainable.The import is actually pretty quick on SSD. But yeah, it's a bit
annoying. I was actually wondering if we should simply do a full import
every day and swap (with minutely updates in between).
So we have enough SSD space for two full imports but not enough for one full import plus several weeks/months/... of update? Therefore we clearly have an issue with vacuum. Maybe we need to trigger it more frequently, let it do its jobs by sopping updates for a while, give it more priority, etc.
But if you prefer doing a full import each 12h or 24h, that's fine for me. MapOSMatic service is still useful with such delay
[Prev in Thread] | Current Thread | [Next in Thread] |