{"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\/lv\/blog\/news\/vypusk-subd-timescaledb-1-7","title":{"rendered":"TimescaleDB 1.7 versijas izdevums","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\">Public\u0113ts<\/a><\/noindex>   datub\u0101zes izlai\u0161ana <noindex><a rel=\"nofollow\" href=\"https:\/\/www.timescale.com\">TimescaleDB 1.7<\/a><\/noindex>, kas paredz\u0113ta datu glab\u0101\u0161anai un apstr\u0101dei laika rindas form\u0101 (m\u0113r\u012bjumu v\u0113rt\u012bbas pa noteiktiem laika interv\u0101liem, kur ieraksts veido laiku un saist\u012bt\u0101s ar to v\u0113rt\u012bbas). \u0160\u0101da glab\u0101\u0161anas forma ir optim\u0101la t\u0101d\u0101m lietojumprogramm\u0101m k\u0101 uzraudz\u012bbas sist\u0113mas, tirdzniec\u012bbas platformas, metrikas un sensora st\u0101vok\u013ca v\u0101k\u0161anas sist\u0113mas. Tiek nodro\u0161in\u0101ti l\u012bdzek\u013ci integr\u0101cijai ar projektu <noindex><a rel=\"nofollow\" href=\"https:\/\/grafana.com\/\">Grafana<\/a><\/noindex> un <noindex><a rel=\"nofollow\" href=\"https:\/\/prometheus.io\/\">Prometheus<\/a><\/noindex>. <\/p>\n<p>TimescaleDB projekts ir realiz\u0113ts k\u0101 papla\u0161in\u0101jums PostgreSQL un <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\">tiek izplat\u012bts<\/a><\/noindex> ir licenc\u0113ts saska\u0146\u0101 ar Apache 2.0. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/tree\/master\/tsl\">da\u013ca koda<\/a><\/noindex> ar papla\u0161in\u0101t\u0101m funkcij\u0101m tiek izsniegta saska\u0146\u0101 ar atsevi\u0161\u0137u komerci\u0101lo licenci <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/blob\/master\/tsl\/LICENSE-TIMESCALE\">Timescale<\/a><\/noindex> (TSL), kas ne\u013cauj veikt izmai\u0146as, aizliedz koda izmanto\u0161anu tre\u0161o pu\u0161u produktos un ne\u013cauj bezmaksas izmanto\u0161anu m\u0101ko\u0146a DB (database-as-a-service). <\/p>\n<p>Starp izmai\u0146\u0101m TimescaleDB 1.7:<\/p>\n<ul>\n<li class=\"l\"> Pievienota atbalsta nodro\u0161in\u0101\u0161ana integr\u0101cijai ar datub\u0101z\u0113m <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51604\">PostgreSQL 12<\/a><\/noindex>. Tika pazi\u0146ots, ka atbalsts PostgreSQL 9.6.x un 10.x ir novecojis (Timescale 2.0 atbalsts paliks tikai PostgreSQL 11+).\n<li class=\"l\"> Tika ir main\u012bjies piepras\u012bjumu uzved\u012bba ar nep\u0101rtraukti izpild\u0101m\u0101m agreg\u0101tu funkcij\u0101m (nepast\u0101v\u012bgi ien\u0101ko\u0161u datu agreg\u0101cija re\u0101llaik\u0101). \u0160\u0101di piepras\u012bjumi tagad apvieno materializ\u0113t\u0101s skata ar nesen ien\u0101ku\u0161ajiem datiem, kas v\u0113l nav materializ\u0113ti (agr\u0101k agreg\u0101cija aptv\u0113ra tikai jau materializ\u0113tos datus). Jaun\u0101 uzved\u012bba tiek piem\u0113rota jaunizveidot\u0101m nep\u0101rtraukt\u0101m agreg\u0101cij\u0101m, eso\u0161ajiem skatiem j\u0101iestata parametrs &#171;timescaledb.materialized_only=false&#187; ar &#171;ALTER VIEW&#187;.\n<li class=\"l\"> Kopienas versij\u0101 no komerci\u0101l\u0101s redakcijas ir p\u0101rnesti da\u017ei papla\u0161in\u0101ti datu dz\u012bves cikla p\u0101rvald\u012bbas r\u012bki, tostarp iesp\u0113jas datu p\u0101rgrup\u0113\u0161anai un novecoju\u0161o datu izsl\u0113g\u0161anas politiku apstr\u0101dei (\u013cauj glab\u0101t tikai aktu\u0101los datus un autom\u0101tiski dz\u0113st, agreg\u0113t vai arhiv\u0113t novecoju\u0161os ierakstus).\n<\/ul>\n<p>Atg\u0101din\u0101m, ka TimescaleDB DB \u013cauj izmantot pilnv\u0113rt\u012bgas SQL vaic\u0101jumus uz uzkr\u0101tajiem datiem, apvienojot rel\u0101ciju DB izmanto\u0161anas \u0113rt\u012bbu ar specializ\u0113to NoSQL sist\u0113mu m\u0113rogo\u0161anas un iesp\u0113j\u0101m. Glab\u0101\u0161anas strukt\u016bra ir optimiz\u0113ta, lai nodro\u0161in\u0101tu augstu datu pievieno\u0161anas \u0101trumu. Tiek atbalst\u012bta partiju datu komplektu pievieno\u0161ana, izmantojot atmi\u0146\u0101 izvietotus indeksus, v\u0113sturisko griezumu iel\u0101de pag\u0101tn\u0113 un dar\u012bjumu piem\u0113ro\u0161ana.<\/p>\n<p>Galven\u0101 iez\u012bme TimescaleDB ir autom\u0101tisk\u0101 datu mas\u012bva sekciju (partion\u0113\u0161anas) atbalsts. Ien\u0101ko\u0161ie datu pl\u016bsmas autom\u0101tiski tiek sadal\u012btas pa sekcij\u0101m tabul\u0101m. Sekcijas tiek izveidotas atkar\u012bb\u0101 no laika (katrai sekcijai ir uzkr\u0101ti dati noteikt\u0101 laika posm\u0101) vai saist\u012bb\u0101 ar jebk\u0101du atsl\u0113gu (piem\u0113ram, ier\u012bces identifikatoru, atra\u0161an\u0101s vietu utt.). Lai optimiz\u0113tu veiktsp\u0113ju, sekcij\u0101s sadal\u012bt\u0101s tabulas var tikt izvietotas da\u017e\u0101dos diskos. <\/p>\n<p>Sekcijai datu b\u0101ze izskat\u0101s k\u0101 viena liela tabula, kas saucas par hipertabulu. Hipertabula ir virtu\u0101ls viedoklis par daudz\u0101m atsevi\u0161\u0137\u0101m tabul\u0101m, kur\u0101s uzkr\u0101jas ien\u0101ko\u0161ie dati. Hipertabula tiek izmantota ne tikai piepras\u012bjumiem un datu pievieno\u0161anai, bet ar\u012b t\u0101d\u0101m oper\u0101cij\u0101m k\u0101 indeksu izveide un strukt\u016bras izmai\u0146as (&#171;ALTER TABLE&#187;), sl\u0113pjot no izstr\u0101d\u0101t\u0101ja zemo l\u012bme\u0146u segment\u0113to datu b\u0101zes strukt\u016bru. Ar hipertabulu var izmantot jebkuras agreg\u0101tu funkcijas, apak\u0161piepras\u012bjumus, apvieno\u0161anas (JOIN) oper\u0101cijas ar parastaj\u0101m tabul\u0101m un loga funkcijas.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Avots: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=52759\">opennet.lv<\/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.5 - 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\/lv\/blog\/news\/vypusk-subd-timescaledb-1-7\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\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\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\/lv\/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\udd47TimescaleDB 1.7 laidums | ProHoster","description":"Ir public\u0113ts TimescaleDB DB laidums.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-timescaledb-1-7","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\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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/78346","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=78346"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/78346\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=78346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=78346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=78346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}