{"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\/bs\/blog\/news\/postgresql-13","title":{"rendered":"Postgresql 13","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Dana 24. septembra tim programera objavio je novi izdanak Postgresql pod brojem 13. U ovoj verziji, fokus je, izme\u0111u ostalog, bio na pobolj\u0161anju performansi, ubrzanju unutarnjih servisnih usluga i pojednostavljenju pra\u0107enja baze, kao i pouzdanijem kontroli pristupa sistemu.<\/p>\n<p>Nastavljen je rad na optimizaciji indeksiranja tabela u smislu obrade duplikata me\u0111u indeksiranim podacima u binarnim stablima indeksa, \u0161to je omogu\u0107ilo ne samo ubrzanje izvr\u0161avanja upita, ve\u0107 i smanjenje prostora koji indeks zauzima na disku.<br \/>\nOsim toga, dodat je algoritam inkrementalne sortiranja, pri \u010demu ponovna sortiranja ve\u0107 sortiranih podataka iz prethodnih koraka radi br\u017ee, a za deo upita ubrzanja mo\u017ee se posti\u0107i primenom nove pro\u0161irene statistike (preko komande CREATE STATISTICS) prilikom izra\u010dunavanja efikasnijeg korak-po-korak plana.<br \/>\nTako\u0111e je optimizovano izvr\u0161avanje upita sa skupljanjem podataka koje zahteva ve\u0107e resurse putem \u0161ire primene he\u0161irane agregacije i osloba\u0111anja dela agregiranih podataka na disk, ako se ne mogu smestiti u radnu memoriju. Prijavljeno je zna\u010dajno pove\u0107anje brzine povezivanja tabela sme\u0161tenih na razli\u010ditim particijama.<\/p>\n<p>Zna\u010dajan rad je ura\u0111en i u oblasti pojednostavljenja odr\u017eavanja i administracije PostgreSQL baza podataka. Ugra\u0111ena funkcija \u201evakumiranja\u201c, koja se odnosi na kori\u0161\u0107enje oslobo\u0111enog diskovnog prostora nakon brisanja ili prepisivanja redova, sada se mo\u017ee izvr\u0161avati u paralelnim tokovima, uz mogu\u0107nost za admina da odredi njihov broj. Pored toga, dodati su novi alati za pra\u0107enje trenutne aktivnosti baze i spre\u010dene su gre\u0161ke pri sinhronizaciji logova prethodnog snimanja izme\u0111u glavnog i replikacija, \u0161to je moglo dovesti do sukoba prilikom isklju\u010divanja replikacija ili naru\u0161iti integritet distribuirane baze nakon njihovog obnavljanja na osnovu podataka iz dnevnika.<\/p>\n<p>Izme\u0111u novina za programere, treba izdvojiti funkciju datetime(), koja pretvara razne standardne formate zapisa vremena u ugra\u0111eni tip Postgresql; dostupnu unaprijed funkciju za generisanje UUID v4 gen_random_uuid(); normalizaciju rada sa unicode-om; fleksibilniji sistem raspodjele podataka u tabelama na povezanim mre\u017enim \u010dvorovima baze sa potpunom replikacijom na logi\u010dkom nivou, kao i druge promjene u upitima i novim dostupnim replikama trigera.<\/p>\n<p>Kontrola pristupa bazi prikazana je kao jedan od klju\u010dnih komponenti sistema, a u novoj verziji su napravljeni veliki koraci napred. Sada instalaciju ekstenzija u bazi mo\u017ee izvoditi samo privilegovani korisnik (superuser). Obi\u010dni korisnici sada \u0107e mo\u0107i da instaliraju samo one ekstenzije koje su ozna\u010dene kao pouzdane ili mali skup ekstenzija koje se smatraju pouzdanim po defaultu (na primer, pgcrypto, tablefunc ili hstore). Prilikom autentifikacije korisnika putem SCRAM mehanizma (kada se koristi libpq drajver) sada je potrebna \u201evezivanje kanala\u201c, a omota\u010dka funkcija za strane podatke postgres_fdw od verzije 13 podr\u017eava autorizaciju putem sertifikata.<\/p>\n<p><noindex><noindex><\/p>\n<p><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/13\/release-13.html\">Napomene o izdanju<\/a><\/p>\n<p><\/noindex><\/noindex><br \/>\n<noindex><\/p>\n<p><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/download\/\">Stranica za preuzimanje<\/a><\/p>\n<p><\/noindex><\/p>\n<p>Izvor: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"http:\/\/www.linux.org.ru\/news\/opensource\/15914558\">linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>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 [&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-95202","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"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.\" \/>\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\/bs\/blog\/news\/postgresql-13\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"bs_BA\" \/>\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\udd47Postgresql 13 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/bs\/blog\/news\/postgresql-13\" \/>\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-09-26T11:42:02+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-26T11:42:02+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\udd47Postgresql 13 | ProHoster","description":"24. septembra, tim programera je objavio izlazak novog izdanja Postgresql pod brojem 13.","canonical_url":"https:\/\/prohoster.info\/bs\/blog\/news\/postgresql-13","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"bs_BA","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\/bs\/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\/bs\/wp-json\/wp\/v2\/posts\/95202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/comments?post=95202"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/95202\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/media?parent=95202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/categories?post=95202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/tags?post=95202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}