>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> it's difficult to tell how much
> physical I/O results from the create or unlink syscalls. It might
be
> interesting to make a test program that just creates 4000 files
We use xfs with noatime for our databases.
In a fresh subdirectory of such a mountpoint:
for ((i=0 ; i < 4000 ; ++i)) ; do touch $i ; done
causes 44,969 block writes
> and then
> removes them again, and see what sort of load you see from that.
rm *
causes 26,820 block writes
That would make the file creation and unlink just under half the load.
-Kevin