Tom Lane a écrit :
> I think the conclusion must be that there was just too much I/O to be
> done to update all the rows. Have you done any tuning of shared_buffers
> and so forth? I recall having seen cases where update performance went
> bad as soon as the upper levels of a large index no longer fit into
> shared_buffers ...
Yes, that's probably it.
I think my raid1 array's performances are very bad.
I am switching to a brand new hardware next week, I am quite confident that this
will solve many problems.
Thanks for helping !
Regards
--
Arnaud