[ZBXNEXT-8835] Support additional parameters in add_compression_policy() - timescaledb compression Created: 2023 Nov 15 Updated: 2023 Nov 15 |
|
| Status: | Open |
| Project: | ZABBIX FEATURE REQUESTS |
| Component/s: | Frontend (F), Server (S) |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Change Request | Priority: | Trivial |
| Reporter: | Albert Przybylski | Assignee: | Valdis Murzins |
| Resolution: | Unresolved | Votes: | 7 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
DB: (PostgreSQL) 14.8 + timescaledb 2.11.1, Zabbix 6.4.4 |
||
| Description |
|
On large trend/history tables, timescaledb compression can take quite a long time. During compression, the table is "locked" and data cannot be written to it (because not only the "chunk", but the entire hypertable is locked). This may cause "holes" in the data, as well as a lack of any data (because all syncers will want to write something to the currently compressed table and will "hang" because the table is locked). SELECT add_compression_policy( 'trends', compress_after => integer '871200', schedule_interval => INTERVAL '1 day', initial_start => '2000-01-01 00:00:00+00'::TIMESTAMPTZ ); And adding additional checkboxes in the GUI: "Administration -> Housekeeping -> History and trends compression" to additionally control the "initial_start" (this is so important for us) and "schedule_interval" (optional) parameters. |