TimescaleDB expands PostgreSQL query performance by 1000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical applications—while still being 100% Postgres.
Performance and tooling are frequently debated in the State of PostgreSQL survey, and this year was no exception. With psql remaining the number one tool for querying and admin among PostgreSQL users, we decided to compile a list of tools— that aren’t psql—to broaden your options.
Community contribution remains a recurrent theme in the State of PostgreSQL survey. As we prepare to release the full report later this month, we dig into some of the results and leave you tips on how to contribute to PostgreSQL and its community.
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster, while requiring 60 % less storage (on average).
An in-depth look at how ClickHouse and TimescaleDB architectures impact application design, developer experience, and performance - with detailed benchmark results comparing ingest speeds, disk space, and query response times.
Generating sample time-series data with the PostgreSQL generate_series() function is a useful skill to have when evaluating new database features, creating demonstrations, or testing insert and query patterns. Learn what PostgreSQL `generate_series()` is and how to use it for basic data generation.
Learn how to use time-series data provided by the NFL to uncover valuable insights into many player performance metrics – and ways to apply the same methods to improve your fantasy league team, or your knowledge of the game - all with PostgreSQL, SQL, and freely available extensions.
Time-series data is relentless. It grows at an ever-increasing rate and quickly becomes expensive and unwieldy to store and query. Timescale provides the tools you need to maintain storage and query performance and keep tight control over your costs.
Postgres is one of the most popular and loved databases in the world, even after 30+ years of development. Learn how developers use Postgres today, from the use cases they’re tackling and places they go to share and learn to opportunities for improvement in the Postgres community, and more.
We love PostgreSQL and believe in the power of the platform and community. Like all databases, sometimes "basic" queries don't scale with very large datasets. TimescaleDB 2.2 provides up to 8000x faster DISTINCT queries thanks in part to our ability to extend PostgreSQL.
Our benchmark results surprised even us - but even after testing with several configurations, we found Amazon Timestream slow, expensive, and missing key database capabilities like backups, restores, updates, and deletes.
