{"id":78346,"date":"2020-04-18T19:42:08","date_gmt":"2020-04-18T17:42:08","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-timescaledb-1-7"},"modified":"2020-04-18T19:42:08","modified_gmt":"2020-04-18T17:42:08","slug":"vypusk-subd-timescaledb-1-7","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-timescaledb-1-7","title":{"rendered":"Vyd\u00e1n\u00ed datab\u00e1ze TimescaleDB 1.7","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/releases\/tag\/1.7.0\">Byl zve\u0159ejn\u011bn<\/a><\/noindex>   vyd\u00e1n\u00ed DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.timescale.com\">TimescaleDB 1.7<\/a><\/noindex>, ur\u010den\u00e9 pro ukl\u00e1d\u00e1n\u00ed a zpracov\u00e1n\u00ed dat ve form\u00e1tu \u010dasov\u00e9 \u0159ady (v\u00fd\u0159ezy hodnot parametr\u016f v dan\u00fdch \u010dasov\u00fdch intervalech, z\u00e1znamy tvo\u0159\u00ed \u010das a sadu odpov\u00eddaj\u00edc\u00edch hodnot k tomuto \u010dasu). Tento form\u00e1t ukl\u00e1d\u00e1n\u00ed je optim\u00e1ln\u00ed pro takov\u00e9 aplikace, jako jsou syst\u00e9my monitorov\u00e1n\u00ed, obchodn\u00ed platformy, syst\u00e9my sb\u011bru metrik a stav\u016f senzor\u016f. Jsou poskytov\u00e1ny n\u00e1stroje pro integraci s projektem <noindex><a rel=\"nofollow\" href=\"https:\/\/grafana.com\/\">Grafana<\/a><\/noindex> a <noindex><a rel=\"nofollow\" href=\"https:\/\/prometheus.io\/\">Prometheus<\/a><\/noindex>. <\/p>\n<p>Projekt TimescaleDB je realizov\u00e1n jako roz\u0161\u00ed\u0159en\u00ed k PostgreSQL a <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\">distribuov\u00e1no<\/a><\/noindex> pod licenc\u00ed Apache 2.0. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/tree\/master\/tsl\">\u010d\u00e1st k\u00f3du<\/a><\/noindex> s roz\u0161\u00ed\u0159en\u00fdmi mo\u017enostmi se dod\u00e1v\u00e1 pod samostatnou propriet\u00e1rn\u00ed licenc\u00ed <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/blob\/master\/tsl\/LICENSE-TIMESCALE\">Timescale<\/a><\/noindex> (TSL), kter\u00e1 neumo\u017e\u0148uje modifikace, zakazuje pou\u017eit\u00ed k\u00f3du ve t\u0159et\u00edch produktech a nedovoluje bezplatn\u00e9 pou\u017eit\u00ed v cloudov\u00fdch DB (database-as-a-service). <\/p>\n<p>Mezi zm\u011bnami v TimescaleDB 1.7:<\/p>\n<ul>\n<li class=\"l\"> Byla p\u0159id\u00e1na podpora integrace s DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51604\">PostgreSQL 12<\/a><\/noindex>. Podpora PostgreSQL 9.6.x a 10.x byla ozna\u010dena za zastaralou (v Timescale 2.0 z\u016fstane podpora pouze pro PostgreSQL 11+).\n<li class=\"l\"> Zm\u011bn\u011bno chov\u00e1n\u00ed dotaz\u016f s kontinu\u00e1ln\u011b vykon\u00e1van\u00fdmi agrega\u010dn\u00edmi funkcemi (agregace kontinu\u00e1ln\u011b p\u0159ich\u00e1zej\u00edc\u00edch dat v re\u00e1ln\u00e9m \u010dase). Takov\u00e9 dotazy nyn\u00ed kombinuj\u00ed materializovan\u00e9 pohledy s nov\u011b p\u0159\u00edchoz\u00edmi daty, kter\u00e1 je\u0161t\u011b nejsou materializov\u00e1na (d\u0159\u00edve agregace pokr\u00fdvala pouze ji\u017e materializovan\u00e1 data). Nov\u00e9 chov\u00e1n\u00ed se aplikuje na nov\u011b vytvo\u0159en\u00e9 kontinu\u00e1ln\u00ed agregace, pro st\u00e1vaj\u00edc\u00ed pohledy je t\u0159eba nastavit parametr &#171;timescaledb.materialized_only=false&#187; pomoc\u00ed &#171;ALTER VIEW&#187;.\n<li class=\"l\"> Do verze Community bylo z komer\u010dn\u00ed edice p\u0159eneseno n\u011bkolik roz\u0161\u00ed\u0159en\u00fdch n\u00e1stroj\u016f pro spr\u00e1vu \u017eivotn\u00edho cyklu dat, v\u010detn\u011b schopnost\u00ed p\u0159eorganizace dat a zpracov\u00e1n\u00ed politik pro vy\u0159azov\u00e1n\u00ed zastaral\u00fdch dat (umo\u017e\u0148uj\u00ed uchov\u00e1vat pouze aktu\u00e1ln\u00ed data a automaticky odstra\u0148ovat, agregovat nebo archivovat zastaral\u00e9 z\u00e1znamy).\n<\/ul>\n<p>P\u0159ipom\u00edn\u00e1me, \u017ee datab\u00e1zov\u00fd syst\u00e9m TimescaleDB umo\u017e\u0148uje pou\u017e\u00edvat plnohodnotn\u00e9 SQL dotazy k anal\u00fdze shrom\u00e1\u017ed\u011bn\u00fdch dat, kombinuje pohodl\u00ed pr\u00e1ce charakteristick\u00e9 pro rela\u010dn\u00ed datab\u00e1ze s mo\u017enostmi \u0161k\u00e1lov\u00e1n\u00ed a funkcemi, kter\u00e9 jsou vlastn\u00ed specializovan\u00fdm NoSQL syst\u00e9m\u016fm. Struktura ukl\u00e1d\u00e1n\u00ed je optimalizov\u00e1na pro vysokou rychlost p\u0159id\u00e1v\u00e1n\u00ed dat. Podporuje d\u00e1vkov\u00e9 p\u0159id\u00e1v\u00e1n\u00ed sad dat, pou\u017eit\u00ed index\u016f um\u00edst\u011bn\u00fdch v pam\u011bti, nahr\u00e1v\u00e1n\u00ed historick\u00fdch \u0159ez\u016f zp\u011btn\u011b a pou\u017eit\u00ed transakc\u00ed.<\/p>\n<p>Kl\u00ed\u010dovou vlastnost\u00ed TimescaleDB je podpora automatick\u00e9ho partitioningu (d\u011bl\u011bn\u00ed) datov\u00e9ho pole. P\u0159\u00edchoz\u00ed tok dat je automaticky rozd\u011blov\u00e1n podle partitionovan\u00fdch tabulek. Sekce jsou vytv\u00e1\u0159eny v z\u00e1vislosti na \u010dase (v ka\u017ed\u00e9 sekci se uchov\u00e1vaj\u00ed data za ur\u010dit\u00e9 \u010dasov\u00e9 obdob\u00ed) nebo jsou v\u00e1z\u00e1ny na libovoln\u00fd kl\u00ed\u010d (nap\u0159\u00edklad identifik\u00e1tor za\u0159\u00edzen\u00ed, um\u00edst\u011bn\u00ed atd.). Pro optimalizaci v\u00fdkonu mohou b\u00fdt partitionovan\u00e9 tabulky rozlo\u017eeny na r\u016fzn\u00e9 disky. <\/p>\n<p>Pro dotazy v sekcionovan\u00e9 datab\u00e1zi vypad\u00e1 jako jedna velk\u00e1 tabulka, ozna\u010dovan\u00e1 jako hypertabulka. Hypertabulka p\u0159edstavuje virtu\u00e1ln\u00ed pohled na mnoho jednotliv\u00fdch tabulek, ve kter\u00fdch se shroma\u017e\u010fuj\u00ed p\u0159\u00edchoz\u00ed data. Hypertabulka se pou\u017e\u00edv\u00e1 nejen pro dotazy a p\u0159id\u00e1v\u00e1n\u00ed dat, ale tak\u00e9 pro operace jako je vytv\u00e1\u0159en\u00ed index\u016f a zm\u011bna struktury (&#171;ALTER TABLE&#187;), \u010d\u00edm\u017e skr\u00fdv\u00e1 p\u0159ed v\u00fdvoj\u00e1\u0159em n\u00edzkou \u00farove\u0148 segmentovan\u00e9 struktury datab\u00e1ze. S hypertabulkou lze pou\u017e\u00edvat jak\u00e9koli agrega\u010dn\u00ed funkce, poddotazy, operace spojov\u00e1n\u00ed (JOIN) s b\u011b\u017en\u00fdmi tabulkami a oknov\u00e9 funkce.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Zdroj: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=52759\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB 1.7, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0444\u043e\u0440\u043c\u0435 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0433\u043e \u0440\u044f\u0434\u0430 (\u0441\u0440\u0435\u0437\u044b \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 \u0447\u0435\u0440\u0435\u0437 \u0437\u0430\u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043a\u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438, \u0437\u0430\u043f\u0438\u0441\u044c \u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u0432\u0440\u0435\u043c\u044f \u0438 \u043d\u0430\u0431\u043e\u0440 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0445 \u044d\u0442\u043e\u043c\u0443 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439). \u041f\u043e\u0434\u043e\u0431\u043d\u0430\u044f \u0444\u043e\u0440\u043c\u0430 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u043e\u043f\u0442\u0438\u043c\u0430\u043b\u044c\u043d\u0430 \u0434\u043b\u044f \u0442\u0430\u043a\u0438\u0445 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u043a\u0430\u043a \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430, \u0442\u043e\u0440\u0433\u043e\u0432\u044b\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b, \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0441\u0431\u043e\u0440\u0430 \u043c\u0435\u0442\u0440\u0438\u043a \u0438 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0439 \u0434\u0430\u0442\u0447\u0438\u043a\u043e\u0432. \u041f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u0434\u043b\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438 \u0441 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-78346","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB.\" \/>\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\/cs\/blog\/news\/vypusk-subd-timescaledb-1-7\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB 1.7 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-timescaledb-1-7\" \/>\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-04-18T17:42:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-18T17:42:08+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\udd47 Vyd\u00e1n\u00ed datab\u00e1zov\u00e9ho syst\u00e9mu TimescaleDB 1.7 | ProHoster","description":"Bylo vyd\u00e1no vyd\u00e1n\u00ed datab\u00e1zov\u00e9ho syst\u00e9mu TimescaleDB.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-timescaledb-1-7","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB 1.7 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB.","og:url":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-timescaledb-1-7","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-04-18T17:42:08+00:00","article:modified_time":"2020-04-18T17:42:08+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"78346","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 16:59:36","updated":"2022-10-01 02:34:05","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/78346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=78346"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/78346\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=78346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=78346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=78346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}