ClickHouse Benchmarking<\/title>\n<meta name=\"description\" content=\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Benchmarking ClickHouse on my MacBook Pro\" \/>\n<meta property=\"og:description\" content=\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\" \/>\n<meta property=\"og:url\" content=\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/\" \/>\n<meta property=\"og:site_name\" content=\"The WebScale Database Infrastructure Operations Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/TheWebScaleDBA\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-23T14:31:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-13T13:41:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Shiv Iyer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@http:\/\/twitter.com\/thewebscaledba\" \/>\n<meta name=\"twitter:site\" content=\"@webscaledba\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shiv Iyer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/\"},\"author\":{\"name\":\"Shiv Iyer\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\"},\"headline\":\"Benchmarking ClickHouse on my MacBook Pro\",\"datePublished\":\"2018-01-23T14:31:09+00:00\",\"dateModified\":\"2018-03-13T13:41:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/\"},\"wordCount\":386,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"keywords\":[\"ClickHouse\",\"ClickHouse Benchmarking\",\"ClickHouse Performance\"],\"articleSection\":[\"ClickHouse\",\"ClickHouse Benchmarking\",\"ClickHouse Performance Benchmarking\",\"Columnar Database System\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/\",\"url\":\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/\",\"name\":\"ClickHouse Benchmarking\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/#website\"},\"datePublished\":\"2018-01-23T14:31:09+00:00\",\"dateModified\":\"2018-03-13T13:41:41+00:00\",\"description\":\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\",\"breadcrumb\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/minervadb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Benchmarking ClickHouse on my MacBook Pro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/minervadb.com\/#website\",\"url\":\"https:\/\/minervadb.com\/\",\"name\":\"The WebScale Database Infrastructure Operations Experts\",\"description\":\"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations\",\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/minervadb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/minervadb.com\/#organization\",\"name\":\"MinervaDB\",\"url\":\"https:\/\/minervadb.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"width\":200,\"height\":200,\"caption\":\"MinervaDB\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/webscaledba\",\"https:\/\/www.linkedin.com\/company\/minervadb\/\",\"https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\",\"name\":\"Shiv Iyer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"caption\":\"Shiv Iyer\"},\"description\":\"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.\",\"sameAs\":[\"http:\/\/minervadb.com\",\"https:\/\/www.facebook.com\/TheWebScaleDBA\",\"https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba\"],\"url\":\"https:\/\/minervadb.com\/index.php\/author\/shiv\/\"}]}<\/script>\n","yoast_head_json":{"title":"ClickHouse Benchmarking","description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","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":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/","og_locale":"en_US","og_type":"article","og_title":"Benchmarking ClickHouse on my MacBook Pro","og_description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","og_url":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/","og_site_name":"The WebScale Database Infrastructure Operations Experts","article_publisher":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_author":"https:\/\/www.facebook.com\/TheWebScaleDBA","article_published_time":"2018-01-23T14:31:09+00:00","article_modified_time":"2018-03-13T13:41:41+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg","type":"image\/jpeg"}],"author":"Shiv Iyer","twitter_card":"summary_large_image","twitter_creator":"@http:\/\/twitter.com\/thewebscaledba","twitter_site":"@webscaledba","twitter_misc":{"Written by":"Shiv Iyer","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#article","isPartOf":{"@id":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/"},"author":{"name":"Shiv Iyer","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618"},"headline":"Benchmarking ClickHouse on my MacBook Pro","datePublished":"2018-01-23T14:31:09+00:00","dateModified":"2018-03-13T13:41:41+00:00","mainEntityOfPage":{"@id":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/"},"wordCount":386,"commentCount":0,"publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"keywords":["ClickHouse","ClickHouse Benchmarking","ClickHouse Performance"],"articleSection":["ClickHouse","ClickHouse Benchmarking","ClickHouse Performance Benchmarking","Columnar Database System"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/","url":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/","name":"ClickHouse Benchmarking","isPartOf":{"@id":"https:\/\/minervadb.com\/#website"},"datePublished":"2018-01-23T14:31:09+00:00","dateModified":"2018-03-13T13:41:41+00:00","description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","breadcrumb":{"@id":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minervadb.com\/"},{"@type":"ListItem","position":2,"name":"Benchmarking ClickHouse on my MacBook Pro"}]},{"@type":"WebSite","@id":"https:\/\/minervadb.com\/#website","url":"https:\/\/minervadb.com\/","name":"The WebScale Database Infrastructure Operations Experts","description":"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations","publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minervadb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/minervadb.com\/#organization","name":"MinervaDB","url":"https:\/\/minervadb.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","width":200,"height":200,"caption":"MinervaDB"},"image":{"@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/webscaledba","https:\/\/www.linkedin.com\/company\/minervadb\/","https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618","name":"Shiv Iyer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","caption":"Shiv Iyer"},"description":"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.","sameAs":["http:\/\/minervadb.com","https:\/\/www.facebook.com\/TheWebScaleDBA","https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba"],"url":"https:\/\/minervadb.com\/index.php\/author\/shiv\/"}]}},"_links":{"self":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/643"}],"collection":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/comments?post=643"}],"version-history":[{"count":26,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/643\/revisions"}],"predecessor-version":[{"id":1050,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/643\/revisions\/1050"}],"wp:attachment":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/media?parent=643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/categories?post=643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/tags?post=643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

Deprecated: Function Yoast\WP\SEO\Conditionals\Schema_Blocks_Conditional::get_feature_flag is deprecated since version Yoast SEO 20.5 with no alternative available. in /home1/minerho3/public_html/wp-includes/functions.php on line 6078

Deprecated: Function Yoast\WP\SEO\Conditionals\Schema_Blocks_Conditional::get_feature_flag is deprecated since version Yoast SEO 20.5 with no alternative available. in /home1/minerho3/public_html/wp-includes/functions.php on line 6078

Deprecated: Function Yoast\WP\SEO\Conditionals\Schema_Blocks_Conditional::get_feature_flag is deprecated since version Yoast SEO 20.5 with no alternative available. in /home1/minerho3/public_html/wp-includes/functions.php on line 6078

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
{"id":643,"date":"2018-01-23T14:31:09","date_gmt":"2018-01-23T14:31:09","guid":{"rendered":"http:\/\/minervadb.com\/?p=643"},"modified":"2018-03-13T13:41:41","modified_gmt":"2018-03-13T13:41:41","slug":"benchmarking-clickhouse-2","status":"publish","type":"post","link":"https:\/\/minervadb.com\/index.php\/2018\/01\/23\/benchmarking-clickhouse-2\/","title":{"rendered":"Benchmarking ClickHouse on my MacBook Pro"},"content":{"rendered":"

I have used data from BUREAU OF TRANSPORTATION STATISTICS <\/span>https:\/\/www.transtats.bts.gov<\/a><\/span> \u00a0f<\/span>or benchmarking ClickHouse (https:\/\/clickhouse.yandex<\/a><\/span>)<\/span><\/p>\n

Table of Contents<\/p>\n