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
