Sometimes, when doing an update on a specific table record, i get this error:
index "myIndexName" contains corrupted page at block 468 Please REINDEX it.
But on the next update it works, without having to do a reindex. What can cause this issue? Is there a way to prevent this error?
This index is only there to speed up performance on queries, but i'm seriously wanting to drop it to prevent information loss if i can't find a solution.
My postgres version is 9.3.9