{"id":36583,"date":"2025-09-26T15:45:56","date_gmt":"2025-09-26T12:45:56","guid":{"rendered":"https:\/\/profelis.com.tr\/?p=36583"},"modified":"2026-06-18T21:41:32","modified_gmt":"2026-06-18T18:41:32","slug":"postgresql-18-yayimlandi","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2025\/09\/26\/postgresql-18-yayimlandi\/","title":{"rendered":"PostgreSQL 18 Yay\u0131mland\u0131!"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"36583\" class=\"elementor elementor-36583\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e55eabc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e55eabc\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a593569\" data-id=\"a593569\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-72445aa elementor-widget elementor-widget-text-editor\" data-id=\"72445aa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Versiyon \u00e7\u0131k\u0131\u015f tarihi:<\/strong><span style=\"font-weight: 400;\"> 25 Eyl\u00fcl 2025<\/span><\/p><p><span style=\"font-weight: 400;\">PostgreSQL Global Development Group, d\u00fcnyan\u0131n en geli\u015fmi\u015f a\u00e7\u0131k kaynak veritaban\u0131 olan PostgreSQL\u2019in en son s\u00fcr\u00fcm\u00fc <\/span><b>PostgreSQL 18<\/b><span style=\"font-weight: 400;\">\u2019i yay\u0131nlad\u0131.<\/span><\/p><p><span style=\"font-weight: 400;\">Bu s\u00fcr\u00fcm, <\/span><b>t\u00fcm \u00f6l\u00e7eklerde i\u015f y\u00fckleri i\u00e7in performans art\u0131\u015f\u0131<\/b><span style=\"font-weight: 400;\"> sa\u011flayan yeni <\/span><b>asenkron I\/O (AIO) altyap\u0131s\u0131<\/b><span style=\"font-weight: 400;\">, daha h\u0131zl\u0131 ve daha \u00f6ng\u00f6r\u00fclebilir <\/span><b>b\u00fcy\u00fck s\u00fcr\u00fcm y\u00fckseltmeleri<\/b><span style=\"font-weight: 400;\">, sorgular i\u00e7in <\/span><b>indeks kullan\u0131m\u0131nda iyile\u015ftirmeler<\/b><span style=\"font-weight: 400;\">, geli\u015ftiriciler i\u00e7in <\/span><b>virtual generated columns<\/b><span style=\"font-weight: 400;\"> ve <\/span><b>uuidv7()<\/b><span style=\"font-weight: 400;\"> fonksiyonu gibi yenilikler getiriyor. Ayr\u0131ca, <\/span><b>OAuth 2.0 kimlik do\u011frulama deste\u011fi<\/b><span style=\"font-weight: 400;\"> sayesinde modern SSO sistemleriyle entegrasyon kolayla\u015f\u0131yor.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48b6085 elementor-widget elementor-widget-heading\" data-id=\"48b6085\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u00d6ne \u00c7\u0131kan Yenilikler<\/h2>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7e00af5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e00af5\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-717b4ba\" data-id=\"717b4ba\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-17f9992 elementor-widget elementor-widget-text-editor\" data-id=\"17f9992\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Asenkron I\/O (AIO):<\/b><span style=\"font-weight: 400;\"> S\u0131ral\u0131 tarama (seqscan) , bitmap heap tarama, VACUUM ve di\u011fer operasyonlarda performans iyile\u015ftirmesi<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Major G\u00fcncelleme:<\/b> <b>pg_upgrade<\/b><span style=\"font-weight: 400;\"> ile art\u0131k istatistikler de ta\u015f\u0131n\u0131yor,<\/span><b>&#8211;swap<\/b><span style=\"font-weight: 400;\"> ile dizin de\u011fi\u015ftirilebiliyor.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Sorgu performans\u0131:<\/b><span style=\"font-weight: 400;\"> Skip scan, OR ko\u015fullar\u0131nda indeks kullan\u0131m\u0131, join optimizasyonlar\u0131.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Geli\u015ftirici deneyimi:<\/b><span style=\"font-weight: 400;\"> Yeni virtual generated column \u00f6zelli\u011fi, UUIDV7 veri tipi, RETURNING i\u00e7in OLD\/NEW de\u011ferleri, zaman aral\u0131\u011f\u0131 bazl\u0131 temporal constraints k\u0131s\u0131tlamalar\u0131<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Metin i\u015fleme:<\/b><span style=\"font-weight: 400;\"> PG_UNICODE_FAST collation, casefold() fonksiyonu, LIKE ile nondeterministic collation deste\u011fi.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kimlik do\u011frulama:<\/b><span style=\"font-weight: 400;\"> OAuth 2.0 Standard\u0131, md5 deste\u011fi gelecek s\u00fcr\u00fcmlerde kald\u0131r\u0131l\u0131yor.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Replikasyon:<\/b><span style=\"font-weight: 400;\"> Mant\u0131ksal replikasyonda Query Conflicts log \u00f6zelli\u011fi, CREATE SUBSCRIPTION varsay\u0131lan PARALLEL mod, replication slot y\u00f6netimi.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Bak\u0131m &amp; g\u00f6zlemlenebilirlik:<\/b><span style=\"font-weight: 400;\"> VACUUM optimizasyonlar\u0131, EXPLAIN ANALYZE i\u00e7inde daha ayr\u0131nt\u0131l\u0131 istatistikler, yeni <\/span><span style=\"font-weight: 400;\">pg_stat_*<\/span><span style=\"font-weight: 400;\"> metrikleri.<\/span><\/li><li aria-level=\"1\"><b>Varsay\u0131lanlar:<\/b> <span style=\"font-weight: 400;\">initdb<\/span><span style=\"font-weight: 400;\"> art\u0131k checksum varsay\u0131lan a\u00e7\u0131k, yeni wire protocol v3.2.<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-65b86f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65b86f8\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d0e17d7\" data-id=\"d0e17d7\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-309f7ec elementor-widget elementor-widget-image\" data-id=\"309f7ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"640\" height=\"366\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/09\/postgres18-2-1024x585.jpeg\" class=\"attachment-large size-large wp-image-36587\" alt=\"\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/09\/postgres18-2-1024x585.jpeg 1024w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/09\/postgres18-2-300x171.jpeg 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/09\/postgres18-2-768x439.jpeg 768w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/09\/postgres18-2.jpeg 1344w\" sizes=\"(max-width: 640px) 100vw, 640px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-711275d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"711275d\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-86cb8a8\" data-id=\"86cb8a8\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-358cde2 elementor-widget elementor-widget-text-editor\" data-id=\"358cde2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><b>Detayl\u0131 s\u00fcr\u00fcm notlar\u0131 i\u00e7in<\/b><span style=\"font-weight: 400;\"> \ud83d\udc49<\/span><a href=\"https:\/\/www.postgresql.org\/docs\/release\/18.0\/\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">PostgreSQL 18 Release Notes<\/span><\/a><\/p><h3><span style=\"font-weight: 400;\">PostgreSQL 18\u2019e Ge\u00e7meye Haz\u0131r m\u0131s\u0131n\u0131z?<\/span><\/h3><p><span style=\"font-weight: 400;\">Profelis olarak PostgreSQL ekosisteminde uzun y\u0131llard\u0131r edindi\u011fimiz deneyimle kurumlar\u0131n PostgreSQL ge\u00e7i\u015f, bak\u0131m ve optimizasyon s\u00fcre\u00e7lerinde yan\u0131nday\u0131z.<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Y\u00fckseltme s\u00fcrecini planlama,<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Yeni \u00f6zelliklerin mevcut i\u015f y\u00fcklerine etkisini analiz etme,<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Performans ve g\u00fcvenilirli\u011fi maksimize etme,<\/span><\/li><\/ul><p><span style=\"font-weight: 400;\">gibi ad\u0131mlarda uzman ekibimizle yol haritan\u0131z\u0131 birlikte olu\u015ftural\u0131m.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Daha fazla bilgi i\u00e7in \ud83d\udc49<\/span><a href=\"https:\/\/profelis.com.tr\/en\/postgresql-operasyon-merkezi\/\"> <span style=\"font-weight: 400;\">PostgreSQL Operations Center<\/span><\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>PostgreSQL Global Development Group, d\u00fcnyan\u0131n en geli\u015fmi\u015f a\u00e7\u0131k kaynak veritaban\u0131 olan PostgreSQL\u2019in en son s\u00fcr\u00fcm\u00fc PostgreSQL 18\u2019i yay\u0131nlad\u0131.<\/p>","protected":false},"author":5,"featured_media":36586,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,44],"tags":[60],"class_list":["post-36583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-duyuru","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/36583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=36583"}],"version-history":[{"count":15,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/36583\/revisions"}],"predecessor-version":[{"id":38991,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/36583\/revisions\/38991"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/36586"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=36583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=36583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=36583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}