{"id":95202,"date":"2020-09-26T13:42:02","date_gmt":"2020-09-26T11:42:02","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/postgresql-13"},"modified":"2020-09-26T13:42:02","modified_gmt":"2020-09-26T11:42:02","slug":"postgresql-13","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/postgresql-13","title":{"rendered":"Postgresql 13","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

2023. gada 24. septembr\u012b izstr\u0101d\u0101t\u0101ju komanda pazi\u0146oja par jaun\u0101 Postgresql 13. versijas izlai\u0161anu. Jaunaj\u0101 laidien\u0101 tika piev\u0113rsta galven\u0101 uzman\u012bba veiktsp\u0113jas uzlabo\u0161anai, iek\u0161\u0113jo apkopes pakalpojumu pa\u0101trin\u0101\u0161anai un datu b\u0101zes uzraudz\u012bbas atvieglo\u0161anai, k\u0101 ar\u012b uzticam\u0101ka pieejas kontrolei sist\u0113mai.<\/p>\n

Turpin\u0101ta darba optimiz\u0101cija tabulu indeks\u0113\u0161an\u0101 attiec\u012bb\u0101 uz dublik\u0101tu apstr\u0101di indeks\u0113jamajos datos bin\u0101r\u0101s indeksu koku strukt\u016br\u0101s, kas \u013c\u0101va ne tikai pa\u0101trin\u0101t vaic\u0101jumu izpildi, bet ar\u012b samazin\u0101t indeksu nepiecie\u0161amo diska vietu.
\nTurkl\u0101t tika pievienots inkrement\u0101l\u0101s \u0161\u0137iro\u0161anas algoritms, kas \u013cauj \u0101tr\u0101k atk\u0101rtoti \u0161\u0137irot iepriek\u0161 \u0161\u0137irotos datus, un da\u017eu vaic\u0101jumu pa\u0101trin\u0101\u0161anai var izmantot jauno papla\u0161in\u0101to statistiku (caur komandu CREATE STATISTICS) efekt\u012bv\u0101ku soli pa solim pl\u0101na izstr\u0101d\u0113.
\nTika optimiz\u0113ta vaic\u0101jumu izpilde ar datus apgr\u016btin\u0101jo\u0161u agreg\u0101ciju, pla\u0161\u0101k izmantojot ha\u0161a agreg\u0101ciju un da\u013c\u0113ji saglab\u0101jot agreg\u0113tos datus disk\u0101, ja tie neietilpst operat\u012bvaj\u0101 atmi\u0146\u0101. Tika atz\u012bm\u0113ts noz\u012bm\u012bgs \u0101truma pieaugums tabulu savieno\u0161an\u0101, kas novietotas da\u017e\u0101d\u0101s sada\u013c\u0101s.<\/p>\n

Bija veikts iev\u0113rojams darbs, lai atvieglotu Postgresql datub\u0101zu apkalpo\u0161anu un administr\u0113\u0161anu. Ieb\u016bv\u0113t\u0101 uzdevuma \u00abvakum\u0113\u0161anas\u00bb funkcija, proti, br\u012bv\u0101s diskvietas izmanto\u0161ana p\u0113c rindu dz\u0113\u0161anas vai p\u0101rrakst\u012b\u0161anas, tagad var tikt veikta paral\u0113l\u0101s straum\u0113s, \u013caujot administratoram nor\u0101d\u012bt to skaitu. Papildus tam ir pievienoti jauni l\u012bdzek\u013ci, lai uzraudz\u012btu datub\u0101zes pa\u0161reiz\u0113jo aktivit\u0101ti, k\u0101 ar\u012b nov\u0113rstas k\u013c\u016bdas, sinhroniz\u0113jot iepriek\u0161\u0113j\u0101s pieraksta \u017eurn\u0101lus starp galveno un replik\u0101m, kas var\u0113ja izrais\u012bt konfliktus, izsl\u0113dzot replikas vai p\u0101rk\u0101pjot izplat\u012bt\u0101s datub\u0101zes integrit\u0101ti, atjaunojot t\u0101s, balstoties uz \u017eurn\u0101la datiem.<\/p>\n

Jauno izstr\u0101d\u0101t\u0101ju funkciju vid\u016b izce\u013cama ir datetime() funkcija, kas p\u0101rv\u0113r\u0161 da\u017e\u0101dus standarta laika form\u0101tus ieb\u016bv\u0113taj\u0101 Postgresql tip\u0101; no kastes pieejama UUID v4 \u0123ener\u0113\u0161anas funkcija gen_random_uuid(); Unicode apstr\u0101des normaliz\u0101cija; elast\u012bg\u0101ka datu sadal\u012b\u0161anas sist\u0113ma tabul\u0101m saist\u012btajos t\u012bkla mezglos ar piln\u012bgu lo\u0123isk\u0101s l\u012bme\u0146a replik\u0101ciju, k\u0101 ar\u012b citi uzlabojumi vaic\u0101jumos un jauni pieejamie trigeri replik\u0101m.<\/p>\n

Piek\u013cuves kontrole uz datub\u0101zi tiek izsludin\u0101ta k\u0101 viens no sist\u0113mas galvenajiem komponentiem, un jaunaj\u0101 versij\u0101 \u0161aj\u0101 jom\u0101 ir veiktas lielas izmai\u0146as. Tagad papla\u0161in\u0101jumu uzst\u0101d\u012b\u0161anu datub\u0101z\u0113 var veikt tikai privil\u0113\u0123\u0113ts lietot\u0101js (superuser). Parasti lietot\u0101ji var\u0113s uzst\u0101d\u012bt tikai tos papla\u0161in\u0101jumus, kas mar\u0137\u0113ti k\u0101 uzticami, vai nelielu skaitu papla\u0161in\u0101jumu, kas uzskat\u0101mi par uzticami p\u0113c noklus\u0113juma (piem\u0113ram, pgcrypto, tablefunc vai hstore). Autentifik\u0113jot lietot\u0101jus, izmantojot SCRAM meh\u0101nismu (str\u0101d\u0101jot caur libpq vad\u012bt\u0101ju), tagad nepiecie\u0161ama \u00abkan\u0101la saist\u012b\u0161ana\u00bb, un 13. versij\u0101 izejo\u0161o datu PostgreSQL funkcija atbalsta autoriz\u0101ciju, izmantojot sertifik\u0101tu.<\/p>\n

<\/p>\n

Izdo\u0161anas piez\u012bmes<\/a><\/p>\n

<\/noindex><\/noindex>
\n<\/p>\n

Lejupiel\u0101des lapa.<\/a><\/p>\n

<\/noindex><\/p>\n

Avots: linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

24 \u0441\u0435\u043d\u0442\u044f\u0431\u0440\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 \u0441\u043e\u043e\u0431\u0449\u0438\u043b\u0430 \u043e \u0432\u044b\u0445\u043e\u0434\u0435 \u043e\u0447\u0435\u0440\u0435\u0434\u043d\u043e\u0433\u043e \u0440\u0435\u043b\u0438\u0437\u0430 Postgresql \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 13. \u0412 \u043d\u043e\u0432\u043e\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0435 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435, \u0441\u0440\u0435\u0434\u0438 \u043f\u0440\u043e\u0447\u0435\u0433\u043e, \u0431\u044b\u043b\u043e \u0443\u0434\u0435\u043b\u0435\u043d\u043e \u043f\u043e\u0432\u044b\u0448\u0435\u043d\u0438\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438, \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u044e \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u0438\u0445 \u0441\u043b\u0443\u0436\u0431 \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u043e\u0449\u0435\u043d\u0438\u044e \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0430\u0437\u044b, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0431\u043e\u043b\u0435\u0435 \u043d\u0430\u0434\u0435\u0436\u043d\u043e\u043c\u0443 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0441\u0438\u0441\u0442\u0435\u043c\u0435. \u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u043b\u0430\u0441\u044c \u0440\u0430\u0431\u043e\u0442\u0430 \u043d\u0430\u0434 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0438\u043d\u0434\u0435\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 \u043f\u043b\u0430\u043d\u0435 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0441\u0440\u0435\u0434\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u0438\u0440\u0443\u0435\u043c\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0434\u0432\u043e\u0438\u0447\u043d\u044b\u0445 […]<\/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-95202","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Postgresql 13 | ProHoster","description":"24. septembr\u012b izstr\u0101d\u0101t\u0101ju komanda pazi\u0146oja par jaunas Postgresql versijas - 13. izdo\u0161anu.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/postgresql-13","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\udd47Postgresql 13 | ProHoster","og:description":"24 \u0441\u0435\u043d\u0442\u044f\u0431\u0440\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 \u0441\u043e\u043e\u0431\u0449\u0438\u043b\u0430 \u043e \u0432\u044b\u0445\u043e\u0434\u0435 \u043e\u0447\u0435\u0440\u0435\u0434\u043d\u043e\u0433\u043e \u0440\u0435\u043b\u0438\u0437\u0430 Postgresql \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 13.","og:url":"https:\/\/prohoster.info\/lv\/blog\/news\/postgresql-13","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-09-26T11:42:02+00:00","article:modified_time":"2020-09-26T11:42:02+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"95202","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 10:25:24","updated":"2022-10-03 07:46:19","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\/95202","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=95202"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/95202\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=95202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=95202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=95202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}