Runtime configuration: Performance

• Disk related:
  • checkpoint_timeout: number of seconds between checkpoints of WAL
  
  
  • commit_delay: number of micro seconds to sleep at transaction commit
  
  
  • commit_siblings: minimum number of running transactions before commit_delay is used
  
  
  • wal_sync_method: one of fsync, fdatasync, open_sync or open_datasync
  • fsync(): complete buffer written to disk
  • fdatasync(): data written to disk but not metadata
  • open_sync/open_datasync: data written by write()
  
  
  • fsync: whether to fsync() or not

Page 17