search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
17.47k stars 876 forks source link

[Enhancement]: Export column decompressor functions to SQL #4732

Open svenklemm opened 1 year ago

svenklemm commented 1 year ago

What type of enhancement is this?

Other

What subsystems and features will be improved?

Compression

What does the enhancement do?

Allow users to directly decompress binary column data. This will enable certain advanced use cases and will greatly help support troubleshoot compression problems. The functions should live in internal schema.

Implementation challenges

Should be straightforward since all the functions are already there and just need to be exposed.

nevillegrech commented 1 year ago

This will be a game changer for power users looking to perform complex migrations on large databases, debug performance issues and other advanced use cases.