.............................................................................432 xi 18.5.2. Checkpoints............................................................................................... large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configura- flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 14.4.7. Disable WAL archival and streaming replication When

..................................................................................403 18.5.2. Checkpoints..............................................................................................406 large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 339 Chapter 14. Performance Tips 14.4.7. Disable WAL archival

..................................................................................379 18.5.2. Checkpoints............................................................................................... large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configura- flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 14.4.7. Turn off archive_mode When loading large amounts of

..................................................................................358 18.5.2. Checkpoints..............................................................................................360 large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 14.4.7. Turn off archive_mode When loading large amounts of

..................................................................................422 18.5.2. Checkpoints..............................................................................................425 large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 354 Chapter 14. Performance Tips 14.4.7. Disable WAL Archival

..................................................................................449 18.5.2. Checkpoints............................................................................................... large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configura- flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 14.4.7. Disable WAL Archival and Streaming Replication When

..................................................................................392 18.5.2. Checkpoints..............................................................................................394 large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 14.4.7. Turn off archive_mode When loading large amounts of

..................................................................................417 18.5.2. Checkpoints............................................................................................... large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configura- Chapter 14. Performance Tips checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 14.4.7. Turn off archive_mode When loading large amounts of

..................................................................................459 18.5.2. Checkpoints..............................................................................................462 large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 14.4.7. Disable WAL Archival and Streaming Replication When

..................................................................................488 18.5.2. Checkpoints............................................................................................... large data loads faster. This is because loading a large amount of data into PostgreSQL will cause checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configura- flushed to disk. By increasing checkpoint_segments temporarily during bulk data loads, the number of checkpoints that are required can be reduced. 412 Chapter 14. Performance Tips 14.4.7. Disable WAL Archival