>>> Tom Lane <[EMAIL PROTECTED]> 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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
