Advertisement
Guest User

pg_test_fsync sdd laptop

a guest
Nov 3rd, 2012
547
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.93 KB | None | 0 0
  1. laptop-with-ssd$ ./pg_test_fsync
  2. 2 seconds per test
  3. O_DIRECT supported on this platform for open_datasync and open_sync.
  4.  
  5. Compare file sync methods using one 8kB write:
  6. (in wal_sync_method preference order, except fdatasync
  7. is Linux's default)
  8. open_datasync 6763.868 ops/sec
  9. fdatasync 6728.882 ops/sec
  10. fsync 5137.341 ops/sec
  11. fsync_writethrough n/a
  12. open_sync 5188.053 ops/sec
  13.  
  14. Compare file sync methods using two 8kB writes:
  15. (in wal_sync_method preference order, except fdatasync
  16. is Linux's default)
  17. open_datasync 3447.229 ops/sec
  18. fdatasync 5427.153 ops/sec
  19. fsync 4307.481 ops/sec
  20. fsync_writethrough n/a
  21. open_sync 2655.900 ops/sec
  22.  
  23. Compare open_sync with different write sizes:
  24. (This is designed to compare the cost of writing 16kB
  25. in different write open_sync sizes.)
  26. 1 * 16kB open_sync write 4315.584 ops/sec
  27. 2 * 8kB open_sync writes 2577.428 ops/sec
  28. 4 * 4kB open_sync writes 1456.941 ops/sec
  29. 8 * 2kB open_sync writes 769.356 ops/sec
  30. 16 * 1kB open_sync writes 395.627 ops/sec
  31.  
  32. Test if fsync on non-write file descriptor is honored:
  33. (If the times are similar, fsync() can sync data written
  34. on a different descriptor.)
  35. write, fsync, close 4825.535 ops/sec
  36. write, close, fsync 4804.096 ops/sec
  37.  
  38. Non-Sync'ed 8kB writes:
  39. write 352346.857 ops/sec
  40.  
  41.  
  42.  
  43.  
  44. laptop-with-ssd$ sudo hdparm -i /dev/sda
  45.  
  46. /dev/sda:
  47.  
  48. Model=INTEL SSDSA2BW160G3L, FwRev=4PC1LE05
  49. ...
  50. UDMA modes: udma0 udma1 udma2 udma3 udma4 udma5 *udma6
  51. AdvancedPM=no WriteCache=enabled
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement