jps wrote:Arjan wrote:wbond wrote:Have you tried setting "index_files" to false?
Yes, that obviously "fixes" the problems, but I need to have it on.
It's not at all obvious to me. Just to be sure, can you confirm that you did indeed try this and that the symptoms disappeared after turning it off?
Yes, index_files=false completely solves the problem.
I have found that removing the most insanely large files makes the slowdown much less likely (there's a couple of generated >1gb text files with bulk sql commands)