Engineering 13 tips to improve PostgreSQL Insert performance 29 Jun 2020 8 min read Some of these may surprise you, but all 13 ways will improve ingest (INSERT) performance using PostgreSQL and TimescaleDB (and help you get ingest rates similar to our benchmark blog posts 🎊) Read more
Tutorials & How-tos How to install psql on Mac, Ubuntu, Debian, Windows 22 Aug 2019 1 min read psql is the standard command line interface for interacting with a PostgreSQL or TimescaleDB instance. Here we explain how to install psql on various platforms.
Product & Engineering Mind the gap: Using SQL functions for time-series analysis 24 Jan 2019 6 min read Write more efficient and readable queries with a new set of time-series analytic tools included in TimescaleDB 1.2
Product & Engineering Problems with PostgreSQL 10 for time-series data 23 Oct 2017 13 min read PostgreSQL 10 promises easier partitioning to scale for big data. But how does it fare for time-series workloads? And how does that compare to TimescaleDB?
Product & Engineering TimescaleDB vs. PostgreSQL for time-series: 20x higher inserts, 2000x faster deletes, 1.2x-14,000x faster queries 10 Aug 2017 12 min read This is the first in a series of performance benchmarks comparing TimescaleDB to other databases for storing and analyzing time-series data.
PostgreSQL When Boring is Awesome: Building a scalable time-series database on PostgreSQL 4 Apr 2017 9 min read Today we are announcing the beta release of TimescaleDB, a new open-source time-series database optimized for fast ingest and complex queries, now available on GitHub under the Apache 2 license.
