On Tue, Dec 07, 2004 at 09:12:18AM +0000, Simon Riggs wrote: > Not sure, as yet, what is causing effect 2. It's not related to the > kernel, but is related to user CPU and I/O waits and effects all tables > in proportion to their overall I/O usage. Some evidence that it becomes > more pronounced as CPU utilisation peaks, possibly increasing slightly > in frequency once this occurs: maybe the cache filling?
I never vacuum during the test. Is it possible that all the updates and inserts would affect this? Mark ---------------------------(end of broadcast)--------------------------- TIP 3: 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