PostgreSQL2 [timescaleDB] Continuous aggregates 사용기 Continuous Aggregates (TimescaleDB)Continuous aggregates는 MATERIALIZED VIEW를 사용하여 정의된 쿼리를 미리 실행하고, 그 결과를 물리적으로 저장해 둡니다. 이를 통해 대용량 데이터의 집계 쿼리를 더 빠르게 조회할 수 있습니다.예제-- 1시간 단위 집계 Continuous Aggregate 생성CREATE MATERIALIZED VIEW one_hour_transactionsWITH (timescaledb.continuous) ASSELECT time_bucket('1 hour', time) AS bucket, count(*) AS tx_count, sum(fee) AS total_fee_sat, sum(fee_usd) AS.. 2025. 8. 10. TimescaleDB special function? 먼데? 💡 target: our company using TimeScale DB for making candle chart. To use it effectively, I am studying the tsdb’s featuresBackground KnowledgeReference: https://www.timescale.com/TSDB is a service contain Continuous Aggregate, Hypertable functions on PostgreDB.Using saving continuous data.Continuous AggregateHypertable• For fast query to bigdata, Using Materialzed View• good for candle data.• t.. 2025. 8. 10. 이전 1 다음
