Specifies how many checkpoints older than the catalog trunction version (CTV) Vertica keeps. The CTV is the version that a Vertica cluster revives to after a crash, shutdown, or hibernation. All cluster nodes use the same CTV.

Default: 2

Specifies in minutes how often the transaction log sync service syncs metadata to S3. This value can be cluster or node specific.

Default: 5

Specifies in hours how long to wait before deleting a file from communal storage. Vertica first deletes a file from the depot. After the specified time interval, the delete also occurs in communal storage.

Default: 2

Specifies whether the depot fetches a file required by query from communal storage because it is not in the depot. This parameter also determines whether the depot evicts other files to make space for the fetched file.

Set to one of the following:

• ALL (default): When a query reads files that are not in the depot, the depot fetches the files from communal storage, and, if necessary, evicts other files.
• FETCHES: When a query reads files that are not in the depot, the depot fetches those files only if space is available without evicting other files.
• NONE: When a query reads files that are not in the depot, the depot does not fetch the files.

Sets in megabytes the maximum total size of files a node can request from a peer when warming its depot. This setting helps prevent node data requests from overwhelming its peer.

Default: Smaller of the following:

• 100000 (100GB)
• 25% of depot size

Boolean parameter, specifies whether to drop a subscription that failed to transition from PASSIVE TO ACTIVE.

Default: 1. Drop the subscription

Boolean parameter, specifies whether Vertica warms a node depot while the node is coming up and not ready to process queries.

Warming the depot involves inspecting the depots of other nodes and pre-fetching most recently used files. This task prepares the node to participate in queries without performance hits.

Default: 1. Warm the depot when a node comes up.

Specifies in seconds the interval between each execution of the reaper cleaner service task.

Default: 60 seconds

Specifies in seconds how long Vertica waits for the reaper to delete files from communal storage before shutting down. If set to a negative value, Vertica shuts down without wating for the reaper.

Default: 300

The size of temp space allocated per query to the StorageMerge operator for caching the data of S3 storage containers.

For details, see Local Caching of Storage Containers.

Boolean parameter, specifies whether a node retrieves data from the communal storage or a peer when warming its depot.

Default: 1. Retrieve data from communal storage.

Boolean parameter, specifies whether Vertica accesses the depot to answer queries, or accesses only communal storage.

Depot reads are enabled to improve query performance and provide database K-safety in Eon Mode.

Default: 1. Enable depot access to answer queries.

Boolean parameter, specifies whether Vertica writes loaded data to the depot and then uploads files to shared storage. If set to 0 (disabled), Vertica bypasses the depot and writes directly to communal storage.

You can set this parameter at the database or session level.

Default: 1. Write loaded data to the depot, upload files to shared storage.

Boolean parameter, specifies whether Vertica pushes loaded data to other shard subscribers. Setting to 1 (enabled) helps improve performance when a node is down.

Default: 1. Vertica sends loaded data to all shard subscribers.