{"id":119954,"date":"2024-09-26T21:43:01","date_gmt":"2024-09-26T19:43:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-17"},"modified":"2024-09-26T21:43:01","modified_gmt":"2024-09-26T19:43:01","slug":"reliz-subd-postgresql-17","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-postgresql-17","title":{"rendered":"Megjelent a PostgreSQL 17 adatb\u00e1zis-kezel\u0151 rendszer.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>A fejleszt\u00e9s egy \u00e9ve ut\u00e1n megjelent a PostgreSQL 17 \u00faj stabil \u00e1ga. A friss\u00edt\u00e9sek az \u00faj \u00e1ghoz \u00f6t \u00e9ven kereszt\u00fcl, 2029 november\u00e9ig \u00e9rkeznek. A PostgreSQL 12.x, a leg\u00f6regebb t\u00e1mogatott \u00e1g t\u00e1mogat\u00e1sa 2023. november 14-\u00e9n megsz\u0171nik.     <\/p>\n<p>F\u0151bb \u00faj\u00edt\u00e1sok:  <\/p>\n<ul>\n<li class=\"l\"> A VACUUM m\u0171velet (a lom eltakar\u00edt\u00e1sa, tiszt\u00edt\u00e1s \u00e9s a lemezt\u00e1rol\u00f3 csomagol\u00e1sa) sor\u00e1n egy \u00faj adatszerkezet l\u00e9p \u00e9letbe, amely ak\u00e1r 20-szor kevesebb mem\u00f3ri\u00e1t ig\u00e9nyel. Az \u00faj strukt\u00far\u00e1ra val\u00f3 \u00e1tt\u00e9r\u00e9s gyorsabb\u00e1 tette a VACUUM m\u0171veletek v\u00e9grehajt\u00e1s\u00e1t, \u00e9s cs\u00f6kkentette a k\u00f6z\u00f6sen haszn\u00e1lt er\u0151forr\u00e1sok fogyaszt\u00e1s\u00e1t.\n<li class=\"l\"> Folytat\u00f3dott a bemeneti\/kimeneti teljes\u00edtm\u00e9ny optimaliz\u00e1l\u00e1sa. A k\u00e9sleltetett \u00edr\u00e1si napl\u00f3 (WAL) kezel\u00e9s\u00e9re kifejlesztett k\u00f3djav\u00edt\u00e1sok r\u00e9v\u00e9n ak\u00e1r a k\u00e9tszeres\u00e9re n\u0151tt a fel\u00edr\u00e1si m\u0171veletek \u00e1tereszt\u0151k\u00e9pess\u00e9ge nagy sz\u00e1m\u00fa egyidej\u0171 k\u00e9r\u00e9s eset\u00e9n. Javasoltak egy \u00faj stream bemeneti\/kimeneti interf\u00e9szt, amely felgyors\u00edtotta az adatok sorozatos feldolgoz\u00e1s\u00e1t a t\u00e1bl\u00e1kban, \u00e9s gyorsabb\u00e1 tette a statisztika friss\u00edt\u00e9s\u00e9t a lek\u00e9rdez\u00e9stervez\u0151 sz\u00e1m\u00e1ra az ANALYZE m\u0171velet v\u00e9grehajt\u00e1sa ut\u00e1n.\n<li class=\"l\"> N\u00f6velve lett a lek\u00e9rdez\u00e9sek teljes\u00edtm\u00e9nye az 'IN' kifejez\u00e9ssel, ha azok B-farok (B-tree) strukt\u00far\u00e1j\u00fa indexeket haszn\u00e1lnak. Megval\u00f3sult a p\u00e1rhuzamos BRIN (Block Range Index) index\u00e9p\u00edt\u00e9s lehet\u0151s\u00e9ge. A lek\u00e9rdez\u00e9s-tervez\u0151ben optimaliz\u00e1lt\u00e1k a 'NOT NULL' ellen\u0151rz\u00e9seket, \u00e9s felgyors\u00edtott\u00e1k a k\u00f6z\u00f6s t\u00e1blak\u00e9pek (Common Table Expressions, CTE) SQL-parancs 'WITH' seg\u00edts\u00e9g\u00e9vel t\u00f6rt\u00e9n\u0151 meghat\u00e1roz\u00e1s\u00e1t. Biztos\u00edtva lett a vektoros processzor utas\u00edt\u00e1sok (SIMD) haszn\u00e1lata bizonyos sz\u00e1m\u00edt\u00e1sok felgyors\u00edt\u00e1s\u00e1ra, p\u00e9ld\u00e1ul a bit_count f\u00fcggv\u00e9nyhez AVX-512 utas\u00edt\u00e1sokat haszn\u00e1ltak.\n<li class=\"l\"> Megval\u00f3s\u00edtott\u00e1k az \u00faj funkci\u00f3k t\u00e1mogat\u00e1s\u00e1t a JSON form\u00e1tum kezel\u00e9s\u00e9re, amelyeket az SQL\/JSON szabv\u00e1ny hat\u00e1rozott meg. Hozz\u00e1adt\u00e1k a JSON-TABLE funkci\u00f3t, amely lehet\u0151v\u00e9 teszi a JSON form\u00e1tumb\u00f3l a hagyom\u00e1nyos PostgreSQL t\u00e1bl\u00e1kra val\u00f3 \u00e1talak\u00edt\u00e1st, valamint \u00faj jsonpath oper\u00e1torokat a JSON adatok PostgreSQL-re jellemz\u0151 adatt\u00edpusokra val\u00f3 \u00e1talak\u00edt\u00e1s\u00e1hoz. Javasoltak \u00faj funkci\u00f3kat az adatok JSON form\u00e1tumban t\u00f6rt\u00e9n\u0151 l\u00e9trehoz\u00e1s\u00e1ra (JSON, JSON_SCALAR \u00e9s JSON_SERIALIZE) \u00e9s lek\u00e9rdez\u00e9s\u00e9re (JSON_EXISTS, JSON_QUERY \u00e9s JSON_VALUE).\n<li class=\"l\"> B\u0151v\u00fcltek az SQL 'MERGE' parancs lehet\u0151s\u00e9gei, amely lehet\u0151v\u00e9 teszi felt\u00e9teles SQL-kifejez\u00e9sek l\u00e9trehoz\u00e1s\u00e1t, amelyek egyes\u00edtik az INSERT, UPDATE \u00e9s DELETE m\u0171veleteket egy kifejez\u00e9sben. Hozz\u00e1adva lett a RETURNING kifejez\u00e9s t\u00e1mogat\u00e1sa, amely lehet\u0151v\u00e9 teszi a hozz\u00e1adott, friss\u00edtett vagy t\u00f6r\u00f6lt sorok alapj\u00e1n t\u00f6rt\u00e9n\u0151 \u00e9rt\u00e9kek kisz\u00e1m\u00edt\u00e1s\u00e1t \u00e9s visszaad\u00e1s\u00e1t. Megval\u00f3sult a n\u00e9zetek friss\u00edt\u00e9s\u00e9nek t\u00e1mogat\u00e1sa is.\n<li class=\"l\"> The capabilities for batch data loading and exporting have been expanded. The COPY command has seen its export speed for large rows doubled, copying has been optimized for matching source and target encodings, and an ON_ERROR option has been added, allowing import to continue after data insertion errors.\n<li class=\"l\"> A r\u00e9szletezett t\u00e1bl\u00e1khoz hozz\u00e1adva lett a lehet\u0151s\u00e9g, hogy egyedi azonos\u00edt\u00f3kkal rendelkez\u0151 oszlopokat haszn\u00e1ljanak, valamint a 'Constraint exclusion' lek\u00e9rdez\u00e9soptimaliz\u00e1l\u00f3 technika t\u00e1mogat\u00e1sa.\n<li class=\"l\"> The foreign table connection mechanism Foreign Data Wrapper (postgres_fdw) has implemented the ability to pass to external <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/hu\/server\/\"   title=\"szerver\" data-wpil-keyword-link=\"linked\">szerver<\/a> a 'EXISTS' \u00e9s 'IN' allek\u00e9rdez\u00e9sei.\n<li class=\"l\"> Megval\u00f3s\u00edtva lett egy be\u00e9p\u00edtett platformf\u00fcggetlen motor a 'Collation' helyi be\u00e1ll\u00edt\u00e1sok feldolgoz\u00e1s\u00e1ra, amelyeket a rendez\u00e9si szab\u00e1lyok \u00e9s a karakterek \u00f6sszehasonl\u00edt\u00e1si m\u00f3dszereinek meghat\u00e1roz\u00e1s\u00e1ra haszn\u00e1lnak (p\u00e9ld\u00e1ul a numerikus \u00e9rt\u00e9kek rendez\u00e9s\u00e9n\u00e9l figyelembe veszik a m\u00ednuszt \u00e9s a pontot a sz\u00e1m el\u0151tt, valamint a k\u00fcl\u00f6nb\u00f6z\u0151 \u00edr\u00e1sm\u00f3dokat, m\u00edg az \u00f6sszehasonl\u00edt\u00e1sn\u00e1l figyelmen k\u00edv\u00fcl hagyj\u00e1k a karakterek nagys\u00e1g\u00e1t \u00e9s a hangs\u00faly jel\u00e9t). Az \u00faj motor garant\u00e1lja az egys\u00e9ges viselked\u00e9st a lek\u00e9rdez\u00e9sek eredm\u00e9nyeinek rendez\u00e9s\u00e9n\u00e9l, f\u00fcggetlen\u00fcl att\u00f3l, hogy a PostgreSQL mely platformon fut.\n<li class=\"l\"> In the logical replication mechanism, allowing changes made to the database during record additions, deletions, or updates to be transmitted to another server, the process of updating the DBMS has been simplified. Previously, when transitioning to a new significant release, it was necessary to delete logical replication slots and resynchronize data, but now it can be done without deleting slots. For fault-tolerant configurations, the ability to manage failover switching to a standby server for logical replication has been implemented. A new utility pg_createsubscriber has been added to convert a physical replica into a new logical replica.\n<li class=\"l\"> \u00daj 'sslnegotiation' opci\u00f3 ker\u00fclt hozz\u00e1ad\u00e1sra a biztons\u00e1gos TLS-kapcsolatok k\u00f6zvetlen meg\u00e1llapod\u00e1s\u00e1hoz az ALPN TLS-kiterjeszt\u00e9s seg\u00edts\u00e9g\u00e9vel.\n<li class=\"l\"> Megval\u00f3sult a pg_maintain el\u0151re defini\u00e1lt szerepk\u00f6r, amely jogot biztos\u00edt a felhaszn\u00e1l\u00f3nak az adatb\u00e1zis-kezel\u0151 rendszert \u00e9rint\u0151 karbantart\u00e1si m\u0171veletek v\u00e9grehajt\u00e1s\u00e1ra.\n<li class=\"l\"> A pg_basebackup eszk\u00f6zbe, amelyet az adatb\u00e1zis biztons\u00e1gi ment\u00e9seinek l\u00e9trehoz\u00e1s\u00e1ra haszn\u00e1lnak, hozz\u00e1adva lett az inkrement\u00e1lis biztons\u00e1gi m\u00e1solatok t\u00e1mogat\u00e1sa. A teljes biztons\u00e1gi m\u00e1solat rekonstru\u00e1l\u00e1s\u00e1ra az inkrement\u00e1lis m\u00e1solatokb\u00f3l egy \u00faj eszk\u00f6zt, a pg_combinebackup-ot javasolj\u00e1k. A pg_dump eszk\u00f6zh\u00f6z hozz\u00e1adva lett a '--filter' opci\u00f3, amely lehet\u0151v\u00e9 teszi a dump-ba bevont objektumok kiv\u00e1laszt\u00e1s\u00e1t.\n<li class=\"l\"> Az SQL parancs &#171;EXPLAIN&#187; haszn\u00e1lat\u00e1val v\u00e9gzett lek\u00e9rdez\u00e9sek elemz\u00e9sekor megjelenik az olvas\u00e1sra \u00e9s \u00edr\u00e1sra ford\u00edtott id\u0151, a helyi blokkok eset\u00e9n az input\/output sor\u00e1n. Az &#171;EXPLAIN&#187; parancshoz k\u00e9t \u00faj opci\u00f3 &#171;MEMORY&#187; \u00e9s &#171;SERIALIZE&#187; ker\u00fclt hozz\u00e1ad\u00e1sra, amelyek seg\u00edts\u00e9g\u00e9vel meghat\u00e1rozhat\u00f3 a felhaszn\u00e1lt mem\u00f3ria m\u00e9rete \u00e9s az adatok h\u00e1l\u00f3zaton val\u00f3 \u00e1tvitelhez sz\u00fcks\u00e9ges \u00e1talak\u00edt\u00e1s ideje.\n<li class=\"l\"> A VACUUM m\u0171velet v\u00e9grehajt\u00e1sa sor\u00e1n biztos\u00edtott a folyamat el\u0151rehalad\u00e1s\u00e1nak jelz\u00e9se az indexekkel.\n<li class=\"l\"> Hozz\u00e1ad\u00e1sra ker\u00fclt a pg_wait_events rendszerk\u00e9p, amely a pg_stat_activity k\u00e9ppel egy\u00fctt lehet\u0151v\u00e9 teszi az akt\u00edv munkamenetek v\u00e1rakoz\u00e1s\u00e1nak okainak r\u00e9szletesebb vizsg\u00e1lat\u00e1t.      <\/ul>\n<p>Forr\u00e1s: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=61935\">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 17. \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 2029 \u0433\u043e\u0434\u0430. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 PostgreSQL 12.x, \u0441\u0430\u043c\u043e\u0439 \u0441\u0442\u0430\u0440\u043e\u0439 \u0438\u0437 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a, \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430 14 \u043d\u043e\u044f\u0431\u0440\u044f. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043d\u043e\u0432\u0448\u0435\u0441\u0442\u0432\u0430: \u041f\u0440\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 VACUUM (\u0441\u0431\u043e\u0440\u043a\u0430 \u043c\u0443\u0441\u043e\u0440\u0430, \u0447\u0438\u0441\u0442\u043a\u0430 \u0438 \u0443\u043f\u0430\u043a\u043e\u0432\u043a\u0430 \u0434\u0438\u0441\u043a\u043e\u0432\u043e\u0433\u043e \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430) \u0437\u0430\u0434\u0435\u0439\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u044f\u044e\u0449\u0430\u044f \u0434\u043e [&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-119954","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - 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 17. \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 2029 \u0433\u043e\u0434\u0430.\" \/>\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\/hu\/blog\/news\/reliz-subd-postgresql-17\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\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 17 | 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 17. \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 2029 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-postgresql-17\" \/>\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=\"2024-09-26T19:43:01+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-09-26T19:43:01+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 17 kiad\u00e1s | ProHoster","description":"Egy \u00e9v fejleszt\u00e9s ut\u00e1n megjelent a PostgreSQL 17 \u00faj stabil adatb\u00e1zis-kezel\u0151 \u00e1g. Az \u00faj \u00e1ghoz k\u00e9sz\u00fclt friss\u00edt\u00e9sek \u00f6t \u00e9vig, 2029 november\u00e9ig fognak megjelenni.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-postgresql-17","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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 17 | 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 17. \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 2029 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-postgresql-17","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":"2024-09-26T19:43:01+00:00","article:modified_time":"2024-09-26T19:43:01+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"119954","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":"default","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 06:51:33","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 06:51:33","updated":"2026-01-23 06:51:33","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/119954","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=119954"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/119954\/revisions"}],"predecessor-version":[{"id":173068,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/119954\/revisions\/173068"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=119954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=119954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=119954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}