checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration variable). Whenever a checkpoint occurs, all dirty pages must be flushed to disk. By con- nections made via a Unix-domain socket. 18.3.2. Security and Authentication authentication_timeout (integer) Maximum time to complete client authentication, in seconds. If a would-be client has not parameter can only be set in the postgresql.conf file or on the server command line. checkpoint_timeout (integer) Maximum time between automatic WAL checkpoints, in seconds. The default is five minutes

checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration variable). Whenever a checkpoint occurs, all dirty pages must be flushed to disk. By con- nections made via a Unix-domain socket. 18.3.2. Security and Authentication authentication_timeout (integer) Maximum time to complete client authentication, in seconds. If a would-be client has not postgresql.conf file or on the server command line. 360 Chapter 18. Server Configuration checkpoint_timeout (integer) Maximum time between automatic WAL checkpoints, in seconds. The default is five minutes

regular-expression search patterns from hostile sources. If you must do so, it is advisable to impose a statement timeout. Searches using SIMILAR TO patterns have the same security hazards, since SIMILAR TO provides many checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration variable). Whenever a checkpoint occurs, all dirty pages must be flushed to disk. By is no need to guard against partial page writes. • Increase checkpoint_segments and checkpoint_timeout ; this reduces the frequency of checkpoints, but increases the storage requirements of /pg_xlog.

checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration variable). Whenever a checkpoint occurs, all dirty pages must be flushed to disk. By is no need to guard against partial page writes. • Increase checkpoint_segments and checkpoint_timeout ; this reduces the frequency of checkpoints, but increases the storage requirements of /pg_xlog. not supported on Windows, and must be zero. 18.3.2. Security and Authentication authentication_timeout (integer) Maximum time to complete client authentication, in seconds. If a would-be client has not

regular-expression search patterns from hostile sources. If you must do so, it is advisable to impose a statement timeout. Searches using SIMILAR TO patterns have the same security hazards, since SIMILAR TO provides many checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout 386 Chapter 14. Performance Tips configuration variable). Whenever a checkpoint occurs, all dirty is no need to guard against partial page writes. • Increase checkpoint_segments and checkpoint_timeout; this reduces the frequency of checkpoints, but increases the storage requirements of /pg_xlog.

regular-expression search patterns from hostile sources. If you must do so, it is advisable to impose a statement timeout. Searches using SIMILAR TO patterns have the same security hazards, since SIMILAR TO provides many checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration variable). Whenever a checkpoint occurs, all dirty pages must be flushed to disk. By is no need to guard against partial page writes. • Increase checkpoint_segments and checkpoint_timeout; this reduces the frequency of checkpoints, but increases the storage requirements of /pg_xlog.

checkpoints to occur more often than the normal checkpoint frequency (specified by the checkpoint_timeout configuration variable). Whenever a checkpoint occurs, all dirty pages must be flushed to disk. By This option can only be set at server start. 16.4.2.2. Security and Authentication authentication_timeout (integer) Maximum time to complete client authentication, in seconds. If a would-be client has not start or in the postgresql.conf file. 245 Chapter 16. Server Run-time Environment checkpoint_timeout (integer) Maximum time between automatic WAL checkpoints, in seconds. The default is 300 seconds

regular-expression search patterns from hostile sources. If you must do so, it is advisable to impose a statement timeout. Searches using SIMILAR TO patterns have the same security hazards, since SIMILAR TO provides many int The reason code(s) explaining the reason for rewriting. The ex- act meaning of the codes is re- lease dependent. The pg_event_trigger_table_rewrite_oid function can be used in an event trigger like this: “idle in transaction” longer than necessary. The configuration parameter idle_in_transaction_session_timeout may be used to automatically disconnect lingering sessions. • Eliminate explicit locks, SELECT FOR

regular-expression search patterns from hostile sources. If you must do so, it is advisable to impose a statement timeout. Searches using SIMILAR TO patterns have the same security hazards, since SIMILAR TO provides many int The reason code(s) explaining the reason for rewriting. The ex- act meaning of the codes is re- lease dependent. The pg_event_trigger_table_rewrite_oid function can be used in an event trigger like this: “idle in transaction” longer than necessary. The configuration parameter idle_in_transaction_session_timeout may be used to automatically disconnect lingering sessions. • Eliminate explicit locks, SELECT FOR

regular-expression search patterns from hostile sources. If you must do so, it is advisable to impose a statement timeout. Searches using SIMILAR TO patterns have the same security hazards, since SIMILAR TO provides many int The reason code(s) explaining the reason for rewriting. The ex- act meaning of the codes is re- lease dependent. 364 Functions and Operators The pg_event_trigger_table_rewrite_oid function can be used “idle in transaction” longer than necessary. The configuration parameter idle_in_transaction_session_timeout may be used to automatically disconnect lingering sessions. • Eliminate explicit locks, SELECT FOR