{"id":89498,"date":"2020-07-23T13:42:07","date_gmt":"2020-07-23T11:42:07","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql"},"modified":"2020-07-23T13:42:07","modified_gmt":"2020-07-23T11:42:07","slug":"testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql","title":{"rendered":"Ytelsestesting av analytiske sp\u00f8rringer i PostgreSQL, ClickHouse og clickhousedb_fdw (PostgreSQL)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>I denne studien \u00f8nsket jeg \u00e5 se hvilke ytelsesforbedringer som kan oppn\u00e5s ved \u00e5 bruke datakilde ClickHouse i stedet for PostgreSQL. Jeg er klar over hvilke ytelsesfordeler jeg f\u00e5r ved \u00e5 bruke ClickHouse. Vil disse fordelene bli bevart hvis jeg f\u00e5r tilgang til ClickHouse fra PostgreSQL via et eksternt datagrensesnitt (FDW)? <\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<p>De unders\u00f8kte databasemilj\u00f8ene er PostgreSQL v11, clickhousedb_fdw og ClickHouse-databasen. Til slutt vil vi kj\u00f8re forskjellige SQL-sp\u00f8rringer fra PostgreSQL v11, rutet gjennom v\u00e5r clickhousedb_fdw til ClickHouse-databasen. Deretter vil vi se hvordan ytelsen til FDW sammenlignes med de samme sp\u00f8rringene utf\u00f8rt i b\u00e5de nativ PostgreSQL og nativ ClickHouse.<\/p>\n<p><\/p>\n<h3 id=\"baza-dannyh-clickhouse\">Clickhouse-database<\/h3>\n<p><\/p>\n<p>ClickHouse er et \u00e5pen kildekode kolonneorientert databash\u00e5ndteringssystem som kan oppn\u00e5 ytelse 100-1000 ganger raskere enn tradisjonelle databaser, og som kan behandle mer enn en milliard rader p\u00e5 mindre enn ett sekund.<\/p>\n<p><\/p>\n<h3 id=\"clickhousedb_fdw\">Clickhousedb_fdw<\/h3>\n<p><\/p>\n<p>clickhousedb_fdw er et eksternt datagrensesnitt for ClickHouse-databasen, eller FDW, utviklet som et open-source prosjekt av Percona. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Percona-Lab\/clickhousedb_fdw\">Her er lenken til prosjektets GitHub-repo<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/blog\/2019\/03\/29\/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw\/\">I mars skrev jeg en blogg som gir deg mer informasjon om v\u00e5r FDW<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>Som du vil se, gir dette FDW for ClickHouse muligheten til \u00e5 SELECT fra og INSERT INTO ClickHouse-databasen fra PostgreSQL v11-serveren.<\/p>\n<p><\/p>\n<p>FDW st\u00f8tter avanserte funksjoner som aggregater og join. Dette \u00f8ker ytelsen betydelig ved \u00e5 bruke ressurser fra den eksterne serveren for disse ressurskrevende operasjonene.<\/p>\n<p><\/p>\n<h3 id=\"benchmark-environment\">Benchmark-milj\u00f8<\/h3>\n<p><\/p>\n<ul>\n<li>Supermicro-server:\n<ul>\n<li>Intel\u00ae Xeon\u00ae CPU E5-2683 v3 @ 2.00GHz<\/li>\n<li>2 sokler \/ 28 kjerner \/ 56 tr\u00e5der<\/li>\n<li>Minne: 256 GB RAM<\/li>\n<li>Lagring: Samsung SM863 1.9TB Enterprise SSD<\/li>\n<li>Filsystem: ext4\/xfs<\/li>\n<\/ul>\n<\/li>\n<li>OS: Linux smblade01 4.15.0-42-generic #45~16.04.1-Ubuntu<\/li>\n<li>PostgreSQL: versjon 11<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"benchmark-tests\">Benchmark-tester<\/h3>\n<p><\/p>\n<p>I stedet for \u00e5 bruke et maskin-generert datasett til denne testen, brukte vi dataene \"Ytelse over tid rapportert av operat\u00f8rens kj\u00f8retid\" fra 1987 til 2018. Du kan f\u00e5 tilgang til dataene <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Percona-Lab\/ontime-airline-performance\/blob\/master\/download.sh\">ved hjelp av v\u00e5rt skript, tilgjengelig her<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>Databasen har en st\u00f8rrelse p\u00e5 85 GB, og har \u00e9n tabell med 109 kolonner.<\/p>\n<p><\/p>\n<h4 id=\"benchmark-queries\">Benchmark-sp\u00f8rringer<\/h4>\n<p><\/p>\n<p>Her er sp\u00f8rringene jeg brukte for \u00e5 sammenligne ClickHouse, clickhousedb_fdw og PostgreSQL.<\/p>\n<p><\/p>\n<p><strong>Q#<\/strong><br \/>\n<strong>Sp\u00f8rringen inneholder aggregater og Group By<\/strong><\/p>\n<p>Q1<br \/>\nSELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year &gt;= 2000 AND Year &lt;= 2008 GROUP BY DayOfWeek ORDER BY c DESC;<\/p>\n<p>Q2<br \/>\nVELG Dag I Uke, telte(*) AS c FRA ontime HVOR DepDelay&gt;10 OG \u00c5R &gt;= 2000 OG \u00c5R &lt;= 2008 GRUPPER ETTER Dag I Uke BESTILL c DESC;<\/p>\n<p>Q3<br \/>\nVELG Opprinnelse, telte(*) AS c FRA ontime HVOR DepDelay&gt;10 OG \u00c5R &gt;= 2000 OG \u00c5R &lt;= 2008 GRUPPER ETTER Opprinnelse BESTILL c DESC BEGRENSE 10;<\/p>\n<p>Q4<br \/>\nVELG Fraktf\u00f8rer, telte(<em>) FRA ontime HVOR DepDelay&gt;10 OG \u00c5R = 2007 GRUPPER ETTER Fraktf\u00f8rer BESTILL telte(<\/em>) DESC;<\/p>\n<p>Q5<br \/>\nVELG a.Fraktf\u00f8rer, c, c2, c<em>1000\/c2 som c3 FRA ( VELG Fraktf\u00f8rer, telte(<\/em>) AS c FRA ontime HVOR DepDelay&gt;10 OG \u00c5R=2007 GRUPPER ETTER Fraktf\u00f8rer ) a INNREDS MED ( VELG Fraktf\u00f8rer,tallet(*) AS c2 FRA ontime HVOR \u00c5R=2007 GRUPPER ETTER Fraktf\u00f8rer)b p\u00e5 a.Fraktf\u00f8rer=b.Fraktf\u00f8rer BESTILL c3 DESC;<\/p>\n<p>Q6<br \/>\nVELG a.Fraktf\u00f8rer, c, c2, c<em>1000\/c2 som c3 FRA ( VELG Fraktf\u00f8rer, telte(<\/em>) AS c FRA ontime HVOR DepDelay&gt;10 OG \u00c5R &gt;= 2000 OG \u00c5R = 2000 OG \u00c5R &lt;= 2008 GRUPPER ETTER Fraktf\u00f8rer ) b p\u00e5 a.Fraktf\u00f8rer=b.Fraktf\u00f8rer BESTILL c3 DESC;<\/p>\n<p>Q7<br \/>\nVELG Fraktf\u00f8rer, gjennomsnitt(DepDelay) * 1000 AS c3 FRA ontime HVOR \u00c5R &gt;= 2000 OG \u00c5R &lt;= 2008 GRUPPER ETTER Fraktf\u00f8rer;<\/p>\n<p>Q8<br \/>\nVELG \u00c5R, gjennomsnitt(DepDelay) FRA ontime GRUPPER ETTER \u00c5R;<\/p>\n<p>Q9<br \/>\nvelg \u00c5R, telte(*) som c1 fra ontime gruppert etter \u00c5R;<\/p>\n<p>Q10<br \/>\nVELG gjennomsnitt(cnt) FRA (VELG \u00c5R,M\u00e5ned,telte(*) AS cnt FRA ontime HVOR DepDel15=1 GRUPPER ETTER \u00c5R,M\u00e5ned) a;<\/p>\n<p>Q11<br \/>\nvelg gjennomsnitt(c1) fra (velg \u00c5R,M\u00e5ned,telte(*) som c1 fra ontime gruppert etter \u00c5R,M\u00e5ned) a;<\/p>\n<p>Q12<br \/>\nVELG OpprinnelsesbyNavn, DestbyNavn, telte(*) AS c FRA ontime GRUPPER ETTER OpprinnelsesbyNavn, DestbyNavn BESTILL c DESC BEGRENSE 10;<\/p>\n<p>Q13<br \/>\nVELG OpprinnelsesbyNavn, telte(*) AS c FRA ontime GRUPPER ETTER OpprinnelsesbyNavn BESTILL c DESC BEGRENSE 10;<\/p>\n<p><strong>Sp\u00f8rring Inneholder Sammenf\u00f8yninger<\/strong><\/p>\n<p>Q14<br \/>\nVELG a.\u00c5R, c1\/c2 FRA ( velg \u00c5R, telte(<em>)<\/em>1000 som c1 FRA ontime HVOR DepDelay&gt;10 GRUPPERT ETTER \u00c5R) a INNREDS MED (velg \u00c5R, telte(*) som c2 FRA ontime GRUPPERT ETTER \u00c5R ) b p\u00e5 a.\u00c5R=b.\u00c5R BESTILL a.\u00c5R;<\/p>\n<p>Q15<br \/>\nVELG a.\u201d\u00c5R\u201d, c1\/c2 FRA ( velg \u201c\u00c5R\u201d, telte(<em>)<\/em>1000 som c1 FRA fontime HVOR \u201cDepDelay\u201d&gt;10 GRUPPERT ETTER \u201c\u00c5R\u201d) a INNREDS MED (velg \u201c\u00c5R\u201d, telte(*) som c2 FRA fontime GRUPPERT ETTER \u201c\u00c5R\u201d ) b p\u00e5 a.\u201d\u00c5R\u201d=b.\u201d\u00c5R\u201d;<\/p>\n<p><\/p>\n<p><em>Tabell-1: Sp\u00f8rringer brukt i benchmark<\/em><\/p>\n<p><\/p>\n<h4 id=\"query-executions\">Sp\u00f8rringsutf\u00f8relse<\/h4>\n<p><\/p>\n<p>Her er resultatene av hver sp\u00f8rring n\u00e5r den ble utf\u00f8rt med forskjellige databaseinnstillinger: PostgreSQL med indekser og uten, egen ClickHouse og clickhousedb_fdw. Tiden vises i millisekunder.<\/p>\n<p><\/p>\n<p><strong>Q#<\/strong><br \/>\n<strong>PostgreSQL<\/strong><br \/>\n<strong>PostgreSQL (Indeksert)<\/strong><br \/>\n<strong>ClickHouse<\/strong><br \/>\n<strong>clickhousedb_fdw<\/strong><\/p>\n<p>Q1<br \/>\n27920<br \/>\n19634<br \/>\n23<br \/>\n57<\/p>\n<p>Q2<br \/>\n35124<br \/>\n17301<br \/>\n50<br \/>\n80<\/p>\n<p>Q3<br \/>\n34046<br \/>\n15618<br \/>\n67<br \/>\n115<\/p>\n<p>Q4<br \/>\n31632<br \/>\n7667<br \/>\n25<br \/>\n37<\/p>\n<p>Q5<br \/>\n47220<br \/>\n8976<br \/>\n27<br \/>\n60<\/p>\n<p>Q6<br \/>\n58233<br \/>\n24368<br \/>\n55<br \/>\n153<\/p>\n<p>Q7<br \/>\n30566<br \/>\n13256<br \/>\n52<br \/>\n91<\/p>\n<p>Q8<br \/>\n38309<br \/>\n60511<br \/>\n112<br \/>\n179<\/p>\n<p>Q9<br \/>\n20674<br \/>\n37979<br \/>\n31<br \/>\n81<\/p>\n<p>Q10<br \/>\n34990<br \/>\n20102<br \/>\n56<br \/>\n148<\/p>\n<p>Q11<br \/>\n30489<br \/>\n51658<br \/>\n37<br \/>\n155<\/p>\n<p>Q12<br \/>\n39357<br \/>\n33742<br \/>\n186<br \/>\n1333<\/p>\n<p>Q13<br \/>\n29912<br \/>\n30709<br \/>\n101<br \/>\n384<\/p>\n<p>Q14<br \/>\n54126<br \/>\n39913<br \/>\n124<br \/>\n1364212<\/p>\n<p>Q15<br \/>\n97258<br \/>\n30211<br \/>\n245<br \/>\n259<\/p>\n<p><\/p>\n<p><em>Tabell-1: Tid brukt til \u00e5 utf\u00f8re sp\u00f8rringene brukt i benchmark<\/em><\/p>\n<p><\/p>\n<p>Vis resultater<\/p>\n<p><\/p>\n<p>Grafen viser tiden som ble brukt til \u00e5 utf\u00f8re sp\u00f8rringen i millisekunder, X-aksen viser sp\u00f8rringsnummeret fra tabellene ovenfor, mens Y-aksen viser tiden brukt i millisekunder. Resultatene fra ClickHouse og data hentet fra postgres med clickhousedb_fdw vises. Tabellen viser at det er en enorm forskjell mellom PostgreSQL og ClickHouse, men minimal forskjell mellom ClickHouse og clickhousedb_fdw.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Ytelsestesting av analytiske sp\u00f8rringer i PostgreSQL, ClickHouse og clickhousedb_fdw (PostgreSQL)\" src=\"\/wp-content\/uploads\/2020\/07\/e084243ea7b327f30de5cb78339d3d3a.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Denne grafen viser forskjellen mellom ClickhouseDB og clickhousedb_fdw. I de fleste sp\u00f8rringer er overheaden fra FDW ikke s\u00e5 stor og knapt merkbar, unntatt Q12. Denne sp\u00f8rringen inkluderer sammenf\u00f8yninger og ORDER BY setning. P\u00e5 grunn av ORDER BY GROUP\/BY og ORDER BY g\u00e5r ikke ned til ClickHouse.<\/p>\n<p><\/p>\n<p>I tabell 2 ser vi et sprang i tiden for foresp\u00f8rslene Q12 og Q13. Jeg gjentar, dette skyldes tilbudet ORDER BY. For \u00e5 bekrefte dette, utf\u00f8rte jeg foresp\u00f8rslene Q-14 og Q-15 med og uten tilbudet ORDER BY. Uten tilbudet ORDER BY er fullf\u00f8ringstiden 259 ms, mens med tilbudet ORDER BY er tiden 1364212. For \u00e5 feils\u00f8ke denne foresp\u00f8rselen forklarer jeg begge foresp\u00f8rslene, og her er resultatene av forklaringen.<\/p>\n<p><\/p>\n<p>Q15: Uten ORDER BY-klausul<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">bm=# FORKLARA VERBALT VELG a.\"\u00c5r\", c1\/c2 \n     FRA (VELG \"\u00c5r\", tell(*)*1000 SOM c1 FRA fontime HVOR \"DepDelay\" &gt; 10 GRUPPER ETTER \"\u00c5r\") a\n     INN\u00c5 (VELG \"\u00c5r\", tell(*) SOM c2 FRA fontime GRUPPER ETTER \"\u00c5r\") b P\u00c5 a.\"\u00c5r\"=b.\"\u00c5r\";<\/code><\/pre>\n<p><\/p>\n<p>Q15: Foresp\u00f8rsel uten ORDER BY-klausul<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">SP\u00d8RSM\u00c5LSPLAN \nHash Join  (kostnad=2250.00..128516.06 rader=50000000 bredde=12)  \nUtdata: fontime.\"\u00c5r\", (((tell(*) * 1000)) \/ b.c2)  \nIndre Unik: sann  Hash Bet.: (fontime.\"\u00c5r\" = b.\"\u00c5r\")  \n-&gt;  Utenlandsk Skann  (kostnad=1.00..-1.00 rader=100000 bredde=12)        \nUtdata: fontime.\"\u00c5r\", ((tell(*) * 1000))        \nForhold: Aggregat i (fontime)        \nFjern SQL: VELG \"\u00c5r\", (tell(*) * 1000) FRA \"default\".ontime HVOR ((\"DepDelay\" &gt; 10)) GRUPPER ETTER \"\u00c5r\"  \n-&gt;  Hash  (kostnad=999.00..999.00 rader=100000 bredde=12)        \nUtdata: b.c2, b.\"\u00c5r\"        \n-&gt;  Delsp\u00f8rring Skann p\u00e5 b  (kostnad=1.00..999.00 rader=100000 bredde=12)              \nUtdata: b.c2, b.\"\u00c5r\"              \n-&gt;  Utenlandsk Skann  (kostnad=1.00..-1.00 rader=100000 bredde=12)                    \nUtdata: fontime_1.\"\u00c5r\", (tell(*))                    \nForhold: Aggregat i (fontime)                    \nFjern SQL: VELG \"\u00c5r\", tell(*) FRA \"default\".ontime GRUPPER ETTER \"\u00c5r\" (16 rader)<\/code><\/pre>\n<p><\/p>\n<p>Q14: Foresp\u00f8rsel med ORDER BY-klausul<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">bm=# FORKLARA VERBALT VELG a.\"\u00c5r\", c1\/c2 FRA(VELG \"\u00c5r\", tell(*)*1000 SOM c1 FRA fontime HVOR \"DepDelay\" &gt; 10 GRUPPER ETTER \"\u00c5r\") a \n     INN\u00c5(VELG \"\u00c5r\", tell(*) som c2 FRA fontime GRUPPER ETTER \"\u00c5r\") b  P\u00c5 a.\"\u00c5r\"= b.\"\u00c5r\" \n     BESTIL ETTER a.\"\u00c5r\";<\/code><\/pre>\n<p><\/p>\n<p>Q14: Foresp\u00f8rsel Plan med ORDER BY-klausul<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">SP\u00d8RSM\u00c5LSPLAN \nFusioner Join\u00a0 (kostnad=2.00..628498.02 rader=50000000 bredde=12)\u00a0\u00a0 \nUtdata: fontime.\"\u00c5r\", (((tell(*) * 1000)) \/ (tell(*)))\u00a0\u00a0 \nIndre Unik: sann\u00a0\u00a0 Fusioner Bet.: (fontime.\"\u00c5r\" = fontime_1.\"\u00c5r\")\u00a0\u00a0 \n-&gt;\u00a0 Grupperings Aggregat\u00a0 (kostnad=1.00..499.01 rader=1 bredde=12)\u00a0 \u00a0 \u00a0 \u00a0 \nUtdata: fontime.\"\u00c5r\", (tell(*) * 1000)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \nGruppe N\u00f8kkel: fontime.\"\u00c5r\"\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \n-&gt;\u00a0 Utenlandsk Skann p\u00e5 public.fontime\u00a0 (kostnad=1.00..-1.00 rader=100000 bredde=4)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \nFjern SQL: VELG \"\u00c5r\" FRA \"default\".ontime HVOR ((\"DepDelay\" &gt; 10)) \n            BESTIL ETTER \"\u00c5r\" ASC\u00a0\u00a0 \n-&gt;\u00a0 Grupperings Aggregat\u00a0 (kostnad=1.00..499.01 rader=1 bredde=12)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \nUtdata: fontime_1.\"\u00c5r\", tell(*)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 Gruppe N\u00f8kkel: fontime_1.\"\u00c5r\"\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \n-&gt;\u00a0 Utenlandsk Skann p\u00e5 public.fontime fontime_1\u00a0 (kostnad=1.00..-1.00 rader=100000 bredde=4)\u00a0\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \nFjern SQL: VELG \"\u00c5r\" FRA \"default\".ontime BESTIL ETTER \"\u00c5r\" ASC (16 rader)<\/code><\/pre>\n<p><\/p>\n<p>Utdata<\/p>\n<p><\/p>\n<p>Resultata av desse eksperimenta viser at ClickHouse tilbyr verkeleg god ytelse, og clickhousedb_fdw gir fordelar ved ytelsen til ClickHouse fr\u00e5 PostgreSQL. Sj\u00f8lv om det er nokre kostnader involvert i bruken av clickhousedb_fdw, er desse ubetydelige og samanliknbare med ytelsen oppn\u00e5dd ved eit naturleg oppsett i ClickHouse-databasen. Dette bekrefter ogs\u00e5 at fdw i PostgreSQL gir imponerande resultat.<\/p>\n<p><\/p>\n<p>Telegram-chat om Clickhouse <noindex><a rel=\"nofollow\" href=\"https:\/\/t.me\/clickhouse_ru\">https:\/\/t.me\/clickhouse_ru<\/a><\/noindex><br \/>\nTelegram-chat om PostgreSQL <noindex><a rel=\"nofollow\" href=\"https:\/\/t.me\/pgsql\">https:\/\/t.me\/pgsql<\/a><\/noindex><\/p>\n<p>Kilde: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/511992\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412 \u044d\u0442\u043e\u043c \u0438\u0441\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u043d\u0438\u0438 \u044f \u0445\u043e\u0442\u0435\u043b \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u043a\u0430\u043a\u0438\u0435 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a \u0434\u0430\u043d\u043d\u044b\u0445 ClickHouse, \u0430 \u043d\u0435 PostgreSQL. \u042f \u0437\u043d\u0430\u044e, \u043a\u0430\u043a\u0438\u0435 \u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0430 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 ClickHouse \u044f \u043f\u043e\u043b\u0443\u0447\u0430\u044e. \u0411\u0443\u0434\u0443\u0442 \u043b\u0438 \u044d\u0442\u0438 \u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0430 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u044b, \u0435\u0441\u043b\u0438 \u044f \u043f\u043e\u043b\u0443\u0447\u0443 \u0434\u043e\u0441\u0442\u0443\u043f \u043a ClickHouse \u0438\u0437 PostgreSQL \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0432\u043d\u0435\u0448\u043d\u0435\u0439 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 (FDW)? \u0418\u0441\u0441\u043b\u0435\u0434\u0443\u0435\u043c\u044b\u043c\u0438 \u0441\u0440\u0435\u0434\u0430\u043c\u0438 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u044f\u0432\u043b\u044f\u044e\u0442\u0441\u044f PostgreSQL v11, clickhousedb_fdw [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":89499,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-89498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412 \u044d\u0442\u043e\u043c \u0438\u0441\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u043d\u0438\u0438 \u044f \u0445\u043e\u0442\u0435\u043b \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u043a\u0430\u043a\u0438\u0435 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a \u0434\u0430\u043d\u043d\u044b\u0445 ClickHouse, \u0430 \u043d\u0435 PostgreSQL.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"nn_NO\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0422\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0432 PostgreSQL, ClickHouse \u0438 clickhousedb_fdw (PostgreSQL) | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412 \u044d\u0442\u043e\u043c \u0438\u0441\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u043d\u0438\u0438 \u044f \u0445\u043e\u0442\u0435\u043b \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u043a\u0430\u043a\u0438\u0435 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a \u0434\u0430\u043d\u043d\u044b\u0445 ClickHouse, \u0430 \u043d\u0435 PostgreSQL.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-07-23T11:42:07+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-07-23T11:42:07+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Testing av ytelsen til analytiske foresp\u00f8rselar i PostgreSQL, ClickHouse og clickhousedb_fdw (PostgreSQL) | ProHoster","description":"I denne studien ville eg sj\u00e5 p\u00e5 kva ytelsesforbetringar ein kan oppn\u00e5 ved \u00e5 bruke ClickHouse som datakjelde i staden for PostgreSQL.","canonical_url":"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"nn_NO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0422\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0432 PostgreSQL, ClickHouse \u0438 clickhousedb_fdw (PostgreSQL) | ProHoster","og:description":"\u0412 \u044d\u0442\u043e\u043c \u0438\u0441\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u043d\u0438\u0438 \u044f \u0445\u043e\u0442\u0435\u043b \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u043a\u0430\u043a\u0438\u0435 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a \u0434\u0430\u043d\u043d\u044b\u0445 ClickHouse, \u0430 \u043d\u0435 PostgreSQL.","og:url":"https:\/\/prohoster.info\/no\/blog\/administrirovanie\/testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-07-23T11:42:07+00:00","article:modified_time":"2020-07-23T11:42:07+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"89498","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 13:10:17","updated":"2022-10-10 22:45:45","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/89498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/comments?post=89498"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/89498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/media\/89499"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/media?parent=89498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/categories?post=89498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/tags?post=89498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}