1PG_TEST_FSYNC(1) PostgreSQL 9.2.24 Documentation PG_TEST_FSYNC(1)
2
3
4
6 pg_test_fsync - determine fastest wal_sync_method for PostgreSQL
7
9 pg_test_fsync [option...]
10
12 pg_test_fsync is intended to give you a reasonable idea of what the
13 fastest wal_sync_method is on your specific system, as well as
14 supplying diagnostic information in the event of an identified I/O
15 problem. However, differences shown by pg_test_fsync might not make any
16 difference in real database throughput, especially since many database
17 servers are not speed-limited by their transaction logs.
18
20 pg_test_fsync accepts the following command-line options:
21
22 -f, --filename
23 Specifies the file name to write test data in. This file should be
24 in the same file system that the pg_xlog directory is or will be
25 placed in. (pg_xlog contains the WAL files.) The default is
26 pg_test_fsync.out in the current directory.
27
28 -s, --secs-per-test
29 Specifies the number of seconds for each test. The more time per
30 test, the greater the test's accuracy, but the longer it takes to
31 run. The default is 2 seconds, which allows the program to complete
32 in about 30 seconds.
33
34 -V, --version
35 Print the pg_test_fsync version and exit.
36
37 -?, --help
38 Show help about pg_test_fsync command line arguments, and exit.
39
41 Bruce Momjian <bruce@momjian.us>
42
44 postgres(1)
45
46
47
48PostgreSQL 9.2.24 2017-11-06 PG_TEST_FSYNC(1)