PostgreSQL Source Code  git master
pg_test_fsync.c File Reference
#include "postgres_fe.h"
#include <limits.h>
#include <sys/stat.h>
#include <sys/time.h>
#include <fcntl.h>
#include <unistd.h>
#include <signal.h>
#include "access/xlogdefs.h"
#include "common/logging.h"
#include "getopt_long.h"
Include dependency graph for pg_test_fsync.c:

Go to the source code of this file.

Macros

#define FSYNC_FILENAME   "./pg_test_fsync.out"
 
#define XLOG_BLCKSZ_K   (XLOG_BLCKSZ / 1024)
 
#define LABEL_FORMAT   " %-30s"
 
#define NA_FORMAT   "%21s\n"
 
#define OPS_FORMAT   gettext_noop("%13.3f ops/sec %6.0f usecs/op\n")
 
#define USECS_SEC   1000000
 
#define START_TIMER
 
#define STOP_TIMER
 
#define die(msg)   do { pg_log_error("%s: %m", _(msg)); exit(1); } while(0)
 

Functions

static void handle_args (int argc, char *argv[])
 
static void prepare_buf (void)
 
static void test_open (void)
 
static void test_non_sync (void)
 
static void test_sync (int writes_per_op)
 
static void test_open_syncs (void)
 
static void test_open_sync (const char *msg, int writes_size)
 
static void test_file_descriptor_sync (void)
 
static void process_alarm (int sig)
 
static void signal_cleanup (int sig)
 
static void print_elapse (struct timeval start_t, struct timeval stop_t, int ops)
 
int main (int argc, char *argv[])
 

Variables

static const char * progname
 
static unsigned int secs_per_test = 5
 
static int needs_unlink = 0
 
static char full_buf [DEFAULT_XLOG_SEG_SIZE]
 
static char * buf
 
static char * filename = FSYNC_FILENAME
 
static struct timeval start_t stop_t
 
static bool alarm_triggered = false
 

Macro Definition Documentation

◆ die

◆ FSYNC_FILENAME

#define FSYNC_FILENAME   "./pg_test_fsync.out"

Definition at line 24 of file pg_test_fsync.c.

◆ LABEL_FORMAT

#define LABEL_FORMAT   " %-30s"

◆ NA_FORMAT

#define NA_FORMAT   "%21s\n"

Definition at line 29 of file pg_test_fsync.c.

Referenced by test_open_sync(), and test_sync().

◆ OPS_FORMAT

#define OPS_FORMAT   gettext_noop("%13.3f ops/sec %6.0f usecs/op\n")

Definition at line 31 of file pg_test_fsync.c.

Referenced by print_elapse().

◆ START_TIMER

#define START_TIMER
Value:
do { \
alarm_triggered = false; \
alarm(secs_per_test); \
gettimeofday(&start_t, NULL); \
} while (0)
static unsigned int secs_per_test
Definition: pg_test_fsync.c:66

Definition at line 36 of file pg_test_fsync.c.

Referenced by test_file_descriptor_sync(), test_non_sync(), test_open_sync(), and test_sync().

◆ STOP_TIMER

#define STOP_TIMER
Value:
do { \
gettimeofday(&stop_t, NULL); \
print_elapse(start_t, stop_t, ops); \
} while (0)
static struct timeval start_t stop_t
Definition: pg_test_fsync.c:71

Definition at line 57 of file pg_test_fsync.c.

Referenced by test_file_descriptor_sync(), test_non_sync(), test_open_sync(), and test_sync().

◆ USECS_SEC

#define USECS_SEC   1000000

Definition at line 32 of file pg_test_fsync.c.

Referenced by print_elapse().

◆ XLOG_BLCKSZ_K

#define XLOG_BLCKSZ_K   (XLOG_BLCKSZ / 1024)

Definition at line 26 of file pg_test_fsync.c.

Referenced by test_non_sync(), and test_sync().

Function Documentation

◆ handle_args()

static void handle_args ( int  argc,
char *  argv[] 
)
static

Definition at line 142 of file pg_test_fsync.c.

References _, filename, fprintf, getopt_long(), ngettext, optarg, optind, pg_log_error, pg_strdup(), printf, progname, required_argument, and secs_per_test.

Referenced by main().

143 {
144  static struct option long_options[] = {
145  {"filename", required_argument, NULL, 'f'},
146  {"secs-per-test", required_argument, NULL, 's'},
147  {NULL, 0, NULL, 0}
148  };
149 
150  int option; /* Command line option */
151  int optindex = 0; /* used by getopt_long */
152  unsigned long optval; /* used for option parsing */
153  char *endptr;
154 
155  if (argc > 1)
156  {
157  if (strcmp(argv[1], "--help") == 0 || strcmp(argv[1], "-?") == 0)
158  {
159  printf(_("Usage: %s [-f FILENAME] [-s SECS-PER-TEST]\n"), progname);
160  exit(0);
161  }
162  if (strcmp(argv[1], "--version") == 0 || strcmp(argv[1], "-V") == 0)
163  {
164  puts("pg_test_fsync (PostgreSQL) " PG_VERSION);
165  exit(0);
166  }
167  }
168 
169  while ((option = getopt_long(argc, argv, "f:s:",
170  long_options, &optindex)) != -1)
171  {
172  switch (option)
173  {
174  case 'f':
176  break;
177 
178  case 's':
179  errno = 0;
180  optval = strtoul(optarg, &endptr, 10);
181 
182  if (endptr == optarg || *endptr != '\0' ||
183  errno != 0 || optval != (unsigned int) optval)
184  {
185  pg_log_error("invalid argument for option %s", "--secs-per-test");
186  fprintf(stderr, _("Try \"%s --help\" for more information.\n"), progname);
187  exit(1);
188  }
189 
190  secs_per_test = (unsigned int) optval;
191  if (secs_per_test == 0)
192  {
193  pg_log_error("%s must be in range %u..%u",
194  "--secs-per-test", 1, UINT_MAX);
195  exit(1);
196  }
197  break;
198 
199  default:
200  fprintf(stderr, _("Try \"%s --help\" for more information.\n"),
201  progname);
202  exit(1);
203  break;
204  }
205  }
206 
207  if (argc > optind)
208  {
209  pg_log_error("too many command-line arguments (first is \"%s\")",
210  argv[optind]);
211  fprintf(stderr, _("Try \"%s --help\" for more information.\n"),
212  progname);
213  exit(1);
214  }
215 
216  printf(ngettext("%u second per test\n",
217  "%u seconds per test\n",
218  secs_per_test),
219  secs_per_test);
220 #if PG_O_DIRECT != 0
221  printf(_("O_DIRECT supported on this platform for open_datasync and open_sync.\n"));
222 #else
223  printf(_("Direct I/O is not supported on this platform.\n"));
224 #endif
225 }
static char * filename
Definition: pg_test_fsync.c:70
#define pg_log_error(...)
Definition: logging.h:80
int getopt_long(int argc, char *const argv[], const char *optstring, const struct option *longopts, int *longindex)
Definition: getopt_long.c:57
#define printf(...)
Definition: port.h:221
#define fprintf
Definition: port.h:219
#define required_argument
Definition: getopt_long.h:25
int optind
Definition: getopt.c:50
static const char * progname
Definition: pg_test_fsync.c:64
char * pg_strdup(const char *in)
Definition: fe_memutils.c:85
#define ngettext(s, p, n)
Definition: c.h:1124
static unsigned int secs_per_test
Definition: pg_test_fsync.c:66
char * optarg
Definition: getopt.c:52
#define _(x)
Definition: elog.c:88

◆ main()

int main ( int  argc,
char *  argv[] 
)

Definition at line 101 of file pg_test_fsync.c.

References filename, get_progname(), handle_args(), pg_logging_init(), PG_TEXTDOMAIN, pqsignal(), prepare_buf(), process_alarm(), progname, set_pglocale_pgservice(), SIGALRM, SIGHUP, signal_cleanup(), test_file_descriptor_sync(), test_non_sync(), test_open(), test_open_syncs(), and test_sync().

102 {
103  pg_logging_init(argv[0]);
104  set_pglocale_pgservice(argv[0], PG_TEXTDOMAIN("pg_test_fsync"));
105  progname = get_progname(argv[0]);
106 
107  handle_args(argc, argv);
108 
109  /* Prevent leaving behind the test file */
110  pqsignal(SIGINT, signal_cleanup);
111  pqsignal(SIGTERM, signal_cleanup);
112 #ifndef WIN32
114 #endif
115 #ifdef SIGHUP
116  /* Not defined on win32 */
118 #endif
119 
120  prepare_buf();
121 
122  test_open();
123 
124  /* Test using 1 XLOG_BLCKSZ write */
125  test_sync(1);
126 
127  /* Test using 2 XLOG_BLCKSZ writes */
128  test_sync(2);
129 
130  test_open_syncs();
131 
133 
134  test_non_sync();
135 
136  unlink(filename);
137 
138  return 0;
139 }
static void test_sync(int writes_per_op)
static char * filename
Definition: pg_test_fsync.c:70
const char * get_progname(const char *argv0)
Definition: path.c:453
void pg_logging_init(const char *argv0)
Definition: logging.c:81
static void test_open(void)
static void prepare_buf(void)
static const char * progname
Definition: pg_test_fsync.c:64
#define SIGHUP
Definition: win32_port.h:159
#define PG_TEXTDOMAIN(domain)
Definition: c.h:1157
static void test_open_syncs(void)
static void test_non_sync(void)
static void process_alarm(int sig)
pqsigfunc pqsignal(int signum, pqsigfunc handler)
Definition: signal.c:170
static void signal_cleanup(int sig)
#define SIGALRM
Definition: win32_port.h:165
void set_pglocale_pgservice(const char *argv0, const char *app)
Definition: exec.c:434
static void test_file_descriptor_sync(void)
static void handle_args(int argc, char *argv[])

◆ prepare_buf()

static void prepare_buf ( void  )
static

Definition at line 228 of file pg_test_fsync.c.

References buf, DEFAULT_XLOG_SEG_SIZE, full_buf, random(), and TYPEALIGN.

Referenced by main().

229 {
230  int ops;
231 
232  /* write random data into buffer */
233  for (ops = 0; ops < DEFAULT_XLOG_SEG_SIZE; ops++)
234  full_buf[ops] = random();
235 
236  buf = (char *) TYPEALIGN(XLOG_BLCKSZ, full_buf);
237 }
long random(void)
Definition: random.c:22
#define DEFAULT_XLOG_SEG_SIZE
static char full_buf[DEFAULT_XLOG_SEG_SIZE]
Definition: pg_test_fsync.c:68
static char * buf
Definition: pg_test_fsync.c:68
#define TYPEALIGN(ALIGNVAL, LEN)
Definition: c.h:692

◆ print_elapse()

static void print_elapse ( struct timeval  start_t,
struct timeval  stop_t,
int  ops 
)
static

Definition at line 599 of file pg_test_fsync.c.

References _, OPS_FORMAT, printf, and USECS_SEC.

600 {
601  double total_time = (stop_t.tv_sec - start_t.tv_sec) +
602  (stop_t.tv_usec - start_t.tv_usec) * 0.000001;
603  double per_second = ops / total_time;
604  double avg_op_time_us = (total_time / ops) * USECS_SEC;
605 
606  printf(_(OPS_FORMAT), per_second, avg_op_time_us);
607 }
#define USECS_SEC
Definition: pg_test_fsync.c:32
#define printf(...)
Definition: port.h:221
static struct timeval start_t stop_t
Definition: pg_test_fsync.c:71
#define OPS_FORMAT
Definition: pg_test_fsync.c:31
#define _(x)
Definition: elog.c:88

◆ process_alarm()

static void process_alarm ( int  sig)
static

Definition at line 611 of file pg_test_fsync.c.

References alarm_triggered, and secs_per_test.

Referenced by main().

612 {
613  alarm_triggered = true;
614 }
static bool alarm_triggered
Definition: pg_test_fsync.c:73

◆ signal_cleanup()

static void signal_cleanup ( int  sig)
static

Definition at line 569 of file pg_test_fsync.c.

References fd(), filename, needs_unlink, and pg_fsync_writethrough().

Referenced by main().

570 {
571  /* Delete the file if it exists. Ignore errors */
572  if (needs_unlink)
573  unlink(filename);
574  /* Finish incomplete line on stdout */
575  puts("");
576  exit(signum);
577 }
static char * filename
Definition: pg_test_fsync.c:70
static int needs_unlink
Definition: pg_test_fsync.c:67

◆ test_file_descriptor_sync()

static void test_file_descriptor_sync ( void  )
static

Definition at line 475 of file pg_test_fsync.c.

References _, alarm_triggered, buf, close, die, filename, fsync, LABEL_FORMAT, PG_BINARY, printf, START_TIMER, generate_unaccent_rules::stdout, STOP_TIMER, and write.

Referenced by main().

476 {
477  int tmpfile,
478  ops;
479 
480  /*
481  * Test whether fsync can sync data written on a different descriptor for
482  * the same file. This checks the efficiency of multi-process fsyncs
483  * against the same file. Possibly this should be done with writethrough
484  * on platforms which support it.
485  */
486  printf(_("\nTest if fsync on non-write file descriptor is honored:\n"));
487  printf(_("(If the times are similar, fsync() can sync data written on a different\n"
488  "descriptor.)\n"));
489 
490  /*
491  * first write, fsync and close, which is the normal behavior without
492  * multiple descriptors
493  */
494  printf(LABEL_FORMAT, "write, fsync, close");
495  fflush(stdout);
496 
497  START_TIMER;
498  for (ops = 0; alarm_triggered == false; ops++)
499  {
500  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
501  die("could not open output file");
502  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
503  die("write failed");
504  if (fsync(tmpfile) != 0)
505  die("fsync failed");
506  close(tmpfile);
507 
508  /*
509  * open and close the file again to be consistent with the following
510  * test
511  */
512  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
513  die("could not open output file");
514  close(tmpfile);
515  }
516  STOP_TIMER;
517 
518  /*
519  * Now open, write, close, open again and fsync This simulates processes
520  * fsyncing each other's writes.
521  */
522  printf(LABEL_FORMAT, "write, close, fsync");
523  fflush(stdout);
524 
525  START_TIMER;
526  for (ops = 0; alarm_triggered == false; ops++)
527  {
528  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
529  die("could not open output file");
530  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
531  die("write failed");
532  close(tmpfile);
533  /* reopen file */
534  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
535  die("could not open output file");
536  if (fsync(tmpfile) != 0)
537  die("fsync failed");
538  close(tmpfile);
539  }
540  STOP_TIMER;
541 }
static char * filename
Definition: pg_test_fsync.c:70
#define write(a, b, c)
Definition: win32.h:14
#define printf(...)
Definition: port.h:221
#define PG_BINARY
Definition: c.h:1213
static bool alarm_triggered
Definition: pg_test_fsync.c:73
#define fsync(fd)
Definition: win32_port.h:68
static char * buf
Definition: pg_test_fsync.c:68
#define STOP_TIMER
Definition: pg_test_fsync.c:57
#define LABEL_FORMAT
Definition: pg_test_fsync.c:28
#define START_TIMER
Definition: pg_test_fsync.c:36
#define close(a)
Definition: win32.h:12
#define _(x)
Definition: elog.c:88
#define die(msg)
Definition: pg_test_fsync.c:97

◆ test_non_sync()

static void test_non_sync ( void  )
static

Definition at line 544 of file pg_test_fsync.c.

References _, alarm_triggered, buf, close, die, filename, LABEL_FORMAT, PG_BINARY, printf, START_TIMER, generate_unaccent_rules::stdout, STOP_TIMER, write, and XLOG_BLCKSZ_K.

Referenced by main().

545 {
546  int tmpfile,
547  ops;
548 
549  /*
550  * Test a simple write without fsync
551  */
552  printf(_("\nNon-sync'ed %dkB writes:\n"), XLOG_BLCKSZ_K);
553  printf(LABEL_FORMAT, "write");
554  fflush(stdout);
555 
556  START_TIMER;
557  for (ops = 0; alarm_triggered == false; ops++)
558  {
559  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
560  die("could not open output file");
561  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
562  die("write failed");
563  close(tmpfile);
564  }
565  STOP_TIMER;
566 }
static char * filename
Definition: pg_test_fsync.c:70
#define write(a, b, c)
Definition: win32.h:14
#define printf(...)
Definition: port.h:221
#define PG_BINARY
Definition: c.h:1213
static bool alarm_triggered
Definition: pg_test_fsync.c:73
static char * buf
Definition: pg_test_fsync.c:68
#define XLOG_BLCKSZ_K
Definition: pg_test_fsync.c:26
#define STOP_TIMER
Definition: pg_test_fsync.c:57
#define LABEL_FORMAT
Definition: pg_test_fsync.c:28
#define START_TIMER
Definition: pg_test_fsync.c:36
#define close(a)
Definition: win32.h:12
#define _(x)
Definition: elog.c:88
#define die(msg)
Definition: pg_test_fsync.c:97

◆ test_open()

static void test_open ( void  )
static

Definition at line 240 of file pg_test_fsync.c.

References close, DEFAULT_XLOG_SEG_SIZE, die, filename, fsync, full_buf, needs_unlink, PG_BINARY, S_IRUSR, S_IWUSR, and write.

Referenced by main().

241 {
242  int tmpfile;
243 
244  /*
245  * test if we can open the target file
246  */
247  if ((tmpfile = open(filename, O_RDWR | O_CREAT | PG_BINARY, S_IRUSR | S_IWUSR)) == -1)
248  die("could not open output file");
249  needs_unlink = 1;
250  if (write(tmpfile, full_buf, DEFAULT_XLOG_SEG_SIZE) !=
252  die("write failed");
253 
254  /* fsync now so that dirty buffers don't skew later tests */
255  if (fsync(tmpfile) != 0)
256  die("fsync failed");
257 
258  close(tmpfile);
259 }
static char * filename
Definition: pg_test_fsync.c:70
#define write(a, b, c)
Definition: win32.h:14
#define DEFAULT_XLOG_SEG_SIZE
#define PG_BINARY
Definition: c.h:1213
static char full_buf[DEFAULT_XLOG_SEG_SIZE]
Definition: pg_test_fsync.c:68
#define fsync(fd)
Definition: win32_port.h:68
#define S_IWUSR
Definition: win32_port.h:283
#define S_IRUSR
Definition: win32_port.h:280
static int needs_unlink
Definition: pg_test_fsync.c:67
#define close(a)
Definition: win32.h:12
#define die(msg)
Definition: pg_test_fsync.c:97

◆ test_open_sync()

static void test_open_sync ( const char *  msg,
int  writes_size 
)
static

Definition at line 440 of file pg_test_fsync.c.

References _, alarm_triggered, buf, close, die, filename, LABEL_FORMAT, NA_FORMAT, PG_BINARY, PG_O_DIRECT, printf, START_TIMER, generate_unaccent_rules::stdout, STOP_TIMER, and write.

Referenced by test_open_syncs().

441 {
442 #ifdef OPEN_SYNC_FLAG
443  int tmpfile,
444  ops,
445  writes;
446 #endif
447 
448  printf(LABEL_FORMAT, msg);
449  fflush(stdout);
450 
451 #ifdef OPEN_SYNC_FLAG
452  if ((tmpfile = open(filename, O_RDWR | OPEN_SYNC_FLAG | PG_O_DIRECT | PG_BINARY, 0)) == -1)
453  printf(NA_FORMAT, _("n/a*"));
454  else
455  {
456  START_TIMER;
457  for (ops = 0; alarm_triggered == false; ops++)
458  {
459  for (writes = 0; writes < 16 / writes_size; writes++)
460  if (write(tmpfile, buf, writes_size * 1024) !=
461  writes_size * 1024)
462  die("write failed");
463  if (lseek(tmpfile, 0, SEEK_SET) == -1)
464  die("seek failed");
465  }
466  STOP_TIMER;
467  close(tmpfile);
468  }
469 #else
470  printf(NA_FORMAT, _("n/a"));
471 #endif
472 }
#define PG_O_DIRECT
Definition: xlogdefs.h:72
static char * filename
Definition: pg_test_fsync.c:70
#define write(a, b, c)
Definition: win32.h:14
#define printf(...)
Definition: port.h:221
#define PG_BINARY
Definition: c.h:1213
static bool alarm_triggered
Definition: pg_test_fsync.c:73
static char * buf
Definition: pg_test_fsync.c:68
#define NA_FORMAT
Definition: pg_test_fsync.c:29
#define STOP_TIMER
Definition: pg_test_fsync.c:57
#define LABEL_FORMAT
Definition: pg_test_fsync.c:28
#define START_TIMER
Definition: pg_test_fsync.c:36
#define close(a)
Definition: win32.h:12
#define _(x)
Definition: elog.c:88
#define die(msg)
Definition: pg_test_fsync.c:97

◆ test_open_syncs()

static void test_open_syncs ( void  )
static

Definition at line 423 of file pg_test_fsync.c.

References _, printf, and test_open_sync().

Referenced by main().

424 {
425  printf(_("\nCompare open_sync with different write sizes:\n"));
426  printf(_("(This is designed to compare the cost of writing 16kB in different write\n"
427  "open_sync sizes.)\n"));
428 
429  test_open_sync(_(" 1 * 16kB open_sync write"), 16);
430  test_open_sync(_(" 2 * 8kB open_sync writes"), 8);
431  test_open_sync(_(" 4 * 4kB open_sync writes"), 4);
432  test_open_sync(_(" 8 * 2kB open_sync writes"), 2);
433  test_open_sync(_("16 * 1kB open_sync writes"), 1);
434 }
#define printf(...)
Definition: port.h:221
#define _(x)
Definition: elog.c:88
static void test_open_sync(const char *msg, int writes_size)

◆ test_sync()

static void test_sync ( int  writes_per_op)
static

Definition at line 262 of file pg_test_fsync.c.

References _, alarm_triggered, buf, close, die, filename, fsync, LABEL_FORMAT, NA_FORMAT, O_DSYNC, PG_BINARY, pg_fsync_writethrough(), PG_O_DIRECT, printf, START_TIMER, generate_unaccent_rules::stdout, STOP_TIMER, write, and XLOG_BLCKSZ_K.

Referenced by main().

263 {
264  int tmpfile,
265  ops,
266  writes;
267  bool fs_warning = false;
268 
269  if (writes_per_op == 1)
270  printf(_("\nCompare file sync methods using one %dkB write:\n"), XLOG_BLCKSZ_K);
271  else
272  printf(_("\nCompare file sync methods using two %dkB writes:\n"), XLOG_BLCKSZ_K);
273  printf(_("(in wal_sync_method preference order, except fdatasync is Linux's default)\n"));
274 
275  /*
276  * Test open_datasync if available
277  */
278  printf(LABEL_FORMAT, "open_datasync");
279  fflush(stdout);
280 
281 #ifdef OPEN_DATASYNC_FLAG
282  if ((tmpfile = open(filename, O_RDWR | O_DSYNC | PG_O_DIRECT | PG_BINARY, 0)) == -1)
283  {
284  printf(NA_FORMAT, _("n/a*"));
285  fs_warning = true;
286  }
287  else
288  {
289  START_TIMER;
290  for (ops = 0; alarm_triggered == false; ops++)
291  {
292  for (writes = 0; writes < writes_per_op; writes++)
293  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
294  die("write failed");
295  if (lseek(tmpfile, 0, SEEK_SET) == -1)
296  die("seek failed");
297  }
298  STOP_TIMER;
299  close(tmpfile);
300  }
301 #else
302  printf(NA_FORMAT, _("n/a"));
303 #endif
304 
305 /*
306  * Test fdatasync if available
307  */
308  printf(LABEL_FORMAT, "fdatasync");
309  fflush(stdout);
310 
311 #ifdef HAVE_FDATASYNC
312  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
313  die("could not open output file");
314  START_TIMER;
315  for (ops = 0; alarm_triggered == false; ops++)
316  {
317  for (writes = 0; writes < writes_per_op; writes++)
318  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
319  die("write failed");
320  fdatasync(tmpfile);
321  if (lseek(tmpfile, 0, SEEK_SET) == -1)
322  die("seek failed");
323  }
324  STOP_TIMER;
325  close(tmpfile);
326 #else
327  printf(NA_FORMAT, _("n/a"));
328 #endif
329 
330 /*
331  * Test fsync
332  */
333  printf(LABEL_FORMAT, "fsync");
334  fflush(stdout);
335 
336  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
337  die("could not open output file");
338  START_TIMER;
339  for (ops = 0; alarm_triggered == false; ops++)
340  {
341  for (writes = 0; writes < writes_per_op; writes++)
342  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
343  die("write failed");
344  if (fsync(tmpfile) != 0)
345  die("fsync failed");
346  if (lseek(tmpfile, 0, SEEK_SET) == -1)
347  die("seek failed");
348  }
349  STOP_TIMER;
350  close(tmpfile);
351 
352 /*
353  * If fsync_writethrough is available, test as well
354  */
355  printf(LABEL_FORMAT, "fsync_writethrough");
356  fflush(stdout);
357 
358 #ifdef HAVE_FSYNC_WRITETHROUGH
359  if ((tmpfile = open(filename, O_RDWR | PG_BINARY, 0)) == -1)
360  die("could not open output file");
361  START_TIMER;
362  for (ops = 0; alarm_triggered == false; ops++)
363  {
364  for (writes = 0; writes < writes_per_op; writes++)
365  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
366  die("write failed");
367  if (pg_fsync_writethrough(tmpfile) != 0)
368  die("fsync failed");
369  if (lseek(tmpfile, 0, SEEK_SET) == -1)
370  die("seek failed");
371  }
372  STOP_TIMER;
373  close(tmpfile);
374 #else
375  printf(NA_FORMAT, _("n/a"));
376 #endif
377 
378 /*
379  * Test open_sync if available
380  */
381  printf(LABEL_FORMAT, "open_sync");
382  fflush(stdout);
383 
384 #ifdef OPEN_SYNC_FLAG
385  if ((tmpfile = open(filename, O_RDWR | OPEN_SYNC_FLAG | PG_O_DIRECT | PG_BINARY, 0)) == -1)
386  {
387  printf(NA_FORMAT, _("n/a*"));
388  fs_warning = true;
389  }
390  else
391  {
392  START_TIMER;
393  for (ops = 0; alarm_triggered == false; ops++)
394  {
395  for (writes = 0; writes < writes_per_op; writes++)
396  if (write(tmpfile, buf, XLOG_BLCKSZ) != XLOG_BLCKSZ)
397 
398  /*
399  * This can generate write failures if the filesystem has
400  * a large block size, e.g. 4k, and there is no support
401  * for O_DIRECT writes smaller than the file system block
402  * size, e.g. XFS.
403  */
404  die("write failed");
405  if (lseek(tmpfile, 0, SEEK_SET) == -1)
406  die("seek failed");
407  }
408  STOP_TIMER;
409  close(tmpfile);
410  }
411 #else
412  printf(NA_FORMAT, _("n/a"));
413 #endif
414 
415  if (fs_warning)
416  {
417  printf(_("* This file system and its mount options do not support direct\n"
418  " I/O, e.g. ext4 in journaled mode.\n"));
419  }
420 }
#define PG_O_DIRECT
Definition: xlogdefs.h:72
static char * filename
Definition: pg_test_fsync.c:70
#define write(a, b, c)
Definition: win32.h:14
int pg_fsync_writethrough(int fd)
Definition: fd.c:413
#define printf(...)
Definition: port.h:221
#define PG_BINARY
Definition: c.h:1213
static bool alarm_triggered
Definition: pg_test_fsync.c:73
#define fsync(fd)
Definition: win32_port.h:68
static char * buf
Definition: pg_test_fsync.c:68
#define NA_FORMAT
Definition: pg_test_fsync.c:29
#define XLOG_BLCKSZ_K
Definition: pg_test_fsync.c:26
#define STOP_TIMER
Definition: pg_test_fsync.c:57
#define O_DSYNC
Definition: win32_port.h:328
#define LABEL_FORMAT
Definition: pg_test_fsync.c:28
#define START_TIMER
Definition: pg_test_fsync.c:36
#define close(a)
Definition: win32.h:12
#define _(x)
Definition: elog.c:88
#define die(msg)
Definition: pg_test_fsync.c:97

Variable Documentation

◆ alarm_triggered

bool alarm_triggered = false
static

◆ buf

char * buf
static

Definition at line 68 of file pg_test_fsync.c.

Referenced by _bt_clear_incomplete_split(), _bt_endpoint(), _bt_first(), _bt_get_endpoint(), _bt_getbuf(), _bt_getstackbuf(), _bt_killitems(), _bt_leftsib_splitflag(), _bt_moveright(), _bt_relandgetbuf(), _bt_rightsib_halfdeadflag(), _bt_unlink_halfdead_page(), _bt_walk_left(), _conv(), _discoverArchiveFormat(), _EndBlob(), _hash_doinsert(), _hash_first(), _hash_getbucketbuf_from_hashkey(), _hash_getbuf(), _hash_getbuf_with_condlock_cleanup(), _hash_getbuf_with_strategy(), _hash_getinitbuf(), _hash_getnewbuf(), _hash_init(), _hash_kill_items(), _hash_next(), _hash_readpage(), _LoadBlobs(), _PG_init(), _PrintFileData(), _skipData(), _tarAddFile(), _tarPositionTo(), _WriteBlobData(), abbroffset(), AbortBufferIO(), add_tablespace_footer(), AddFileToBackupManifest(), aes_cbc_decrypt(), AlterSequence(), appendAggOrderBy(), appendConditions(), appendContextKeyword(), appendFunctionName(), appendGroupByClause(), appendLimitClause(), appendOrderByClause(), array_dims(), array_recv(), array_send(), array_to_text_internal(), asyncQueueReadAllNotifications(), autoprewarm_database_main(), be_lo_export(), big5_to_euc_tw(), bit_recv(), boolrecv(), boolsend(), bootstrap_template1(), box_recv(), box_send(), bpcharrecv(), bqarr_in(), brin_getinsertbuffer(), brin_vacuum_scan(), brin_xlog_createidx(), brin_xlog_revmap_extend(), bringetbitmap(), brininsert(), brinsummarize(), btree_xlog_dedup(), btree_xlog_split(), btvacuumpage(), buf_init(), BufferAlloc(), build_client_final_message(), build_client_first_message(), build_regexp_match_result(), build_regexp_split_result(), BuildIndexValueDescription(), BuildParamLogString(), bytearecv(), cache_locale_time(), calc_s2k_iter_salted(), calc_s2k_salted(), calc_s2k_simple(), cash_out(), cash_recv(), cash_send(), cash_words(), charrecv(), charsend(), check_key_cksum(), check_strxfrm_bug(), check_TSCurrentConfig(), CheckForExternalTrigger(), CheckPointTwoPhase(), CheckSCRAMAuth(), checkXLogConsistency(), ChooseExtendedStatisticNameAddition(), ChooseForeignKeyConstraintNameAddition(), ChooseIndexColumnNames(), ChooseIndexNameAddition(), cidr_recv(), cidrecv(), cidsend(), circle_recv(), circle_send(), cluster_conn_opts(), compile_pltcl_function(), complex_recv(), complex_send(), ConditionalLockBuffer(), conninfo_parse(), conninfo_uri_decode(), conninfo_uri_parse_options(), constructConnStr(), convertJsonbScalar(), copy_read_data(), CopyGetInt16(), CopyGetInt32(), CopySendInt16(), CopySendInt32(), count_nondeletable_pages(), create_cursor(), createBackupLabel(), cstring_recv(), cstring_send(), cube_out(), date_out(), date_recv(), date_send(), date_test_fmt(), datum_to_json(), dblink_close(), dblink_fdw_validator(), dblink_fetch(), dblink_open(), DebugFileOpen(), decrypt_read(), DeleteAllExportedSnapshotFiles(), deparse_expression_pretty(), deparse_lquery(), deparse_ltree(), deparseAggref(), deparseArrayExpr(), deparseBoolExpr(), deparseConst(), deparseDirectDeleteSql(), deparseDirectUpdateSql(), deparseDistinctExpr(), deparseExplicitTargetList(), deparseFromExpr(), deparseFromExprForRel(), deparseFuncExpr(), deparseLockingClause(), deparseNullTest(), deparseOpExpr(), deparseScalarArrayOpExpr(), deparseSelectSql(), deparseSelectStmtForRel(), deparseSortGroupClause(), deparseSubqueryTargetList(), deparseSubscriptingRef(), describeAccessMethods(), describeAggregates(), describeFunctions(), describeOneTableDetails(), describeOneTSConfig(), describeOneTSParser(), describeOperators(), describePublications(), DescribeQuery(), describeRoles(), describeSubscriptions(), describeTableDetails(), describeTablespaces(), describeTypes(), DispatchJobForTocEntry(), do_compile(), do_lo_list(), do_setval(), domain_recv(), drainSelfPipe(), DropDatabaseBuffers(), dropRoles(), dsm_cleanup_for_mmap(), dump_lo_buf(), dumpBlobs(), dumpDatabaseConfig(), dumpGroups(), dumpRoleMembership(), dumpRoles(), dumpTablespaces(), dumpTimestamp(), dumpUserConfig(), ean13_out(), ean2isn(), EndCompressor(), enum_recv(), enum_send(), escape_param_str(), escape_xml(), euc_tw_to_big5(), ExceptionalCondition(), exec_command_password(), exec_command_sf_sv(), ExecBuildSlotPartitionKeyDescription(), ExecBuildSlotValueDescription(), ExecEvalXmlExpr(), ExecQueryUsingCursor(), executeMetaCommand(), ExecuteSimpleCommands(), ExplainPropertyFloat(), ExplainPropertyInteger(), ExplainPropertyUInteger(), exportFile(), ExportSnapshot(), file_fdw_validator(), fill_seq_with_data(), find_provider(), FindStreamingStart(), FinishPreparedTransaction(), flatten_reloptions(), flatten_set_variable_args(), float4_numeric(), float4recv(), float4send(), float8_numeric(), float8recv(), float8send(), flush_pipe_input(), fmtlong(), format_aggregate_signature(), format_operator_extended(), format_procedure_extended(), format_type_extended(), formatPGVersionNumber(), FreePageManagerDump(), FreeSpaceMapPrepareTruncateRel(), fsm_readbuf(), fsm_search(), fsm_set_and_search(), fsm_vacuum_page(), generate_opclass_name(), generate_operator_name(), generate_trgm_only(), generate_wildcard_trgm(), get_agg_expr(), get_basic_select_query(), get_coercion_expr(), get_collation_actual_version(), get_column_alias_list(), get_connect_string(), get_const_collation(), get_const_expr(), get_delete_query_def(), get_errno_symbol(), get_from_clause(), get_from_clause_coldeflist(), get_from_clause_item(), get_func_expr(), get_insert_query_def(), get_oper_expr(), get_parallel_object_list(), get_prompt(), get_query_def(), get_range_partbound_string(), get_raw_page_internal(), get_rule_expr(), get_rule_expr_funccall(), get_rule_groupingset(), get_rule_orderby(), get_rule_sortgroupclause(), get_rule_windowclause(), get_rule_windowspec(), get_select_query_def(), get_setop_query(), get_special_variable(), get_sql_delete(), get_sql_insert(), get_sql_update(), get_sublink_expr(), get_tablefunc(), get_tablesample_def(), get_target_list(), get_tuple_of_interest(), get_update_query_def(), get_update_query_targetlist_def(), get_utility_query_def(), get_values_def(), get_variable(), get_wildcard_part(), get_windowfunc_expr(), get_with_clause(), getaddrinfo(), GetBufferFromRing(), GetRecordedFreeSpace(), ginCompressPostingList(), gistfixsplit(), gnuish_strerror_r(), GROW(), handleCopyIn(), handleCopyOut(), hash_xlog_split_page(), hashbpchar(), hashbpcharextended(), hashbucketcleanup(), hashbulkdelete(), hashtext(), hashtextextended(), heap_compute_xid_horizon_for_tuples(), heap_force_common(), heap_lock_updated_tuple_rec(), heap_vacuum_rel(), heapam_relation_copy_for_cluster(), hmac_finish(), hstore_recv(), hstore_send(), hstorePairs(), ignore_boolean_expression(), importFile(), inet_recv(), infile(), init_params(), InitBufferPool(), initialize_worker_spi(), InitLocalBuffers(), int2recv(), int2send(), int2vectorrecv(), int4recv(), int4send(), int8_avg_deserialize(), int8_avg_serialize(), int8out(), int8recv(), int8send(), interval_out(), interval_recv(), interval_send(), is_true_boolean_expression(), isn_out(), json_recv(), json_send(), jsonb_agg_transfn(), jsonb_object_agg_transfn(), jsonb_recv(), jsonb_send(), JsonEncodeDateTime(), jsonpath_recv(), jsonpath_send(), jsonPathFromCstring(), jsonPathToCstring(), KnownAssignedXidsDisplay(), lazy_scan_heap(), lazy_vacuum_heap(), libpqrcv_get_conninfo(), line_recv(), line_send(), listAllDbs(), listCasts(), listCollations(), listConversions(), listDbRoleSettings(), listDefaultACLs(), listDomains(), listEventTriggers(), listExtensionContents(), listExtensions(), listForeignDataWrappers(), listForeignServers(), listForeignTables(), listLanguages(), listOneExtensionContents(), listOperatorClasses(), listOperatorFamilies(), listOpFamilyFunctions(), listOpFamilyOperators(), listPartitionedTables(), listPublications(), listSchemas(), listTables(), listTSConfigs(), listTSConfigsVerbose(), listTSDictionaries(), listTSParsers(), listTSParsersVerbose(), listTSTemplates(), listUserMappings(), llvm_create_types(), lo_export(), lo_import_internal(), load_module(), load_resultmap(), locale_date_order(), LockBuffer(), log_newpage_range(), LogicalDecodingProcessRecord(), LogicalRepApplyLoop(), lquery_in(), lquery_recv(), lquery_send(), lseg_recv(), lseg_send(), ltree_crc32_sz(), ltree_in(), ltree_recv(), ltree_send(), ltxtq_recv(), ltxtq_send(), macaddr8_recv(), macaddr8_send(), macaddr_recv(), macaddr_send(), main(), make_absolute_path(), make_ruledef(), map_sql_identifier_to_xml_name(), map_sql_value_to_xml_value(), map_xml_name_to_sql_identifier(), MemoryContextSwitchTo(), merge_children(), mp_int_read_binary(), mp_int_read_unsigned(), mp_int_sqrt(), mp_px_rand(), mxid_to_string(), namerecv(), namesend(), network_send(), next_field_expand(), next_token(), nextval_internal(), NotifyMyFrontEnd(), num_word(), numeric_abbrev_convert(), numeric_avg_deserialize(), numeric_avg_serialize(), numeric_deserialize(), numeric_poly_deserialize(), numeric_poly_serialize(), numeric_recv(), numeric_send(), numeric_serialize(), objectDescription(), oidrecv(), oidsend(), oidvectorrecv(), overwrite(), packArcInfoCmp(), pad_eme_pkcs1_v15(), parse_literal_data(), parse_lquery(), parse_ltree(), parse_snapshot(), parseAclItem(), passwordFromFile(), path_recv(), path_send(), perform_base_backup(), permissionsList(), pg_armor(), pg_b64_decode(), pg_b64_encode(), pg_base64_decode(), pg_base64_encode(), pg_ceil_log2_64(), pg_collation_actual_version(), pg_dearmor(), pg_gen_salt(), pg_gen_salt_rounds(), pg_get_constraintdef_worker(), pg_get_function_arguments(), pg_get_function_identity_arguments(), pg_get_function_result(), pg_get_functiondef(), pg_get_indexdef_worker(), pg_get_line(), pg_get_partkeydef_worker(), pg_get_ruledef_worker(), pg_get_statisticsobj_worker(), pg_get_triggerdef_worker(), pg_get_viewdef_worker(), pg_local_sendauth(), pg_log_generic_v(), pg_lsn_mi(), pg_lsn_mii(), pg_lsn_out(), pg_lsn_pli(), pg_lsn_recv(), pg_lsn_send(), pg_prewarm(), pg_saslprep(), pg_sequence_last_value(), pg_size_pretty(), pg_snapshot_recv(), pg_snapshot_send(), pg_stat_statements_internal(), pg_strerror_r(), pgp_armor_decode(), pgp_extract_armor_headers(), pgp_key_id_w(), pgp_mpi_hash(), pgp_mpi_write(), pgrowlocks(), PGSharedMemoryAttach(), pgstat_btree_page(), pgstat_gist_page(), pgstat_hash_page(), pgstathashindex(), PGTYPESdate_to_asc(), PGTYPESinterval_to_asc(), PGTYPESnumeric_div(), PGTYPEStimestamp_to_asc(), pgwin32_recv(), pgwin32_select(), pgwin32_waitforsinglesocket(), pgxmlNodeSetToText(), pickout(), PLy_exception_set(), PLy_exception_set_plural(), point_recv(), point_send(), poly_recv(), poly_send(), populate_scalar(), postgres_fdw_validator(), postgresImportForeignSchema(), PostgresMain(), postgresql_fdw_validator(), pq_sendint(), PQoidStatus(), prefix_init(), prepare_buf(), PrescanPreparedTransactions(), print_wchar_str(), PrintBufferLeakWarning(), PrintQueryStatus(), printRemoteParam(), printRemotePlaceholder(), printsimple(), printsimple_startup(), printSubscripts(), printtup(), printtup_20(), printtup_internal_20(), process_file(), process_pipe_input(), processIndirection(), ProcessStartupPacket(), ProcessTwoPhaseBuffer(), ProcSleep(), psql_get_variable(), puttzcode(), puttzcodepass(), pwdfMatchesString(), px_debug(), px_find_combo(), qtext_load_file(), queryin(), quote_qualified_identifier(), range_bound_escape(), range_deparse(), range_parse_bound(), range_recv(), range_send(), read_binary_file(), read_file_contents(), read_text_file(), read_whole_file(), ReadBufferExtended(), ReadDataFromArchiveNone(), ReadStr(), readtup_alloc(), ReadTwoPhaseFile(), ReadyForQuery(), ReceiveBackupManifestInMemoryChunk(), ReceiveCopyBegin(), ReceiveTarFile(), record_in(), record_out(), record_recv(), record_send(), RecoverPreparedTransactions(), recv_password_packet(), regression_main(), RelationCopyStorage(), ReleaseExternalFD(), repairDependencyLoop(), replace_text_regexp(), report_invalid_encoding(), report_untranslatable_char(), ResetSequence(), restore(), restoreTwoPhaseData(), revmap_physical_extend(), rewind_copy_file_range(), rm_redo_error_callback(), rstacktoodeep(), run_crypt_des(), sanitize_char(), sanitize_str(), scan_file(), search_directory(), send_message_to_frontend(), send_message_to_server_log(), sendAuthRequest(), SendBackupHeader(), SendCopyBegin(), sendFile(), sendFileWithContent(), SendFunctionResult(), SendNegotiateProtocolVersion(), SendQuery(), SendTimeLineHistory(), SendXlogRecPtrResult(), sepgsql_audit_log(), serialize_deflist(), set_backtrace(), SetWALSegSize(), sha224_bytea(), sha256_bytea(), sha384_bytea(), sha512_bytea(), show_data_directory_mode(), show_log_file_mode(), show_unix_socket_permissions(), ShowTransactionStateRec(), SPI_result_code_string(), SplitToVariants(), ssl_extension_info(), StandbyRecoverPreparedTransactions(), StandbyTransactionIdIsPrepared(), StartBufferIO(), StartLogicalReplication(), StartReplication(), StartupXLOG(), statapprox_heap(), stop_postmaster(), str_time(), StrategyGetBuffer(), string2ean(), syntax_error(), tar_getlasterror(), tarClose(), test_file_descriptor_sync(), test_non_sync(), test_open_sync(), test_sync(), textrecv(), textsend(), tidout(), tidrecv(), tidsend(), time_out(), time_recv(), time_send(), timeofday(), timestamp_out(), timestamp_recv(), timestamp_send(), timestamptz_out(), timestamptz_recv(), timestamptz_send(), timestamptz_to_str(), timetz_out(), timetz_recv(), timetz_send(), to_hex32(), to_hex64(), tokenize_file(), try_complete_step(), ts_stat_sql(), tsquery_rewrite_query(), tsvectorin(), tsvectorrecv(), tsvectorsend(), typeStringToTypeName(), unaccent_lexize(), unicode_normalize_func(), unknownrecv(), unknownsend(), UnlockBuffers(), unpack_sql_state(), uuid_generate_v1mc(), uuid_out(), vacuum_one_database(), vacuumlo(), varbit_recv(), varbit_send(), varcharrecv(), vm_readbuf(), void_send(), WaitEventSetWait(), WaitForCommands(), WALRead(), WalReceiverMain(), write_auto_conf_file(), write_csvlog(), write_target_range(), xid8recv(), xid8send(), xidrecv(), xidsend(), xlog_redo(), XLogInitBufferForRedo(), XLogInsertRecord(), XLogRecordPageWithFreeSpace(), XLOGShmemSize(), xml_out_internal(), xml_send(), xmlcomment(), xmlconcat(), xmlpi(), and xmlroot().

◆ filename

◆ full_buf

char full_buf[DEFAULT_XLOG_SEG_SIZE]
static

Definition at line 68 of file pg_test_fsync.c.

Referenced by prepare_buf(), and test_open().

◆ needs_unlink

int needs_unlink = 0
static

Definition at line 67 of file pg_test_fsync.c.

Referenced by signal_cleanup(), and test_open().

◆ progname

const char* progname
static

Definition at line 64 of file pg_test_fsync.c.

Referenced by handle_args(), and main().

◆ secs_per_test

unsigned int secs_per_test = 5
static

Definition at line 66 of file pg_test_fsync.c.

Referenced by handle_args(), and process_alarm().

◆ stop_t

struct timeval start_t stop_t
static

Definition at line 71 of file pg_test_fsync.c.