Jônatas Davi Paganini
Jônatas Davi Paganini
Several options could be detected through the create_index and improved on the default behavior. https://docs.timescale.com/api/latest/hypertable/create_index/
It's only available via create_hypertable when it's defined with number_of_partitions. https://docs.timescale.com/api/latest/hypertable/add_dimension/ can be useful to add extra dimensions. ```ruby Timescaledb.add_dimension hypertable_name, *options # or HypertableModel.hypertable.add_dimension(*options) ``` There's no remove_dimension.
Reorder policy details: https://docs.timescale.com/api/latest/hypertable/add_reorder_policy/ ```ruby Timescaledb.add_reorder_policy(hypertable_name, *params) Event.hypertable.add_reorder_policy(params) ``` Reversible with: [remove_order_policy](https://docs.timescale.com/api/latest/hypertable/remove_reorder_policy/).
Chunk skipping is incredibly fast, and we should also have an interface to enable it. https://docs.timescale.com/api/latest/hypertable/enable_chunk_skipping/ The function should also be able to disable it. https://docs.timescale.com/api/latest/hypertable/disable_chunk_skipping/ ```ruby Event.hypertable.enable_chunk_skipping('order_id') ```
Today, if the `continuous_aggregates` macro is not declared in the model, it cannot detect previous aggregations or even use them on the fly. It would be great if we could...
Relates to #88.
It's boring to keep repeating the same minimal refresh policy. ```ruby class Event < ActiveRecord::Base extend Timescaledb::ActsAsHypertable include Timescaledb::ContinuousAggregatesHelper acts_as_hypertable time_column: "time", segment_by: "identifier" scope :count_clicks, -> { select("count(*)").where(identifier: "click")...
Counter caches are interesting but they have a serious problem of bringing vacuum issues: See more about the benefits of this denormalization: https://thoughtbot.com/blog/what-is-counter-cache#counter-cache-to-the-rescue But there are some issues with this...
Hi @jamis, I work at Timescale and just see this new research from a colleague showing some performance gains using unnest for the sql statement. https://www.timescale.com/blog/benchmarking-postgresql-batch-ingest/ The django folks [are...
This PR adds the racc gem as a dependency to fix the LoadError issue when loading the parser.\n\nThe error 'cannot load such file -- racc/parser' was preventing the test suite...