before version 1.0, performed background garbage collection where the server informs the garbage collector about old versions of updated and deleted rows when they are ready to be cleaned up. This helps helps avoid the need to force a full scan of each record in the database tables to get the garbage collector to remove these old versions. An active transaction has to recognize the need for garbage collection garbage collector unless another record on that page is read and does need cleanup. When all rows in a table are read by the server, any old record versions are flagged to the garbage collector as being

otation|Log_line_prefix|logging_collector|log_filen ame|log_duration" # requires logging_collector to be on. logging_collector = on # Enable capturing capturing of stderr and csvlog # These are only used if logging_collector is on: log_directory = 'pg_log' # directory where log files are written, log_filename = 'postgresql-%a.log'

.......................................................480 18.9.1. Query and Index Statistics Collector .......................................................480 18.9.2. Statistics Monitoring....... ......................................................................589 27.2. The Statistics Collector.........................................................................................590 27 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. 9.26.3. Backup Control Functions

.......................................................510 18.9.1. Query and Index Statistics Collector ..............................................................510 18.9.2. Statistics Monitoring ......................................................................623 27.2. The Statistics Collector................................................................................................624 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. 9.26.3. Backup Control Functions

.......................................................465 18.9.1. Query and Index Statistics Collector .......................................................465 18.9.2. Statistics Monitoring....... ......................................................................570 27.2. The Statistics Collector.........................................................................................571 27 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. 276 Chapter 9. Functions

.......................................................496 18.9.1. Query and Index Statistics Collector ..............................................................496 18.9.2. Statistics Monitoring ......................................................................607 27.2. The Statistics Collector................................................................................................608 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. 9.26.3. Backup Control Functions

.......................................................442 18.9.1. Query and Index Statistics Collector .......................................................443 18.9.2. Statistics Monitoring....... ......................................................................549 27.2. The Statistics Collector.........................................................................................549 27 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. The functions shown in Table

.......................................................471 18.9.1. Query and Index Statistics Collector ..............................................................471 18.9.2. Statistics Monitoring ................................................................581 xiv 27.2. The Statistics Collector................................................................................................582 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. The functions shown in Table

.......................................................452 18.8.1. Query and Index Statistics Collector ..............................................................452 18.8.2. Statistics Monitoring ......................................................................556 27.2. The Statistics Collector................................................................................................557 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. The functions shown in Table

.......................................................422 18.8.1. Query and Index Statistics Collector .......................................................422 18.8.2. Statistics Monitoring....... ......................................................................520 27.2. The Statistics Collector.........................................................................................520 27 log-file manager to switch to a new output file immediately. This works only when the built-in log collector is running, since otherwise there is no log-file manager subprocess. The functions shown in Table