{"id":28908,"date":"2024-12-03T15:26:54","date_gmt":"2024-12-03T12:26:54","guid":{"rendered":"https:\/\/profelis.com.tr\/?p=28908"},"modified":"2025-07-23T15:09:45","modified_gmt":"2025-07-23T12:09:45","slug":"postgresql-17-yayinlandi-sizi-neler-bekliyor","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2024\/12\/03\/postgresql-17-yayinlandi-sizi-neler-bekliyor\/","title":{"rendered":"PostgreSQL 17 Yay\u0131nland\u0131: Sizi Neler Bekliyor?"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"28908\" class=\"elementor elementor-28908\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6bfecef3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6bfecef3\" 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-1c2ec46f\" data-id=\"1c2ec46f\" 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-d6b70d7 elementor-widget elementor-widget-text-editor\" data-id=\"d6b70d7\" 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><a href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">PostgreSQL K\u00fcresel Geli\u015ftirme Grubu<\/span><\/a><span style=\"font-weight: 400;\"> ge\u00e7ti\u011fimiz g\u00fcnlerde d\u00fcnyan\u0131n en geli\u015fmi\u015f a\u00e7\u0131k kaynak veri taban\u0131n\u0131n en son s\u00fcr\u00fcm\u00fc olan PostgreSQL 17&#8217;nin yay\u0131nland\u0131\u011f\u0131n\u0131 duyurdu.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">PostgreSQL g\u00fcncel major s\u00fcr\u00fcmde kullanman\u0131z, yaln\u0131zca g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131 gidermekle kalmaz, ayn\u0131 zamanda sorgu h\u0131z\u0131, veri i\u015fleme verimlili\u011fi ve bellek y\u00f6netimi gibi kritik alanlarda yap\u0131lan optimizasyonlar ile kurumsal veri y\u00f6netim s\u00fcre\u00e7lerinizi destekler.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">PostgreSQL 17 u\u00e7tan uca performans iyile\u015ftirmeleri i\u00e7eriyor; vacuum i\u015fleminde haf\u0131za kullan\u0131m\u0131n\u0131n revizyonu, veri deposu eri\u015fimi ve e\u015fzamanl\u0131 a\u011f\u0131r y\u00fck talepleri i\u00e7in iyile\u015ftirmeler, bulk loading ve export i\u015flemlerinin h\u0131zland\u0131r\u0131lmas\u0131, indeks sorgular\u0131ndaki iyile\u015ftirmeler gibi \u00f6zellikler \u00f6ne \u00e7\u0131k\u0131yor.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">PostgreSQL 17 ile yeni i\u015f y\u00fckleri ve kritik sistemler daha iyi destekleniyor. SQL\/JSON JSON_TABLE komutunun kullan\u0131m\u0131 sayesinde uygulama geli\u015ftirme olanaklar\u0131 daha kapsaml\u0131 hale geliyor. Mant\u0131ksal replikasyon ile ilgili geli\u015fmeler sayesinde ise, y\u00fcksek eri\u015filebilirlik ve maj\u00f6r s\u00fcr\u00fcm y\u00fckseltme operasyonlar\u0131 daha basit yap\u0131labiliyor.<\/span><\/p>\n<p><!-- \/wp:paragraph --><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d78ac78 elementor-widget elementor-widget-heading\" data-id=\"d78ac78\" 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\">Sistem Genelini Etkileyen Performans \u0130yile\u015ftirmeleri<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d8ae2ed elementor-widget elementor-widget-text-editor\" data-id=\"d8ae2ed\" 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>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">E\u015fzamanl\u0131 a\u011f\u0131r y\u00fck alt\u0131nda write-ahead-log (WAL)\u00a0 i\u015flemlerinde 2x misline varan performans art\u0131\u015f\u0131 sa\u011flan\u0131yor<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">Yeni streaming I\/O \u00f6zellikleri sayesinde s\u0131ral\u0131 tarama i\u015flemleri (sequential scan, bir tablodaki t\u00fcm kay\u0131tlar\u0131n okunmas\u0131) h\u0131zlan\u0131yor, ANALYZE komutu taraf\u0131ndan yap\u0131lan sorgu plan\u0131 g\u00fcncellemeleri daha k\u0131sa s\u00fcrede tamamlan\u0131yor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">Varsay\u0131lan indeksleme y\u00f6ntemi olan B-tree indekslerini kullanan ve IN terimini i\u00e7eren sorgular\u0131n performans\u0131 art\u0131yor. Ek olarak, BRIN indekslerinin olu\u015fturulmas\u0131 paralel olarak ger\u00e7ekle\u015ftiriliyor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">Sorgularda NOT NULL constraint veya common-table-expression (CTE)\u00a0 WITH kullan\u0131l\u0131yorsa, ilgili planlarda optimizasyonlar sa\u011flan\u0131yor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">128bit\/256bit olan CPU vector i\u015flem b\u00fcy\u00fckl\u00fc\u011f\u00fc 512bit oluyor (AVX-512). Ek olarak daha fazla Single Instruction \/ Multiple Data (SIMD) deste\u011finden yararlan\u0131l\u0131yor.<\/span><\/p>\n<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bcb49ab elementor-widget elementor-widget-image\" data-id=\"bcb49ab\" 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\/2024\/12\/postgres-gorsel-1-1024x585.png\" class=\"attachment-large size-large wp-image-28919\" alt=\"\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-1-1024x585.png 1024w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-1-300x171.png 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-1-768x439.png 768w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-1-1536x878.png 1536w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-1.png 1792w\" 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<div class=\"elementor-element elementor-element-01c5fe1 elementor-widget elementor-widget-heading\" data-id=\"01c5fe1\" 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\">Uygulama Geli\u015ftirme Tecr\u00fcbesinin Sa\u011flamla\u015ft\u0131r\u0131lmas\u0131, Geli\u015ftiri\u00e7i Deneyimin Daha da Geni\u015fletilmesi<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-119e289a elementor-widget elementor-widget-text-editor\" data-id=\"119e289a\" 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>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">JSON deste\u011fi PostgreSQL \u00f6zelliklerine 2012 y\u0131l\u0131nda dahil olmu\u015ftu. PostgreSQL 17 ile birlikte gelen JSON_TABLE \u00f6zelli\u011fi, JSON verilerinin standart PostgreSQL tablosuna \u00e7evrilmesini sa\u011fl\u0131yor. JSON_EXISTS, JSON_QUERY, JSON_VALUE sorgular\u0131 yap\u0131labiliyor, verinin jsonpath terimleri kullan\u0131larak PostgreSQL veri tiplerine d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesi kolayla\u015f\u0131yor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">COPY komutuyla b\u00fcy\u00fck boyutlu sat\u0131rlar\u0131n i\u015flenmesinde 2x misline varan performans iyile\u015ftirmesi sa\u011flan\u0131yor. COPY komutuna eklenen ON_ERROR\u00a0 se\u00e7ene\u011fi sayesinde insert i\u015fleminde hata al\u0131nsa bile devam etmesi m\u00fcmk\u00fcn oluyor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">Partition tablolarda identity kolon ve exclusion constraints tan\u0131mlanmas\u0131 yap\u0131labiliyor. Postgres_fdw ilede art\u0131k EXISTS ve IN alt sorgular\u0131 uzak sunucularda y\u00fcr\u00fct\u00fclmesi m\u00fcmk\u00fcn oluyor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">PostgreSQL 17 ile birlikte, platform ba\u011f\u0131ms\u0131z ve entegre \u00f6zellik olarak \u00e7al\u0131\u015fan UTF-8 encoding \u00f6zelli\u011fi bulunuyor.\u00a0 Bu \u00f6zellik sayesinde metin bazl\u0131 sorgular\u0131n sonu\u00e7lar\u0131, t\u00fcm ortamlarda (collation \u00f6zelli\u011fi ne olursa olsun) ayn\u0131 s\u0131ralamada elde ediliyor.<\/span><\/p>\n<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7890aa6 elementor-widget elementor-widget-heading\" data-id=\"7890aa6\" 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\">Y\u00fcksek Eri\u015filebilirlik ve Major S\u00fcr\u00fcm Y\u00fckseltmeleri i\u00e7in Mant\u0131ksal Replikasyon \u0130yile\u015ftirmeleri<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-999ab52 elementor-widget elementor-widget-text-editor\" data-id=\"999ab52\" 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>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">G\u00fcncel s\u00fcr\u00fcm \u00f6ncesinde yap\u0131lan major s\u00fcr\u00fcm y\u00fckseltmelerinde, yeni s\u00fcr\u00fcme ge\u00e7ilmesi s\u0131ras\u0131nda mant\u0131ksal replikasyon i\u00e7in kullan\u0131lan slotlar d\u00fc\u015f\u00fcyor ve Mant\u0131ksal replikasyonun veriyi tekrar senkronize etmesi gerekiyordu. PostgreSQL 17 ve daha yeni s\u00fcr\u00fcmlerde, mant\u0131ksal replikasyon i\u00e7in kullan\u0131lan slotlar d\u00fc\u015fmedi\u011fi i\u00e7in, s\u00fcr\u00fcm y\u00fckseltme i\u015flemleri \u00e7ok daha basit\u00e7e yap\u0131lmas\u0131 m\u00fcmk\u00fcn olacak.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">PostgreSQL 17 mant\u0131ksal replikasyon y\u00fck devretme (failover) \u00f6zellikleri sayesinde, y\u00fcksek eri\u015filirlik ortamlar\u0131nda failover sonras\u0131 mant\u0131ksal replikasyonda kesinti olmamas\u0131 m\u00fcmk\u00fcn k\u0131l\u0131nd\u0131.. Ayr\u0131ca, fiziksel replikan\u0131n mant\u0131ksal replikaya \u00e7evrilmesi i\u00e7in yeni komut sat\u0131r\u0131 uygulamas\u0131 (pg_createsubscriber) sunuluyor.<\/span><\/p>\n<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc2543c elementor-widget elementor-widget-image\" data-id=\"dc2543c\" 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 decoding=\"async\" width=\"640\" height=\"366\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-2-1024x585.png\" class=\"attachment-large size-large wp-image-28918\" alt=\"\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-2-1024x585.png 1024w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-2-300x171.png 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-2-768x439.png 768w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-2-1536x878.png 1536w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2024\/12\/postgres-gorsel-2.png 1792w\" 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<div class=\"elementor-element elementor-element-0c15ff5 elementor-widget elementor-widget-heading\" data-id=\"0c15ff5\" 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\">G\u00fcvenlik ve Sistem Y\u00f6netimi i\u00e7in Daha Fazla Se\u00e7enek<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ea86ca elementor-widget elementor-widget-text-editor\" data-id=\"1ea86ca\" 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>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">PostgreSQL 17 varsay\u0131lan rol tan\u0131mlar\u0131nda yeni olarak pg_maintain rol\u00fc geliyor,\u00a0 sistem bak\u0131m\u0131 yapan son kullan\u0131c\u0131lar kolayca yetkilendiriliyor.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">PostgreSQL bulunan pg_basebackup art\u0131k art\u0131ml\u0131 yedeklemeleri destekliyor ve fullbackup bu art\u0131ml\u0131 yedekler ile yeniden olu\u015fturmak i\u00e7in pg_combinebackup yard\u0131mc\u0131 program\u0131n\u0131 ekliyor.B\u00f6ylelikle fullbackup tekrardan almadan varolan fullbackup g\u00fcncel tarihe yakla\u015ft\u0131rabiliriyor. Ek olarak pg_dump arac\u0131na eklenen yeni &#8211;filter se\u00e7ene\u011fi sayesinde, dump dosyas\u0131n\u0131n hangi nesneleri kapsayaca\u011f\u0131 se\u00e7ilebiliyor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">PostgreSQL 17, sistem izleme ve analizi i\u00e7in geli\u015fmeleri bar\u0131nd\u0131r\u0131yor. EXPLAIN komutunda\u00a0 I\/O block okuma ve yazma s\u00fcreleri de g\u00f6steriliyor ve iki se\u00e7enek sunuluyor: SERIALIZE, MEMORY, bu sayede ileti\u015fim altyap\u0131s\u0131nda ge\u00e7en s\u00fcre ve haf\u0131za kullan\u0131m\u0131 detaylar\u0131 g\u00f6r\u00fclebiliyor.<\/span><\/p>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<p><span style=\"font-weight: 400;\">Indeks vacuum i\u015flemlerinin ilerlemesi raporlanabiliyor. Bekleme sorunu ya\u015fayan veritaban\u0131 ba\u011flant\u0131lar\u0131n incelenmesi i\u00e7in yeni gelen pg_wait_events ve pg_stat_activity kullan\u0131larak daha detayl\u0131 bilgi elde ediliyor.<\/span><\/p>\n<\/li>\n<\/ul>\n<p>Daha fazla bilgi i\u00e7in:\u00a0<a href=\"https:\/\/www.postgresql.org\/about\/news\/postgresql-17-released-2936\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/www.postgresql.org\/about\/news\/postgresql-17-released-2936\/<\/span><\/a>v<\/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 17, geli\u015ftirilmi\u015f VACUUM bellek y\u00f6netimi, y\u00fcksek performans, SQL\/JSON JSON_TABLE, mant\u0131ksal replikasyon iyile\u015ftirmeleri ve g\u00fcvenlik gibi \u00f6nemli yeniliklerle veritaban\u0131 deneyimini \u00f6nemli \u00f6l\u00e7\u00fcde g\u00fc\u00e7lendiriyor.<\/p>","protected":false},"author":16,"featured_media":28936,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75],"tags":[],"class_list":["post-28908","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/28908","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\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=28908"}],"version-history":[{"count":22,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/28908\/revisions"}],"predecessor-version":[{"id":35617,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/28908\/revisions\/35617"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/28936"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=28908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=28908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=28908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}