Details
-
Change Request
-
Status: Closed
-
Trivial
-
Resolution: Fixed
-
7.0.0alpha2
-
Team C
-
Sprint 102 (Jul 2023), Sprint 103 (Aug 2023)
-
2
Description
1) this can take considerable amount of space.
table_name | pg_size_pretty | pg_relation_size ----------------------------+----------------+------------------ auditlog | 635 GB | 681780338688 item_discovery | 26 GB | 28250169344
2) it has clock column
3) its historic records do not get modified
4) this should be easy to do, for new installations our timescalesdb script could be modified like:
PERFORM create_hypertable('auditlog', 'clock', chunk_time_interval => 86400, migrate_data => true)
and for the existing installations, separate upgrade patch could be provided in a file that users could run manually
Attachments
Issue Links
- mentioned in
-
Page Loading...