TimescaleDB v2.9 Documentation
首页
白天
夜间
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
timescaledb_information.compression_settings
来源 1
浏览
199
扫码
打印
2022-12-25 22:24:37
Sample usage
上一篇:
下一篇:
发布点评
Getting started
Create a continuous aggregate
Continuous aggregate basics
Continuous aggregate policies and refreshing data
Add time-series data
Next steps
Learn about data retention
Create a hypertable
Query your data
Save space with compression
Timescale Cloud
Integrations
Security
Connect with a stricter SSL mode
Security overview
High availability
Service logs
Members
Members list
Multi-node
Billing
Account management
PostgreSQL extensions
Service explorer
Troubleshooting
Service overview
Service metrics
Services
Create a service demo
Create a service
Service operations
Replication
Autoscale
Resources
VPC
Service management
Maintenance
Database parameters
Customize configuration
Advanced parameters
Migrate a TimescaleDB database to Cloud
Migrate schema and data separately
Migrate the entire database at once
Data tiering
Tier data to object storage
Backup and restore
Managed Service for TimescaleDB
Supported extensions
Aiven Client for Managed Service for TimescaleDB
Send Grafana emails using Aiven Client
Integrate authentication plugins in Grafana
Create a read-only replica using Aiven Client
Create a fork of the service using Aiven Client
Install Aiven Client for Managed Service for TimescaleDB
Integrate Managed Service for TimescaleDB as a data source in Grafana
Clouds and regions
Viewing service logs
Connection pools
Integrate Managed Service for TimescaleDB and Google Data Studio
Using REST API on Managed Service for TimescaleDB
Troubleshooting
Send metrics to Datadog
Create a multi-node cluster
Migrate your data to Managed Service for TimescaleDB
Ingest data
Backups
User management
Failover
Billing
Security
Create a replica for PostgreSQL service
Logging
Maintenance
VPC peering
Migrate your data to Timescale Cloud
About Managed Service for TimescaleDB
API Reference
Hypertables & chunks
chunks_detailed_size
detach_tablespace
add_reorder_policy
hypertable_index_size
add_dimension
detach_tablespaces
set_integer_now_func
create_hypertable
drop_chunks
hypertable_size
reorder_chunk
hypertable_detailed_size
set_chunk_time_interval
remove_reorder_policy
move_chunk
show_chunks
show_tablespaces
attach_tablespace
create_index (transaction per chunk)
Distributed hypertables
create_distributed_hypertable
detach_data_node
attach_data_node
distributed_exec
set_replication_factor
create_distributed_restore_point
copy_chunk
set_number_partitions
move_chunk
delete_data_node
add_data_node
cleanup_copy_chunk_operation
Continuous aggregates
ALTER MATERIALIZED VIEW (Continuous Aggregate)
cagg_migrate
CREATE MATERIALIZED VIEW (Continuous Aggregate)
refresh_continuous_aggregate
remove_continuous_aggregate_policy
remove_policies
add_continuous_aggregate_policy
remove_all_policies
show_policies
alter_policies
add_policies
DROP MATERIALIZED VIEW (Continuous Aggregate)
Administration Functions
timescaledb_pre_restore
dump_meta_data
timescaledb_post_restore
get_telemetry_report
Compression
compress_chunk
recompress_chunk
chunk_compression_stats
remove_compression_policy
ALTER TABLE (Compression)
add_compression_policy
decompress_chunk
hypertable_compression_stats
Actions and automation
alter_job
add_job
run_job
delete_job
API Reference Tag Overview
Configuration
Data retention
remove_retention_policy
add_retention_policy
Hyperfunctions
first
days_in_month
Downsample
gp_lttb
lttb
asap
last
Frequency Analysis
min_frequency / max_frequency
freq_agg
count_min_sketch
approx_count
topn
into_values (for freq_agg)
topn_agg
time_bucket_ng
time_bucket
Metric aggregation (counters and gauges)
delta
corr
first_time, last_time
counter_zero_time
rollup
irate
num_changes
intercept
interpolated_rate
counter_agg (point form)
with_bounds
num_resets
time_weight
slope
gauge_agg
idelta
extrapolated_delta
time_delta
rate
num_elements
extrapolated_rate
first_val, last_val
interpolated_delta
Gapfilling and interpolation
interpolate
percentile_agg and uddsketch
tdigest
time_bucket_gapfill
locf
month_normalize
hyperloglog
Saturating math
ohlc
saturating_add
saturating_sub
max_n
stats_agg (one variable)
min_n_by
saturating_sub_pos
candlestick_agg
max_n_by
min_n
stats_agg (two variables)
saturating_mul
saturating_add_pos
approximate_row_count
State aggregates
state_agg
state_timeline
interpolated_state_timeline
state_periods
interpolated_duration_in
duration_in
interpolated_state_periods
into_values (for state_agg)
rollup (for state_agg)
heartbeat_agg
histogram
Informational views
timescaledb_experimental.policies
timescaledb_information.continuous_aggregates
timescaledb_information.compression_settings
timescaledb_information.chunks
timescaledb_information.jobs
timescaledb_information.hypertables
timescaledb_information.job_stats
timescaledb_information.data_nodes
timescaledb_information.dimensions
Promscale
Recommendations
Resource recommendation guide
Configuration recommendation guide
Promscale CLI reference
Downsample data
Recording Rules
Continuous Aggregates
tobs
Install
About tobs
Alert in Promscale
Promscale benefits
Quick start
About Promscale
Manage data in Promscale
Maintenance jobs
Compression
Retention
Delete data
Visualize data in Promscale
Jaeger
Grafana
Application Performance Monitoring (APM)
Troubleshooting Promscale
SQL API functions reference
Install Promscale
Debian or Ubuntu
Binary
Docker
Promscale with Timescale cloud
Kubernetes
Binary
Docker
RPM based Linux (Red Hat or CentOS)
Kubernetes
Backup and Restore Promscale
Scale Promscale
Prometheus High availability
Prometheus multi-tenancy
Query data in Promscale
Query metrics
Query traces
How-to Guides
Migrate existing data
Upgrade Promscale
Monitor Promscale
Send data to Promscale
OpenTelemetry
Jaeger
Remote write API
Zipkin
Prometheus
Database roles and permissions
TimescaleDB
How-to Guides
Upgrade TimescaleDB
About upgrades
Upgrade PostgreSQL
Upgrade within Docker
Downgrade TimescaleDB
Troubleshooting upgrades
Minor upgrades
Major upgrades
Query data
Perform advanced analytic queries
SELECT data
Troubleshooting
About querying data
Perform DISTINCT queries with SkipScan
Connecting to TimescaleDB
About connecting to TimescaleDB
Install psql
Connect using Azure Data Studio
Connect using DBeaver
About psql
Install pgAdmin
Distributed hypertables
Create distributed hypertables
About distributed hypertables
Create foreign keys on distributed hypertables
Insert data
Use triggers in distributed hypertables
Alter and drop distributed hypertables
Query data
Troubleshooting
Configuration
Troubleshooting
About Configuration
TimescaleDB configuration
Using timescaledb-tune
Telemetry
Manual PostgreSQL configuration
Docker configuration
Data retention
Create a retention policy
About data retention
About data retention with continuous aggregates
Troubleshooting data retention
Manually drop chunks
Multi-node
Multi-node setup on TimescaleDB
Multi-node administration
Multi-node authentication
Grow and shrink a multi-node cluster
About multi-node
High availability multi-node
Multi-node maintenance
Configure multi-node
Troubleshoot TimescaleDB
Data migration
About data migration
Import from CSV
Troubleshoot data migration
Migrate from a different database
Migrate InfluxDB data
Migrate from the same database
Additional tooling
Install and use timescaledb-parallel-copy
About timescaledb-tune
Continuous aggregates
Create a continuous aggregate
Compress continuous aggregates
Time in continuous aggregates
Drop data from continuous aggregates
Create an index on a continuous aggregate
Real time aggregates
Troubleshoot continuous aggregates
About continuous aggregates
Manage materialized hypertables
Migrate a continuous aggregate to the new form
Refresh policies for continuous aggregates
Schema management
About indexing
About tablespaces
Index
Alter hypertables
Triggers
Manage storage using tablespaces
About constraints
About schemas
JSON
Compression
Decompress chunks
About compression
Manually compress chunks
Backfill historical data
Modify a schema
Troubleshooting
Uninstall TimescaleDB
Uninstall TimescaleDB on macOS
Hypertables
About hypertables
Create hypertables
Create unique indexes on hypertables
Change hypertable chunk intervals
Alter hypertables
Drop hypertables
Troubleshoot hypertables
User-defined actions
Use an action for generic retention
About user-defined actions
Test and debug a user-defined action
Use an action for downsampling and compression
Use an action for tablespace management
Use an action to backfill data periodically
Alter and delete a user-defined action
Troubleshooting
Create and register a user-defined action
Replication and High Availability
Configure replication
About high availability
Time buckets
About time buckets
Use time buckets to group time-series data
Write data
Delete data
Upsert data
About writing data
Insert data
Update data
Alerting
Backup and restore
Physical backups
Docker & WAL-E
Using pg_dump/pg_restore
Troubleshooting
Hyperfunctions
Statistical aggregates
Function pipelines
Approximate count distincts
Hyperloglog
Counter aggregation
Counter aggregates
Install and update TimescaleDB Toolkit
Gapfilling and interpolation
Last observation carried forward
Time bucket gapfill
Percentile approximation
Approximate percentile
Advanced aggregation methods
Time-weighted averages
Time-weighted averages
About hyperfunctions
Troubleshoot hyperfunctions
Ingest data from other sources
Ingesting data with Telegraf
Ingesting data with Prometheus
Ingesting data with TimescaleDB parallel copy
Ingesting data with Kafka
About ingesting data from other sources
Contribute to documentation
Code quick starts
Ruby
Python
Java
C# .Net
Golang
Node.js
Overview
How does it compare?
Comparison with PostgreSQL
Comparison with NoSQL
What is time-series data?
Deployment options
Release notes
Changes in TimescaleDB 2.0
Limitations
Data model flexibility
FAQs
FAQs: Time-series databases
FAQs: PostgreSQL
FAQs: Using TimescaleDB
FAQs: Community
FAQs: Products
TimescaleDB on Kubernetes
Core concepts
Distributed hypertables
Scaling
Hypertables and chunks
Benefits of hypertables
Hypertable architecture
Continuous aggregates
Data retention
Backup and restore
User-defined actions
Compression
Compression architecture
Compare TimescaleDB Editions
Tutorials
Visualize data in Tableau
Analyze data using hyperfunctions
Join time-series and relational data
Visualize time-series data
Analyze data using SQL and hyperfunctions
Ingest and query data
Analyze NFT sales data
Analyzing NFT transactions
NFT schema design and ingestion
TimescaleDB with AWS Lambda
Create a data API for TimescaleDB
Continuous deployment with GitHub actions
Pull and ingest data from a third party API
Custom TimescaleDB dashboards
Simulate IoT sensor data
Store financial tick data in TimescaleDB
Query the candlestick views
Create candlestick aggregates
Advanced data management
Design schema and ingest tick data
Analyze cryptocurrency data
Ingest real-time financial websocket data
Grafana
Connect TimescaleDB and Grafana
Create a dashboard and panel
Visualize missing data
Build Geospatial dashboards
Use Grafana variables
Setup Grafana on Managed Service for TimescaleDB
Setup alerts
Visualizations
Bar chart
Candlestick
Histograms
Pie chart
Time-series
Collect metrics with Telegraf
Monitor a Django application with Prometheus
Monitor MST with Prometheus
Sample datasets
Introduction to time-series forecasting
Analyze intraday stock data
Explore stock market data
Fetch and ingest stock data
Design database schema
Introduction to time-series data
Time-series tutorial - set up
Time-series tutorial - query data
Time-series tutorial - advanced queries
Analyze the Bitcoin blockchain
Analyze the blockchain with hyperfunctions
Ingest and query Bitcoin transactions
Contribute to TimescaleDB
Install TimescaleDB
Managed Service for TimescaleDB
Kubernetes
Pre-built containers
Self hosted
Arch Linux
MacOS
RHEL/CentOS
Debian/Ubuntu
From source
Windows
Troubleshooting
Timescale Cloud
Pre-built cloud images
暂无相关搜索结果!
本文档使用
全库网
构建
×
思维导图备注
×
文章二维码
手机扫一扫,轻松掌上读
×
文档下载
请下载您需要的格式的文档,随时随地,享受汲取知识的乐趣!
PDF
文档
EPUB
文档
MOBI
文档
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度