{"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\/sk\/blog\/news\/vypusk-subd-timescaledb-1-7","title":{"rendered":"Vydanie DBMS 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\">Zverejnen\u00e9<\/a><\/noindex>   vydanie DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.timescale.com\">TimescaleDB 1.7<\/a><\/noindex>, ur\u010den\u00e9ho na ukladanie a spracovanie \u00fadajov vo forme \u010dasov\u00e9ho radu (rez hodnotov\u00fdch parametrov v zadan\u00fdch \u010dasov\u00fdch intervaloch, z\u00e1znam vytv\u00e1ra \u010das a sadu pr\u00edslu\u0161n\u00fdch hodn\u00f4t k tomuto \u010dasu). Tak\u00e1to forma ukladania je optim\u00e1lna pre aplik\u00e1cie ako syst\u00e9my monitorovania, obchodn\u00e9 platformy, syst\u00e9my zberu metr\u00edk a stavov senzorov. Poskytuj\u00fa sa prostriedky na integr\u00e1ciu s projektom <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 realizovan\u00fd ako roz\u0161\u00edrenie pre PostgreSQL a <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\">distribuovan\u00fd<\/a><\/noindex> pod licenciou Apache 2.0. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/tree\/master\/tsl\">\u010cas\u0165 k\u00f3du<\/a><\/noindex> s roz\u0161\u00edren\u00fdmi mo\u017enos\u0165ami sa dod\u00e1va pod samostatnou propriet\u00e1rnou licenciou <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/blob\/master\/tsl\/LICENSE-TIMESCALE\">Timescale<\/a><\/noindex> (TSL), ktor\u00e1 neumo\u017e\u0148uje vykon\u00e1va\u0165 \u00fapravy, zakazuje pou\u017e\u00edvanie k\u00f3du v extern\u00fdch produktoch a nedovo\u013euje bezplatn\u00e9 pou\u017e\u00edvanie v cloudov\u00fdch DB (database-as-a-service). <\/p>\n<p>Medzi zmenami v TimescaleDB 1.7:<\/p>\n<ul>\n<li class=\"l\"> Pridan\u00e1 podpora integr\u00e1cie s DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51604\">PostgreSQL 12<\/a><\/noindex>. Vyhl\u00e1sen\u00e1 za zastaran\u00fa podpora PostgreSQL 9.6.x a 10.x (v Timescale 2.0 zostane podpora len pre PostgreSQL 11+).\n<li class=\"l\"> Spr\u00e1vanie dotazov s nepretr\u017eite vykon\u00e1van\u00fdmi agreg\u00e1tmi bolo zmenen\u00e9 (agregovanie nepretr\u017eite prich\u00e1dzaj\u00facich \u00fadajov v re\u00e1lnom \u010dase). Tak\u00e9to dotazy teraz kombinuj\u00fa materializovan\u00e9 poh\u013eady s ned\u00e1vno prich\u00e1dzaj\u00facimi \u00fadajmi, ktor\u00e9 e\u0161te nie s\u00fa materializovan\u00e9 (predt\u00fdm agregovanie pokr\u00fdvalo iba u\u017e materializovan\u00e9 \u00fadaje). Nov\u00e9 spr\u00e1vanie sa aplikuje na nov\u00e9 vytvoren\u00e9 nepretr\u017eit\u00e9 agreg\u00e1cie; pre existuj\u00face poh\u013eady je potrebn\u00e9 nastavi\u0165 parameter &#171;timescaledb.materialized_only=false&#187; prostredn\u00edctvom &#171;ALTER VIEW&#187;.\n<li class=\"l\"> Do Community verzie boli prenesen\u00e9 niektor\u00e9 roz\u0161\u00edren\u00e9 prostriedky riadenia \u017eivotn\u00e9ho cyklu \u00fadajov z komer\u010dnej ed\u00edcie, vr\u00e1tane mo\u017enost\u00ed pre pregrupovanie \u00fadajov a spracovanie polit\u00edk na vyra\u010fovanie zastaran\u00fdch \u00fadajov (umo\u017e\u0148uj\u00fa uchov\u00e1va\u0165 len aktu\u00e1lne \u00fadaje a automaticky odstra\u0148ova\u0165, agregova\u0165 alebo archivova\u0165 zastaran\u00e9 z\u00e1znamy).\n<\/ul>\n<p>Pripom\u00edname, \u017ee S\u00daDB TimescaleDB umo\u017e\u0148uje vyu\u017e\u00edva\u0165 plnohodnotn\u00e9 SQL dotazy na anal\u00fdzu nahromaden\u00fdch \u00fadajov, sp\u00e1jaj\u00fac pohodlie pr\u00e1ce charakteristick\u00e9 pre rela\u010dn\u00e9 S\u00daDB s roz\u0161\u00edrite\u013enos\u0165ou a mo\u017enos\u0165ami, ktor\u00e9 s\u00fa vlastn\u00e9 \u0161pecializovan\u00fdm NoSQL syst\u00e9mom. \u0160trukt\u00fara ukladania je optimalizovan\u00e1 pre zabezpe\u010denie vysokej r\u00fdchlosti prid\u00e1vania \u00fadajov. Podporuje sa hromadn\u00e9 prid\u00e1vanie s\u00faborov \u00fadajov, pou\u017e\u00edvanie pam\u00e4\u0165ov\u00fdch indexov, na\u010d\u00edtanie historick\u00fdch segmentov so sp\u00e4tnou platnos\u0165ou a aplik\u00e1cia transakci\u00ed.<\/p>\n<p>K\u013e\u00fa\u010dovou vlastnos\u0165ou TimescaleDB je podpora automatick\u00e9ho rozdelenia (particionovania) polia \u00fadajov. Prich\u00e1dzaj\u00faci pr\u00fad \u00fadajov sa automaticky rozde\u013euje do partitionovan\u00fdch tabuliek. Sekcie sa vytv\u00e1raj\u00fa pod\u013ea \u010dasu (v ka\u017edej sekcii s\u00fa ulo\u017een\u00e9 \u00fadaje za ur\u010dit\u00fd \u010dasov\u00fd \u00fasek) alebo na z\u00e1klade priraden\u00e9ho k\u013e\u00fa\u010da (napr\u00edklad identifik\u00e1tora zariadenia, umiestnenia at\u010f.). Na optimaliz\u00e1ciu v\u00fdkonu m\u00f4\u017eu by\u0165 partitionovan\u00e9 tabulky rozdelen\u00e9 na r\u00f4zne disky. <\/p>\n<p>Pre dotazy sekcionovan\u00e1 datab\u00e1za vyzer\u00e1 ako jedna ve\u013ek\u00e1 tabu\u013eka, naz\u00fdvan\u00e1 hypertabu\u013eka. Hypertabu\u013eka predstavuje virtu\u00e1lny poh\u013ead na mno\u017estvo samostatn\u00fdch tabuliek, v ktor\u00fdch s\u00fa zhroma\u017e\u010fovan\u00e9 prich\u00e1dzaj\u00face \u00fadaje. Hypertabu\u013eka sa pou\u017e\u00edva nielen na dotazy a prid\u00e1vanie \u00fadajov, ale aj na oper\u00e1cie ako vytv\u00e1ranie indexov a zmenu \u0161trukt\u00fary (&#171;ALTER TABLE&#187;), pri\u010dom skr\u00fdva pred v\u00fdvoj\u00e1rom n\u00edzko\u00farov\u0148ov\u00fa segmentovan\u00fa \u0161trukt\u00faru datab\u00e1zy. S hypertabu\u013ekou je mo\u017en\u00e9 pou\u017e\u00edva\u0165 ak\u00e9ko\u013evek agreg\u00e1tne funkcie, poddotazy, oper\u00e1cie spojenia (JOIN) s be\u017en\u00fdmi tabu\u013ekami a oknov\u00e9 funkcie.<\/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.4 - 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\/sk\/blog\/news\/vypusk-subd-timescaledb-1-7\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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\/sk\/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\udd47Vydanie S\u00daDB TimescaleDB 1.7 | ProHoster","description":"Bol zverejnen\u00fd vydanie S\u00daDB TimescaleDB.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-timescaledb-1-7","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/78346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=78346"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/78346\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=78346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=78346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=78346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}