timescaledb-extras icon indicating copy to clipboard operation
timescaledb-extras copied to clipboard

Insert PostgreSQL table in to hypertable using multiple selects over disjoint time ranges

Open sbahman opened this issue 4 years ago • 1 comments
trafficstars

For inserting very large PostgreSQL tables in to hypertables it would be useful to have a function which inserts it using multiple selects over disjoint time ranges. By tuning the timerange one can limit ram being used by the server and maybe improve the efficiency of the query.

sbahman avatar May 19 '21 14:05 sbahman

Hey @sbahman if you want to give it a try an initial version is up. Documentation isn't fully done yet, but something to work with.

davidkohn88 avatar May 19 '21 19:05 davidkohn88