-
Notifications
You must be signed in to change notification settings - Fork 1
Configuration
no0p edited this page Oct 19, 2014
·
7 revisions
The pgsampler background worker has a number of configurable parameters for administration and controlling the volume of data collected.
These GUCs are for setting up and operating pgsampler.
| GUC | Description | Default Value |
|---|---|---|
| pgsampler.output_mode | Determines how pgsampler will store data. It can be set to 'network' or 'csv'. | 'network' |
| pgsampler.output_network_host | When output_mode is network, pgsampler will ship data to this hostname or IP address. Point this at an instance of pgantenna. | 'localhost' |
| pgsampler.output_csv_dir | When output_mode is csv, pgsampler will write data to csv files in this directory. | '/tmp/' |
| pgsampler.target_db | This is the first database pgsampler will connect to. It must be set to a database that exists. | 'postgres' |
| pgsampler.cycle_db_seconds | The background worker collects database specific statistics, and cycle between databases. This setting is the number of seconds pgsampler will spend sampling a given database. When set to -1, pgsampler will connect only to target_db. | 500 |
| pgsampler.token | An optional, user set string which uniquely identifies this cluster. | "" |