db_with_tmp_read {timeseriesdb}

Helper to Create and Populate a Temporary Table for Fast Reading

Description

This function is not exported. It creates a tempory table containing the keys that should be read to join them against the time series storage. This is much faster for larger selections than simple where clauses.

Usage

db_with_tmp_read(con, ts_keys, regex = FALSE, code, schema = "timeseries")

Arguments

con

RPostgres connection object.

ts_keys

character vector of time series identifiers.

regex

logical if set to TRUE, the ts_keys parameter is interpreted as a regular expression pattern.

code

expression Code to be evaluated after populating the temporary table on the database of a time series that is valid from the specified date.

schema

character name of the database schema. Defaults to 'timeseries'