About timescaledb-parallel-copy

    PostgreSQL’s native COPY function is transactional and single-threaded, and is not suitable for ingesting large amounts of data. If the file is at least chronologically ordered with respect to the time dimension of the hypertable, timescaledb-parallel-copy improves performance by parallelizing this operation. This enables you to take full advantage of your hardware resources.

    • Install TimescaleDB or create a on Timescale Cloud.
    • Gather the connection details for TimescaleDB.
    • Create a database to insert the data. Ensure that you use a schema that matches the data in your .csv file.

    2. Change to the directory that contains the .csv files to import.

    3. note

      To import data into a tsdb database on a localhost the connection parameter would be