The new pg_timeseries PostgreSQL extension simplifies managing time-series data, offering a cohesive experience for creating tables, managing older data, and running analytics functions. Unlike TimescaleDB, pg_timeseries provides unrestricted features such as compression and incremental views. By leveraging existing PostgreSQL capabilities and extensions like pg_partman and pg_cron, pg_timeseries streamlines the process of handling time-series workloads. Additional functions like locf and date_bin_table enhance query capabilities, making it easier to analyze and maintain data. Future plans include features like offloading data to S3 and efficient analytics functions. Try pg_timeseries on Tembo Cloud for free and share your feedback for further improvements.
https://tembo.io/blog/pg-timeseries