Re: RAM-only temporary tables

>>> Tom Lane <tgl@sss.pgh.pa.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