timescaledb-parallel-copy
timescaledb-parallel-copy copied to clipboard
timescale
A binary for parallel copying of CSV data into a TimescaleDB hypertable
Please add option to set the db sessions timezone (inside connection string maybe?). Example: ``` SET TIME ZONE 'UTC' ``` `TIMESTAMP WITH TIME ZONE` (type: `timestamptz`) columns in postgres use...
Hi, I'm trying to copy values where the date format is like `2021-11-02 00:00:04.130`. The table is of type `timestamp(3)`. I tried inserting it manually and it worked. Any idea...
For me it looks like this: ``` at 14m12s, row rate 79934.24/sec (period), row rate 64460.02/sec (overall), 5.492000E+07 total rows at 14m13s, row rate 59992.56/sec (period), row rate 64454.78/sec (overall),...
I noticed that errors like `ERROR: duplicate key value violates unique constraint` are logged to stdout. Il would be cleaner if `timescaledb-parallel-copy` redirected errors to stderr.
Would be a great to have an ability to provide a compressed file in GZIP/ZIP
I noticed that even though there is a command called limit that limits the number of rows that are inserted, I was wondering if it's possible to also insert a...
I am testing this on Alpine Linux, with PostgreSQL 12.5, TimescaleDB 2.0.1. With a batch size of 1000000, it worked fine. When I increased the batch size to 10000000, I...
I'm having difficulty using this utility with JSONB fields and have only had success when uploading empty objects `{}`. 1. `{\"a\":1} - invalid` 2. `{"a":1} - invalid` 3. `"{\"a\":1}" -...
### What type of bug is this? Data corruption ### What subsystems and features are affected? Data ingestion ### What happened? Upon inserting a large CSV of cryptocurrency data, certain...
First off, great work with this package, its been very useful! However, this package could be more useful if it could support its use as a golang package rather than...
