On 1.7.2014 15:55, Leonardo Rodrigues wrote:
Em 01/07/14 10:06, Eliezer Croitoru escreveu:
On 07/01/2014 03:06 PM, Jiri Bourek wrote:
That really depends, rebuilding indexes can increase your downtime for hours, so it may be better to pay a bit for extra storage space instead of not being paid at all by your customers.
Building the index as far as I remember doesn't cost in downtime but in higher I/O usage which slows down the server.
That's my knowledge as well. Rebuilt of indexes are done on-the-flywhen the account is accessed and, thus, there's no downtime involved on that.
Of course, with lots of big accounts and lots of initial accesseson the scenario where ALL accounts were restored without indexes, the I/O increase can be so high that the server will be basically unresponsive. That can happen for sure.
Exactly my point. I saw that happen once and the slowdown effectively became a downtime.
But on the more common case, which will be restoring just a fewaccounts, that I/O increase will probably be unnoticable.