{"id":38636,"date":"2019-10-31T22:24:58","date_gmt":"2019-10-31T19:24:58","guid":{"rendered":"https:\/\/prohoster.info\/blog\/reliz-subd-postgresql-12\/"},"modified":"2019-10-31T22:24:58","modified_gmt":"2019-10-31T19:24:58","slug":"reliz-subd-postgresql-12","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/news\/reliz-subd-postgresql-12","title":{"rendered":"PostgreSQL 12 andmebaasi versioon","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u00e4rast aasta arendust <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/about\/news\/1976\/\">avalikustatud<\/a><\/noindex> Uus stabiilne PostgreSQL 12 andmebaasi haru. Uuendusi uue haru jaoks <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/support\/versioning\/\">v\u00e4lja antakse<\/a><\/noindex> viie aasta jooksul kuni novembri 2024. aastani. <\/p>\n<p>Peamised <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/static\/release-12.html\">uuendused<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Lisatud toetust &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/ddl-generated-columns.html\">generaatorveergudele<\/a><\/noindex>&#171;, mille v\u00e4\u00e4rtus arvutatakse teiste veergude v\u00e4\u00e4rtusi katva v\u00e4ljendi p\u00f5hjal samas tabelis (sarnane vaadetele, kuid eraldi veergude jaoks). Genereeritud veerud v\u00f5ivad olla kaht t\u00fc\u00fcpi &#8212; salvestatavad ja virtuaalsed. Esimeses juhul arvutatakse v\u00e4\u00e4rtus andmete lisamisel v\u00f5i muutmisel, teises &#8212; iga kord lugemise k\u00e4igus teiste veergude jooksva seisundi p\u00f5hjal. Hetkel toetab PostgreSQL ainult salvestatavaid genereeritud veerge;\n<li class=\"l\"> Lisatud v\u00f5imalus andmep\u00e4ringute tegemiseks JSON-dokumentidest kasutades <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/functions-json.html#FUNCTIONS-SQLJSON-PATH\">Path-v\u00e4ljendeid<\/a><\/noindex>, mis meenutavad <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/XPath\">XPath<\/a><\/noindex> ja on m\u00e4\u00e4ratletud SQL\/JSON standardis. T\u00f5hususe suurendamiseks selliste v\u00e4ljendite t\u00f6\u00f6tlemisel JSONB-formaadis dokumentide jaoks rakendatakse olemasolevaid indekseerimise mehhanisme;\n<li class=\"l\"> Vaikimisi on sisse l\u00fclitatud JIT-kompilaatori (Just-in-Time) rakendamine, mis p\u00f5hineb LLVM arengul, et kiirendada teatud v\u00e4ljendite t\u00e4itmist SQL-p\u00e4ringu t\u00f6\u00f6tlemise k\u00e4igus. N\u00e4iteks on JIT rakendatav v\u00e4ljendite t\u00e4itmise kiirusel &#171;WHERE&#187; plokkides, sihtloendites (target lists), agregeerimise v\u00e4ljendites ja teatud sisemistes operatsioonides;\n<li class=\"l\"> Indekseerimise j\u00f5udlust on m\u00e4rkimisv\u00e4\u00e4rselt suurendatud. B-tree indeksid on optimeeritud t\u00f6\u00f6tamiseks tingimustes, kus indeksid muutuvad sageli &#8212; TPC-C testides on t\u00e4heldatud \u00fcldist j\u00f5udluse suurenemist ja keskmiselt 40% d\u00fcnaamilise ketaspinna tarbimise v\u00e4henemist. WAL-i (Write Ahead Log) genereerimise kulusid on v\u00e4hendatud GiST, GIN ja SP-GiST indeksit\u00fc\u00fcpi. GiST-ile on lisatud v\u00f5imalus luua kaante indeksid (INCLUDE v\u00e4ljendi kaudu), mis sisaldavad t\u00e4iendavaid veerge. Operatsiooni <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/sql-createstatistics.html\">CREATE STATISTICS<\/a><\/noindex> toetab k\u00f5ige t\u00fc\u00fcpilisemate v\u00e4\u00e4rtuste statistika (MCV), mis v\u00f5imaldab genereerida optimaalsemaid p\u00e4ringute plaane mitte\u00fchtlaselt jaotatud veergude kasutamisel;\n<li class=\"l\"> Partitsioneerimise rakendamine on optimeeritud p\u00e4ringute jaoks, mis katab tuhandeid sektsioone, kuid piirduvad piiratud andmete alamkogumitega. Sektsioneeritud tabelitesse andmete lisamise j\u00f5udlust on suurendatud INSERT ja COPY operatsioonide kaudu ning uute sektsioonide lisamise v\u00f5imalus &#171;ALTER TABLE ATTACH PARTITION&#187; kaudu ilma p\u00e4ringute t\u00e4itmise blokeerimiseta;\n<li class=\"l\"> On lisatud toetus automaatsele inline-lahti\u00fctlemisele \u00fcldistest tabeli v\u00e4ljenditest (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/queries-with.html\">Common Table Expression<\/a><\/noindex>, CTE), mis v\u00f5imaldab kasutada ajutisi nimelisi tulemusseadeid, m\u00e4\u00e4ratud kasutades operaatoreid WITH. Inline-lahti\u00fctlemine suurendab enamiku p\u00e4ringute j\u00f5udlust, kuid praegu rakendatakse seda ainult rekursiivsete CTE-de puhul;\n<li class=\"l\"> Lisatud tugi <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/collation.html#COLLATION-NONDETERMINISTIC\">mitteterminiteeritud<\/a><\/noindex> locale &#171;Collation&#187; omadused, mis v\u00f5imaldavad m\u00e4\u00e4rata sorteerimisreegleid ja rikkaid v\u00f5rreldes t\u00e4hestikuliste s\u00fcmbolite m\u00f5istmisega (n\u00e4iteks, arvv\u00e4\u00e4rtuste sortimisel arvestatakse miinusm\u00e4rgi ja koma olemasolu enne numbrit, samuti erinevaid kirjutamisviise, samas kui v\u00f5rreldes ei arvestata s\u00fcmbolite suurt\u00e4htsust ja aktsendi olemasolu);\n<li class=\"l\"> On lisatud toetus mitme faktori autentimisele, kus pg_hba.conf-i autentimise korral on v\u00f5imalik kombineerida SSL-sertifikaadi (clientcert=verify-full) autentimist t\u00e4iendava autentimismeetodiga, n\u00e4iteks scram-sha-256;\n<li class=\"l\"> On lisatud toetus andmeside kanali kr\u00fcpteerimisele autentimisel l\u00e4bi <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/gssapi-auth.html\">GSSAPI<\/a><\/noindex>, nii kliendi kui ka serveri poolel;\n<li class=\"l\"> Lisatud on toetust LDAP-serverite m\u00e4\u00e4ramiseks &#171;DNS SRV&#187; kirjete p\u00f5hjal, kui PostgreSQL on loodud OpenLDAP-i abil;\n<li class=\"l\"> Lisatud on operatsioon &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/sql-reindex.html#SQL-REINDEX-CONCURRENTLY\">REINDEX CONCURRENTLY<\/a><\/noindex>\u00bb indekseid \u00fcmberkujundamiseks ilma indeksi kirjutamise toimingute blokeerimiseta;\n<li class=\"l\"> Lisatud k\u00e4sk <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/app-pgchecksums.html\">pg_checksums<\/a><\/noindex>, mis v\u00f5imaldab olemasoleval andmebaasil sisse ja v\u00e4lja l\u00fclitada andmefailide lehek\u00fclgede kontrollsummade kontrollimise (varem toetati seda operatsiooni ainult andmebaasi initsialiseerimise ajal);\n<li class=\"l\"> On tagatud edenemise indikaatori v\u00e4ljund CREATE INDEX, REINDEX, CLUSTER, VACUUM FULL ja pg_checksums operatsioonide t\u00e4itmise ajal;\n<li class=\"l\"> Lisatud k\u00e4sk \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/tableam.html\">CREATE ACCESS METHOD<\/a><\/noindex>\u00bb uute tabelite salvestamismeetodite t\u00f6\u00f6tlemise \u00fchendamiseks, mis on optimeeritud erinevate spetsiifiliste \u00fclesannete jaoks. Praegu on ainus sisseehitatud meetod tabelitele juurdep\u00e4\u00e4suks \u00abheap\u00bb;\n<li class=\"l\"> Konfiguratsioonifail recovery.conf on \u00fchendatud postgresql.conf-iga. T\u00f5rke taastamise seisundisse \u00fclemineku indikaatoriteks on n\u00fc\u00fcd <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVE-RECOVERY\">p\u00e4rast<\/a><\/noindex> kasutada faile recovery.signal ja standby.signal.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Allikas: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51604\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0443\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442\u044c \u0432 \u0442\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u044f\u0442\u0438 \u043b\u0435\u0442 \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2024 \u0433\u043e\u0434\u0430. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043d\u043e\u0432\u0448\u0435\u0441\u0442\u0432\u0430: \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 &#171;\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u043c\u044b\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432&#171;, \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0432\u044b\u0447\u0438\u0441\u043b\u044f\u0435\u0442\u0441\u044f \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f, \u043e\u0445\u0432\u0430\u0442\u044b\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0434\u0440\u0443\u0433\u0438\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0432 \u0442\u043e\u0439 \u0436\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 (\u0430\u043d\u0430\u043b\u043e\u0433 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u0439, \u043d\u043e \u0434\u043b\u044f \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432). \u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u043c\u044b\u0435 \u0441\u0442\u043e\u043b\u0431\u0446\u044b \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u0434\u0432\u0443\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-38636","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12.\" \/>\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\/et\/blog\/news\/reliz-subd-postgresql-12\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\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\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 PostgreSQL 12 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/news\/reliz-subd-postgresql-12\" \/>\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=\"2019-10-31T19:24:58+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:24:58+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 PostgreSQL 12 andmebaasihalduri v\u00e4ljalase | ProHoster","description":"P\u00e4rast aastat arendust on v\u00e4lja antud uus stabiilne versioon andmebaasihaldurist PostgreSQL 12.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/reliz-subd-postgresql-12","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 PostgreSQL 12 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12.","og:url":"https:\/\/prohoster.info\/et\/blog\/news\/reliz-subd-postgresql-12","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":"2019-10-31T19:24:58+00:00","article:modified_time":"2019-10-31T19:24:58+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"38636","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":"2026-01-23 22:52:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:06:23","updated":"2026-01-23 22:52:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/38636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=38636"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/38636\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=38636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=38636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=38636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}