{"id":46760,"date":"2023-05-03T00:00:00","date_gmt":"2023-05-03T07:00:00","guid":{"rendered":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/"},"modified":"2025-11-13T12:56:35","modified_gmt":"2025-11-13T20:56:35","slug":"time-series-database-benchmark-comparison-griddb-questdb-timescaledb","status":"publish","type":"post","link":"https:\/\/www.griddb.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/","title":{"rendered":"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB"},"content":{"rendered":"

In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their ingestion or load performance. Their query performance is also measured, using five of the available queries in TSBS that highlight different use cases that could be used in a real world analysis of time series data.<\/p>\n

There is one significant difference between the databases which are being evaluated: QuestDB and TimescaleDB use a tabular data model and GridDB uses a Key-Container data model. All data for QuestDB and TimescaleDB is inserted into one table while GridDB puts data for each host into separate tables (or containers in GridDB terminology).<\/p>\n

To test how cardinality affects each database and specifically GridDB\u2019s Key-Container data model, datasets with 100, 1,000, 10,000, and 100,000 hosts were evaluated for both load and query performance. The high-cpu-all, high-cpu-1, lastpoint, single-groupby and double-groupby queries were examined.<\/p>\n

It was noted that load performance was not as expected, so tsdb_load was re-implemented in Java for GridDB; Java is the native interface for GridDB, providing reduced overhead compared to the other language bindings, including Go.<\/p>\n

In general, GridDB was the fastest of the three databases, although it required more tuning. The exception to this was the simple lastpoint query that fetches the most recent record for every host. This very simple query had to be executed n-times for n-hosts.<\/p>\n

A summary of the results for 10,000 hosts are shown below:<\/p>\n

\"\"<\/a><\/p>\n

All three databases were able to ingest 100,000 hosts worth of DevOps data in real time with 10 seconds between each data point, making them all an effective ingestion option for this use case. QuestDB and TimescaleDB\u2019s slow query performance is concerning if real time analysis is required, but they would perform adequately in scenarios where analysis is performed as a nightly batch job.<\/p>\n

The detailed comparison is available here: TSDB_Evaluation_of_GridDB_QuestDB_and_TimescaleDB <\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their ingestion or load performance. Their query performance is also measured, using five of the available queries in TSBS that highlight different use cases that could be used in a real world analysis of […]<\/p>\n","protected":false},"author":71,"featured_media":29583,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[121],"tags":[],"class_list":["post-46760","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"yoast_head":"\nTime Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB | GridDB: Open Source Time Series Database for IoT<\/title>\n<meta name=\"description\" content=\"In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB | GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"og:description\" content=\"In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their\" \/>\n<meta property=\"og:url\" content=\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/\" \/>\n<meta property=\"og:site_name\" content=\"GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/griddbcommunity\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-03T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T20:56:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.griddb.net\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1160\" \/>\n\t<meta property=\"og:image:height\" content=\"653\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Owen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:site\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Owen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/\"},\"author\":{\"name\":\"Owen\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66\"},\"headline\":\"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB\",\"datePublished\":\"2023-05-03T07:00:00+00:00\",\"dateModified\":\"2025-11-13T20:56:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/\"},\"wordCount\":322,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/\",\"url\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/\",\"name\":\"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB | GridDB: Open Source Time Series Database for IoT\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png\",\"datePublished\":\"2023-05-03T07:00:00+00:00\",\"dateModified\":\"2025-11-13T20:56:35+00:00\",\"description\":\"In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage\",\"url\":\"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png\",\"contentUrl\":\"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png\",\"width\":1160,\"height\":653},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/griddb.net\/en\/#website\",\"url\":\"https:\/\/griddb.net\/en\/\",\"name\":\"GridDB: Open Source Time Series Database for IoT\",\"description\":\"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL\",\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/griddb.net\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/griddb.net\/en\/#organization\",\"name\":\"Fixstars\",\"url\":\"https:\/\/griddb.net\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"contentUrl\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"width\":200,\"height\":83,\"caption\":\"Fixstars\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/griddbcommunity\/\",\"https:\/\/x.com\/GridDBCommunity\",\"https:\/\/www.linkedin.com\/company\/griddb-by-toshiba\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66\",\"name\":\"Owen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g\",\"caption\":\"Owen\"},\"url\":\"https:\/\/www.griddb.net\/en\/author\/owen\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB | GridDB: Open Source Time Series Database for IoT","description":"In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/","og_locale":"en_US","og_type":"article","og_title":"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB | GridDB: Open Source Time Series Database for IoT","og_description":"In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their","og_url":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/","og_site_name":"GridDB: Open Source Time Series Database for IoT","article_publisher":"https:\/\/www.facebook.com\/griddbcommunity\/","article_published_time":"2023-05-03T07:00:00+00:00","article_modified_time":"2025-11-13T20:56:35+00:00","og_image":[{"width":1160,"height":653,"url":"https:\/\/www.griddb.net\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png","type":"image\/png"}],"author":"Owen","twitter_card":"summary_large_image","twitter_creator":"@GridDBCommunity","twitter_site":"@GridDBCommunity","twitter_misc":{"Written by":"Owen","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#article","isPartOf":{"@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/"},"author":{"name":"Owen","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66"},"headline":"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB","datePublished":"2023-05-03T07:00:00+00:00","dateModified":"2025-11-13T20:56:35+00:00","mainEntityOfPage":{"@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/"},"wordCount":322,"commentCount":0,"publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"image":{"@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png","articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/","url":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/","name":"Time Series Database Benchmark Comparison: GridDB, QuestDB, TimescaleDB | GridDB: Open Source Time Series Database for IoT","isPartOf":{"@id":"https:\/\/griddb.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage"},"image":{"@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png","datePublished":"2023-05-03T07:00:00+00:00","dateModified":"2025-11-13T20:56:35+00:00","description":"In this Time Series Benchmark Suite Evaluation of GridDB, QuestDB, and TimescaleDB, the three time series databases are compared by evaluating their","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/en\/blog\/time-series-database-benchmark-comparison-griddb-questdb-timescaledb\/#primaryimage","url":"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png","contentUrl":"\/wp-content\/uploads\/2023\/05\/Time-Series-Comparisons.png","width":1160,"height":653},{"@type":"WebSite","@id":"https:\/\/griddb.net\/en\/#website","url":"https:\/\/griddb.net\/en\/","name":"GridDB: Open Source Time Series Database for IoT","description":"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL","publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/griddb.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/griddb.net\/en\/#organization","name":"Fixstars","url":"https:\/\/griddb.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","contentUrl":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","width":200,"height":83,"caption":"Fixstars"},"image":{"@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/griddbcommunity\/","https:\/\/x.com\/GridDBCommunity","https:\/\/www.linkedin.com\/company\/griddb-by-toshiba"]},{"@type":"Person","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/0f2f6d4b593adde8c43cf3ea5c794c66","name":"Owen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/47438a5c81215c7a9043be1b427e0bbd8dc0f77bd536f147f8495575149e4325?s=96&d=mm&r=g","caption":"Owen"},"url":"https:\/\/www.griddb.net\/en\/author\/owen\/"}]}},"_links":{"self":[{"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/posts\/46760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/users\/71"}],"replies":[{"embeddable":true,"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/comments?post=46760"}],"version-history":[{"count":1,"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/posts\/46760\/revisions"}],"predecessor-version":[{"id":51427,"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/posts\/46760\/revisions\/51427"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/media\/29583"}],"wp:attachment":[{"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/media?parent=46760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/categories?post=46760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.griddb.net\/en\/wp-json\/wp\/v2\/tags?post=46760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}