What is the state of KSM/THP? Did you try disabling them ? I've seen these
can cause high iowait (although that was a virtual environment). It would be
interesting to see vmstat output.
tail /sys/kernel/mm/ksm/run
/sys/kernel/mm/transparent_hugepage/khugepaged/defrag
/sys/kernel/mm/transparent
Thanks Michael,
I am sure that there is some optimization to be found in the config (and
below are all the non-default values in the file). I suspect that they
won't explain the difference between restoring from nfs vs local drive, but
they could certainly speed up my best case. The dataset is so
Hi Ogden,
You didn't mention any details about your postgresql.conf settings. Why
don't you set them optimally for your loads and try again and see if
there is any difference. Make sure you do a DB restart since some of
these parameters require it.
==
pa
