1
<!-- doc/src/sgml/pgtestfsync.sgml -->
3
<refentry id="pgtestfsync">
5
<refentrytitle><application>pg_test_fsync</application></refentrytitle>
6
<manvolnum>1</manvolnum>
7
<refmiscinfo>Application</refmiscinfo>
11
<refname>pg_test_fsync</refname>
12
<refpurpose>determine fastest wal_sync_method for <productname>PostgreSQL</productname></refpurpose>
15
<indexterm zone="pgtestfsync">
16
<primary>pg_test_fsync</primary>
21
<command>pg_test_fsync</command>
22
<arg rep="repeat"><replaceable>option</replaceable></arg>
27
<title>Description</title>
30
<application>pg_test_fsync</> is intended to give you a reasonable
31
idea of what the fastest <xref linkend="guc-wal-sync-method"> is on your
33
as well as supplying diagnostic information in the event of an identified I/O
34
problem. However, differences shown by
35
<application>pg_test_fsync</application> might not make any significant
36
difference in real database throughput, especially since many database servers
37
are not speed-limited by their transaction logs.
38
<application>pg_test_fsync</application> reports average file sync operation
39
time in microseconds for each wal_sync_method, which can also be used to
40
inform efforts to optimize the value of <xref linkend="guc-commit-delay">.
45
<title>Options</title>
48
<application>pg_test_fsync</application> accepts the following
54
<term><option>-f</option></term>
55
<term><option>--filename</option></term>
58
Specifies the file name to write test data in.
59
This file should be in the same file system that the
60
<filename>pg_xlog</> directory is or will be placed in.
61
(<filename>pg_xlog</> contains the <acronym>WAL</> files.)
62
The default is <filename>pg_test_fsync.out</> in the current
69
<term><option>-s</option></term>
70
<term><option>--secs-per-test</option></term>
73
Specifies the number of seconds for each test. The more time
74
per test, the greater the test's accuracy, but the longer it takes
75
to run. The default is 5 seconds, which allows the program to
76
complete in under 2 minutes.
82
<term><option>-V</></term>
83
<term><option>--version</></term>
86
Print the <application>pg_test_fsync</application> version and exit.
92
<term><option>-?</></term>
93
<term><option>--help</></term>
96
Show help about <application>pg_test_fsync</application> command line
107
<title>Author</title>
110
Bruce Momjian <email>bruce@momjian.us</email>
115
<title>See Also</title>
117
<simplelist type="inline">
118
<member><xref linkend="app-postgres"></member>