{"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\/lv\/blog\/administrirovanie\/testirovanie-proizvoditelnosti-analiticheskih-zaprosov-v-postgresql-clickhouse-i-clickhousedb_fdw-postgresql","title":{"rendered":"Veiktsp\u0113jas test\u0113\u0161ana anal\u012btiskajiem vaic\u0101jumiem PostgreSQL, ClickHouse un clickhousedb_fdw (PostgreSQL)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u0160aj\u0101 p\u0113t\u012bjum\u0101 es v\u0113l\u0113jos apskat\u012bt, k\u0101das veiktsp\u0113jas uzlabojumus var ieg\u016bt, izmantojot datu avotu ClickHouse, nevis PostgreSQL. Es zinu, k\u0101das veiktsp\u0113jas priek\u0161roc\u012bbas sniedz ClickHouse. Vai \u0161\u012bs priek\u0161roc\u012bbas saglab\u0101sies, ja es piek\u013cu\u0161u ClickHouse no PostgreSQL, izmantojot \u0101r\u0113jo datu apvalku (FDW)? <\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<p>P\u0113t\u0101m\u0101s datu b\u0101zes vidi ir PostgreSQL v11, clickhousedb_fdw un ClickHouse datu b\u0101ze. Galu gal\u0101 no PostgreSQL v11 m\u0113s izpild\u012bsim da\u017e\u0101dus SQL vaic\u0101jumus, kas tiks mar\u0161rut\u0113ti caur m\u016bsu clickhousedb_fdw uz ClickHouse datu b\u0101zi. P\u0113c tam m\u0113s redz\u0113sim, k\u0101 FDW veiktsp\u0113ja sal\u012bdzin\u0101s ar tiem pa\u0161iem vaic\u0101jumiem, kas tiek izpild\u012bti nativaj\u0101 PostgreSQL un nativaj\u0101 ClickHouse.<\/p>\n<p><\/p>\n<h3 id=\"baza-dannyh-clickhouse\">Clickhouse datu b\u0101ze<\/h3>\n<p><\/p>\n<p>ClickHouse ir atv\u0113rt\u0101 koda kolonnveida datu b\u0101zes p\u0101rvald\u012bbas sist\u0113ma, kas var sasniegt veiktsp\u0113ju no 100 l\u012bdz 1000 reiz\u0113m \u0101tr\u0101k nek\u0101 tradicion\u0101l\u0101s datu b\u0101zes pieejas, sp\u0113jot apstr\u0101d\u0101t vair\u0101k nek\u0101 miljardu rindu maz\u0101k nek\u0101 sekund\u0113.<\/p>\n<p><\/p>\n<h3 id=\"clickhousedb_fdw\">Clickhousedb_fdw<\/h3>\n<p><\/p>\n<p>clickhousedb_fdw ir ClickHouse datu b\u0101zes \u0101r\u0113jo datu apvalks (FDW), kas ir atv\u0113rt\u0101 koda projekts no Percona. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Percona-Lab\/clickhousedb_fdw\">\u0160eit ir saite uz projekta GitHub repozitoriju<\/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\/\">Mart\u0101 es uzrakst\u012bju emu\u0101ru, kas st\u0101sta vair\u0101k par m\u016bsu FDW<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>K\u0101 j\u016bs redz\u0113siet, tas nodro\u0161ina FDW ClickHouse, kas \u013cauj SELECT no, un INSERT INTO ClickHouse datu b\u0101zi no PostgreSQL v11 servera.<\/p>\n<p><\/p>\n<p>FDW atbalsta papla\u0161in\u0101tas funkcijas, piem\u0113ram, agreg\u0101ciju un apvieno\u0161anu. Tas iev\u0113rojami uzlabo veiktsp\u0113ju, izmantojot att\u0101l\u0101s servera resursus \u0161\u012bm resursietilp\u012bgaj\u0101m oper\u0101cij\u0101m.<\/p>\n<p><\/p>\n<h3 id=\"benchmark-environment\">M\u0113r\u012bjumu vide<\/h3>\n<p><\/p>\n<ul>\n<li>Supermicro serveris:\n<ul>\n<li>Intel&reg; Xeon&reg; CPU E5-2683 v3 @ 2.00GHz<\/li>\n<li>2 soketi \/ 28 kodoli \/ 56 pavedieni<\/li>\n<li>Atmi\u0146a: 256GB RAM<\/li>\n<li>Kr\u0101tuve: Samsung SM863 1.9TB uz\u0146\u0113muma SSD<\/li>\n<li>Failu sist\u0113ma: 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: versija 11<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"benchmark-tests\">M\u0113r\u012bjumu testi<\/h3>\n<p><\/p>\n<p>Pik\u013cu izmanto\u0161anai \u0161aj\u0101 test\u0101, nevis k\u0101du ma\u0161\u012bnas \u0123ener\u0113tu datu kopu, m\u0113s izmantoj\u0101m datus \"Veiktsp\u0113ja laik\u0101, zi\u0146ojot par operatora darba laiku\" no 1987. l\u012bdz 2018. gadam. J\u016bs varat piek\u013c\u016bt datiem <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Percona-Lab\/ontime-airline-performance\/blob\/master\/download.sh\">izmantojot m\u016bsu skriptu, kas pieejams \u0161eit<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>Datu b\u0101zes izm\u0113rs ir 85 GB, nodro\u0161inot vienu tabulu ar 109 kolonn\u0101m.<\/p>\n<p><\/p>\n<h4 id=\"benchmark-queries\">M\u0113r\u012bjumu vaic\u0101jumi<\/h4>\n<p><\/p>\n<p>\u0160eit ir vaic\u0101jumi, kurus es izmantoju, lai sal\u012bdzin\u0101tu ClickHouse, clickhousedb_fdw un PostgreSQL.<\/p>\n<p><\/p>\n<p><strong>Q#<\/strong><br \/>\n<strong>Vaic\u0101jums satur agreg\u0101tus un grupu pa<\/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 \/>\nIZVELIET DayOfWeek, count(*) AS c NO ontime KUR DepDelay&gt;10 UN GADS &gt;= 2000 UN GADS &lt;= 2008 GRUP\u0112JET p\u0113c DayOfWeek RIND\u0100 ar c DESC;<\/p>\n<p>Q3<br \/>\nIZVELIET Origin, count(*) AS c NO ontime KUR DepDelay&gt;10 UN GADS &gt;= 2000 UN GADS &lt;= 2008 GRUP\u0112JET p\u0113c Origin RIND\u0100 ar c DESC IEROBE\u017dOT 10;<\/p>\n<p>Q4<br \/>\nIZVELIET Carrier, count(<em>) NO ontime KUR DepDelay&gt;10 UN GADS = 2007 GRUP\u0112JET p\u0113c Carrier RIND\u0100 ar count(<\/em>) DESC;<\/p>\n<p>Q5<br \/>\nIZVELIET a.Carrier, c, c2, c<em>1000\/c2 k\u0101 c3 NO ( IZVELIET Carrier, count(<\/em>) AS c NO ontime KUR DepDelay&gt;10 UN GADS=2007 GRUP\u0112JET p\u0113c Carrier ) a IESTAT\u012aT ( IZVELIET Carrier,count(*) AS c2 NO ontime KUR GADS=2007 GRUP\u0112JET p\u0113c Carrier)b ON a.Carrier=b.Carrier RIND\u0100 ar c3 DESC;<\/p>\n<p>Q6<br \/>\nIZVELIET a.Carrier, c, c2, c<em>1000\/c2 k\u0101 c3 NO ( IZVELIET Carrier, count(<\/em>) AS c NO ontime KUR DepDelay&gt;10 UN GADS &gt;= 2000 UN GADS &lt;= 2008 GRUP\u0112JET p\u0113c Carrier) a IESTAT\u012aT ( IZVELIET Carrier, count(*) AS c2 NO ontime KUR GADS &gt;= 2000 UN GADS &lt;= 2008 GRUP\u0112JET p\u0113c Carrier ) b ON a.Carrier=b.Carrier RIND\u0100 ar c3 DESC;<\/p>\n<p>Q7<br \/>\nIZVELIET Carrier, avg(DepDelay) * 1000 AS c3 NO ontime KUR GADS &gt;= 2000 UN GADS &lt;= 2008 GRUP\u0112JET p\u0113c Carrier;<\/p>\n<p>Q8<br \/>\nIZVELIET GADS, avg(DepDelay) NO ontime GRUP\u0112JET p\u0113c GADS;<\/p>\n<p>Q9<br \/>\nizv\u0113lieties GADS, count(*) k\u0101 c1 no ontime grup\u0113t p\u0113c GADS;<\/p>\n<p>Q10<br \/>\nIZVELIET avg(cnt) NO (IZVELIET GADS, M\u0113nesis,count(*) AS cnt NO ontime KUR DepDel15=1 GRUP\u0112JET p\u0113c GADS, M\u0113nesis) a;<\/p>\n<p>Q11<br \/>\nizv\u0113lieties avg(c1) no (izv\u0113lieties GADS, M\u0113nesis,count(*) k\u0101 c1 no ontime grup\u0113t p\u0113c GADS, M\u0113nesis) a;<\/p>\n<p>Q12<br \/>\nIZVELIET OriginCityName, DestCityName, count(*) AS c NO ontime GRUP\u0112JET p\u0113c OriginCityName, DestCityName RIND\u0100 ar c DESC IEROBE\u017dOT 10;<\/p>\n<p>Q13<br \/>\nIZVELIET OriginCityName, count(*) AS c NO ontime GRUP\u0112JET p\u0113c OriginCityName RIND\u0100 ar c DESC IEROBE\u017dOT 10;<\/p>\n<p><strong>Query Satur Nav\u0113<\/strong><\/p>\n<p>Q14<br \/>\nIZVELIET a.GADS, c1\/c2 NO ( izv\u0113lieties GADS, count(<em>)<\/em>1000 k\u0101 c1 NO ontime KUR DepDelay&gt;10 GRUP\u0112JET p\u0113c GADS) a IESTAT\u012aT (izv\u0113lieties GADS, count(*) k\u0101 c2 no ontime grup\u0113t p\u0113c GADS ) b ON a.GADS=b.GADS RIND\u0100 ar a.GADS;<\/p>\n<p>Q15<br \/>\nIZVELIET a.\u201dGADS\u201d, c1\/c2 NO ( izv\u0113lieties \u201cGADS\u201d, count(<em>)<\/em>1000 k\u0101 c1 NO fontime KUR \u201cDepDelay\u201d&gt;10 GRUP\u0112JET p\u0113c \u201cGADS\u201d) a IESTAT\u012aT (izv\u0113lieties \u201cGADS\u201d, count(*) k\u0101 c2 no fontime grup\u0113t p\u0113c \u201cGADS\u201d ) b ON a.\u201dGADS\u201d=b.\u201dGADS\u201d;<\/p>\n<p><\/p>\n<p><em>Tabula-1: Vaic\u0101jumi, kas izmantoti sal\u012bdzin\u0101jum\u0101<\/em><\/p>\n<p><\/p>\n<h4 id=\"query-executions\">Vaic\u0101jumu izpildes<\/h4>\n<p><\/p>\n<p>\u0160eit ir katra vaic\u0101juma rezult\u0101ti, veicot da\u017eadas datub\u0101zes iestat\u012bjumus: PostgreSQL ar indeksiem un bez tiem, pa\u0161u ClickHouse un clickhousedb_fdw. Laiks tiek r\u0101d\u012bts milisekund\u0113s.<\/p>\n<p><\/p>\n<p><strong>Q#<\/strong><br \/>\n<strong>PostgreSQL<\/strong><br \/>\n<strong>PostgreSQL (indeks\u0113ts)<\/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>Tabula-1: Laiks, kas nepiecie\u0161ams, lai izpild\u012btu vaic\u0101jumus, kas izmantoti sal\u012bdzin\u0101jum\u0101<\/em><\/p>\n<p><\/p>\n<p>P\u0101rbaudiet rezult\u0101tus<\/p>\n<p><\/p>\n<p>Grafiks par\u0101da vaic\u0101juma izpildes laiku milisekund\u0113s, X ass par\u0101da vaic\u0101juma numuru no augst\u0101k min\u0113taj\u0101m tabul\u0101m, bet Y ass par\u0101da izpildes laiku milisekund\u0113s. ClickHouse rezult\u0101ti un dati, kas ieg\u016bti no postgres ar clickhousedb_fdw, tiek par\u0101d\u012bti. Tabul\u0101 redzams, ka past\u0101v milz\u012bga at\u0161\u0137ir\u012bba starp PostgreSQL un ClickHouse, bet minim\u0101la at\u0161\u0137ir\u012bba starp ClickHouse un clickhousedb_fdw.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Veiktsp\u0113jas test\u0113\u0161ana anal\u012btiskajiem vaic\u0101jumiem PostgreSQL, ClickHouse un clickhousedb_fdw (PostgreSQL)\" src=\"\/wp-content\/uploads\/2020\/07\/e084243ea7b327f30de5cb78339d3d3a.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>\u0160is grafiks par\u0101da at\u0161\u0137ir\u012bbas starp ClickhouseDB un clickhousedb_fdw. Liel\u0101kaj\u0101 da\u013c\u0101 vaic\u0101jumu FDW uzlikt\u0101s izmaksas nav tik lielas un, iesp\u0113jams, ir nenoz\u012bm\u012bgas, iz\u0146emot Q12. \u0160is vaic\u0101jums ietver apvienojumus un pas\u016bt\u012bjuma pied\u0101v\u0101jumu. Pas\u016bt\u012bjuma p\u0113c GROUP\/BY un ORDER BY tiek izlaisti l\u012bdz ClickHouse.<\/p>\n<p><\/p>\n<p>2. tabul\u0101 redzam pieaugumu vaic\u0101jumu Q12 un Q13 laik\u0101. Atk\u0101rtoju, tas ir saist\u012bts ar ORDER BY fr\u0101zi. Lai to apstiprin\u0101tu, es izpild\u012bju vaic\u0101jumus Q-14 un Q-15 ar ORDER BY fr\u0101zi un bez t\u0101s. Bez ORDER BY fr\u0101zes izpildes laiks ir 259 ms, bet ar ORDER BY fr\u0101zi \u2014 1364212. Lai atk\u013c\u016bdotu \u0161o vaic\u0101jumu, es paskaidroju abus vaic\u0101jumus, un \u0161eit ir paskaidrojumu rezult\u0101ti.<\/p>\n<p><\/p>\n<p>Q15: Bez ORDER BY fr\u0101zes<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">bm=# EXPLAIN VERBOSE SELECT a.&quot;Year&quot;, c1\/c2 \n     FROM (SELECT &quot;Year&quot;, count(*)*1000 AS c1 FROM fontime WHERE &quot;DepDelay&quot; &gt; 10 GROUP BY &quot;Year&quot;) a\n     INNER JOIN(SELECT &quot;Year&quot;, count(*) AS c2 FROM fontime GROUP BY &quot;Year&quot;) b ON a.&quot;Year&quot;=b.&quot;Year&quot;;<\/code><\/pre>\n<p><\/p>\n<p>Q15: Vaic\u0101jums bez ORDER BY fr\u0101zes<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">QUERY PLAN                                                      \nHash Join  (cost=2250.00..128516.06 rows=50000000 width=12)  \nOutput: fontime.&quot;Year&quot;, (((count(*) * 1000)) \/ b.c2)  \nInner Unique: true   Hash Cond: (fontime.&quot;Year&quot; = b.&quot;Year&quot;)  \n-&gt;  Foreign Scan  (cost=1.00..-1.00 rows=100000 width=12)        \nOutput: fontime.&quot;Year&quot;, ((count(*) * 1000))        \nRelations: Aggregate on (fontime)        \nRemote SQL: SELECT &quot;Year&quot;, (count(*) * 1000) FROM &quot;default&quot;.ontime WHERE ((&quot;DepDelay&quot; &gt; 10)) GROUP BY &quot;Year&quot;  \n-&gt;  Hash  (cost=999.00..999.00 rows=100000 width=12)        \nOutput: b.c2, b.&quot;Year&quot;        \n-&gt;  Subquery Scan on b  (cost=1.00..999.00 rows=100000 width=12)              \nOutput: b.c2, b.&quot;Year&quot;              \n-&gt;  Foreign Scan  (cost=1.00..-1.00 rows=100000 width=12)                    \nOutput: fontime_1.&quot;Year&quot;, (count(*))                    \nRelations: Aggregate on (fontime)                    \nRemote SQL: SELECT &quot;Year&quot;, count(*) FROM &quot;default&quot;.ontime GROUP BY &quot;Year&quot;(16 rows)<\/code><\/pre>\n<p><\/p>\n<p>Q14: Vaic\u0101jums ar ORDER BY fr\u0101zi<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">bm=# EXPLAIN VERBOSE SELECT a.&quot;Year&quot;, c1\/c2 FROM(SELECT &quot;Year&quot;, count(*)*1000 AS c1 FROM fontime WHERE &quot;DepDelay&quot; &gt; 10 GROUP BY &quot;Year&quot;) a \n     INNER JOIN(SELECT &quot;Year&quot;, count(*) as c2 FROM fontime GROUP BY &quot;Year&quot;) b  ON a.&quot;Year&quot;= b.&quot;Year&quot; \n     ORDER BY a.&quot;Year&quot;;<\/code><\/pre>\n<p><\/p>\n<p>Q14: Vaic\u0101juma pl\u0101ns ar ORDER BY fr\u0101zi<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">QUERY PLAN \nMerge Join\u00a0 (cost=2.00..628498.02 rows=50000000 width=12)\u00a0\u00a0 \nOutput: fontime.&quot;Year&quot;, (((count(*) * 1000)) \/ (count(*)))\u00a0\u00a0 \nInner Unique: true\u00a0\u00a0 Merge Cond: (fontime.&quot;Year&quot; = fontime_1.&quot;Year&quot;)\u00a0\u00a0 \n-&gt;\u00a0 GroupAggregate\u00a0 (cost=1.00..499.01 rows=1 width=12)\u00a0 \u00a0 \u00a0 \u00a0 \nOutput: fontime.&quot;Year&quot;, (count(*) * 1000)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \nGroup Key: fontime.&quot;Year&quot;\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \n-&gt;\u00a0 Foreign Scan on public.fontime\u00a0 (cost=1.00..-1.00 rows=100000 width=4)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \nRemote SQL: SELECT &quot;Year&quot; FROM &quot;default&quot;.ontime WHERE ((&quot;DepDelay&quot; &gt; 10)) \n            ORDER BY &quot;Year&quot; ASC\u00a0\u00a0 \n-&gt;\u00a0 GroupAggregate\u00a0 (cost=1.00..499.01 rows=1 width=12)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \nOutput: fontime_1.&quot;Year&quot;, count(*)\u00a0\u00a0 \u00a0 \u00a0 \u00a0 Group Key: fontime_1.&quot;Year&quot;\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \n-&gt;\u00a0 Foreign Scan on public.fontime fontime_1\u00a0 (cost=1.00..-1.00 rows=100000 width=4)\u00a0\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \nRemote SQL: SELECT &quot;Year&quot; FROM &quot;default&quot;.ontime ORDER BY &quot;Year&quot; ASC(16 rows)<\/code><\/pre>\n<p><\/p>\n<p>Izvade<\/p>\n<p><\/p>\n<p>\u0160o eksperimentu rezult\u0101ti r\u0101da, ka ClickHouse nodro\u0161ina patie\u0161\u0101m labu veiktsp\u0113ju, savuk\u0101rt clickhousedb_fdw pied\u0101v\u0101 ClickHouse veiktsp\u0113jas priek\u0161roc\u012bbas no PostgreSQL. Lai gan, izmantojot clickhousedb_fdw, ir da\u017ei p\u0101rvald\u012bbas izdevumi, tie ir nenoz\u012bm\u012bgi un sal\u012bdzin\u0101mi ar veiktsp\u0113ju, kas tiek sasniegta, dabiski darbinot datub\u0101z\u0113 ClickHouse. Tas ar\u012b apstiprina, ka fdw PostgreSQL nodro\u0161ina iev\u0113rojamus rezult\u0101tus.<\/p>\n<p><\/p>\n<p>Telegram grupas \u010dats par Clickhouse <noindex><a rel=\"nofollow\" href=\"https:\/\/t.me\/clickhouse_ru\">https:\/\/t.me\/clickhouse_ru<\/a><\/noindex><br \/>\nTelegram grupas \u010dats par PostgreSQL <noindex><a rel=\"nofollow\" href=\"https:\/\/t.me\/pgsql\">https:\/\/t.me\/pgsql<\/a><\/noindex><\/p>\n<p>Avots: <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.1 - 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\/lv\/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.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\/lv\/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\udd47Veiktsp\u0113jas test\u0113\u0161ana anal\u012btiskajiem vaic\u0101jumiem PostgreSQL, ClickHouse un clickhousedb_fdw (PostgreSQL) | ProHoster","description":"\u0160aj\u0101 p\u0113t\u012bjum\u0101 es v\u0113l\u0113tos apl\u016bkot, k\u0101das veiktsp\u0113jas uzlabo\u0161anas ir iesp\u0113jamas, izmantojot datu avotu ClickHouse, nevis PostgreSQL.","canonical_url":"https:\/\/prohoster.info\/lv\/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":"lv_LV","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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/89498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=89498"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/89498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media\/89499"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=89498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=89498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=89498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}