> The disk used for the data is an external raid array, I don't know much > about that right now except I think is some relatively fast IDE stuff. > In any case the operations should be cache friendly, we don't scan over > and over the big tables...
Maybe you are I/O bound. Do you know if your RAID array is caching your writes? Easy way to check is to run fsync off and look for obvious performance differences. Maybe playing with sync method could help here. Merlin ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly