On 9/11/11 3:49 AM, Tim Alder wrote:
What's not good is that we have in the moment 70 seq. scans and 12 index
scans.
"vacuum full" was broken after 2.5 day.
I hope somebody else could install the postgres_upgrade_fix.
That's not so good
either.
If I understood it correctly the postgres_upgrade_fix is only relevant
if one updates postgresql. However, as far as I know, postgresql wasn't
upgraded and it is still running 8.3. So I doubt this will fix anything.
So the question is how do we fix the database corruption? Is it
necessary to do a full reimport?
In the mean time, until the corruption is fixed, can we turn off
diff-imports. They are always erroring anyway and are adding load to the
db, that could probably better be spent on rendering.
Kai