Pg_textsearch

A Postgres-based database for sensor and machine time-series data that ingests high-frequency metrics, stores years of history cost-effectively, and queries live and historical data together. It is for developers, data and operations teams in B2B organizations including startups and enterprises in industries such as manufacturing, energy, and data centers. It is delivered as a managed cloud platform and as self-managed open-source software, with Postgres-native SQL, APIs, CLI and UI access.

Key features

• Automatic time- and key-based partitioning
• Row-columnar storage with compression
• Tiered storage across SSD and object storage
• Lakehouse integration with Kafka and S3
• Replicate to Iceberg
• 200+ SQL time-series functions
• Postgres-native SQL, APIs, CLI, UI
• Hybrid vector and keyword search
• Continuous aggregates for pre-computed aggregations
• High availability and automated backups
• Point-in-time recovery
• Encryption at rest and in transit