{"id":25416,"date":"2025-07-06T03:15:24","date_gmt":"2025-07-06T00:15:24","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/"},"modified":"2025-07-06T03:15:24","modified_gmt":"2025-07-06T00:15:24","slug":"postgresqlde-agirlikli-ortalama-nasil-hesaplanir","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/","title":{"rendered":"PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r"},"content":{"rendered":"<p># PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r?<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda farkl\u0131 \u00f6neme sahip verileriniz mi var? \u00d6rne\u011fin, \u00f6\u011frencilerin farkl\u0131 a\u011f\u0131rl\u0131kl\u0131 \u00f6devlerden ald\u0131klar\u0131 notlar\u0131 m\u0131 de\u011ferlendirmeniz gerekiyor? Ya da bir \u00fcr\u00fcn\u00fcn farkl\u0131 ma\u011fazalardaki sat\u0131\u015f fiyatlar\u0131n\u0131 ortalamalarken, her ma\u011fazan\u0131n sat\u0131\u015f hacmini de hesaba katman\u0131z m\u0131 laz\u0131m?  Bu gibi durumlarda standart ortalama hesaplamas\u0131 yeterli olmayabilir.  \u0130\u015fte bu noktada <strong>a\u011f\u0131rl\u0131kl\u0131 ortalama<\/strong> devreye giriyor. Bu makalede, PostgreSQL kullanarak a\u011f\u0131rl\u0131kl\u0131 ortalama hesaplaman\u0131n inceliklerini, ad\u0131m ad\u0131m bir rehberle ve ger\u00e7ek d\u00fcnya \u00f6rnekleriyle ele alaca\u011f\u0131z.  A\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 anlamak ve PostgreSQL&#8217;de verimli bir \u015fekilde uygulamak i\u00e7in ihtiyac\u0131n\u0131z olan her \u015feyi bu makalede bulacaks\u0131n\u0131z.<\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131<\/strong><\/p>\n<p>Bu makale, a\u011f\u0131rl\u0131kl\u0131 ortalama hesaplamay\u0131 PostgreSQL&#8217;de \u00f6\u011frenmek i\u00e7in \u00fc\u00e7 seviyeden olu\u015fan bir yol haritas\u0131 sunar:<\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong> Ad\u0131m ad\u0131m a\u00e7\u0131klama, basit kod \u00f6rne\u011fi.<\/p>\n<p><strong>Orta Seviye:<\/strong> Ger\u00e7ek hayat \u00f6rne\u011fi, optimizasyon ipu\u00e7lar\u0131.<\/p>\n<p><strong>\u0130leri Seviye:<\/strong> Performans analizi, edge case&#8217;ler (kenar durumlar\u0131).<\/p>\n<p><strong>Temel Kavramlar: A\u011f\u0131rl\u0131kl\u0131 Ortalama Nedir?<\/strong><\/p>\n<p>A\u011f\u0131rl\u0131kl\u0131 ortalama, her veri noktas\u0131na farkl\u0131 bir a\u011f\u0131rl\u0131k vererek hesaplanan bir ortalama t\u00fcr\u00fcd\u00fcr.  Standart ortalama, t\u00fcm veri noktalar\u0131na e\u015fit a\u011f\u0131rl\u0131k verirken, a\u011f\u0131rl\u0131kl\u0131 ortalama, baz\u0131 veri noktalar\u0131n\u0131n di\u011ferlerinden daha \u00f6nemli oldu\u011funu kabul eder.  Form\u00fcl \u015fu \u015fekildedir:<\/p>\n<p><code class=\"language-\">A\u011f\u0131rl\u0131kl\u0131 Ortalama = (\u2211(x\u1d62 * w\u1d62)) \/ \u2211w\u1d62<\/code><\/p>\n<p>Burada:<\/p>\n<p>* <code class=\"language-\">x\u1d62<\/code>: i. veri noktas\u0131<br \/>\n* <code class=\"language-\">w\u1d62<\/code>: i. veri noktas\u0131n\u0131n a\u011f\u0131rl\u0131\u011f\u0131<br \/>\n* <code class=\"language-\">\u2211<\/code>: toplam\u0131 g\u00f6sterir.<\/p>\n<p>\u00d6rne\u011fin, bir \u00f6\u011frencinin \u00fc\u00e7 s\u0131navdan ald\u0131\u011f\u0131 notlar ve s\u0131navlar\u0131n a\u011f\u0131rl\u0131klar\u0131 \u015f\u00f6yle olsun:<\/p>\n<p>* S\u0131nav 1: Not: 80, A\u011f\u0131rl\u0131k: 0.2<br \/>\n* S\u0131nav 2: Not: 90, A\u011f\u0131rl\u0131k: 0.3<br \/>\n* S\u0131nav 3: Not: 70, A\u011f\u0131rl\u0131k: 0.5<\/p>\n<p>A\u011f\u0131rl\u0131kl\u0131 ortalama: <code class=\"language-\">(80 * 0.2) + (90 * 0.3) + (70 * 0.5) = 79<\/code> olur.<\/p>\n<p><strong>PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r? (Yeni Ba\u015flayanlar \u0130\u00e7in)<\/strong><\/p>\n<p>Basit bir \u00f6rnek ile ba\u015flayal\u0131m.  \u00d6\u011frenci notlar\u0131 ve s\u0131nav a\u011f\u0131rl\u0131klar\u0131n\u0131 i\u00e7eren bir tablo olu\u015ftural\u0131m:<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE ogrenci_notlari (\n    ogrenci_id INT,\n    sinav_adi TEXT,\n    not INT,\n    agirlik REAL\n);\n\nINSERT INTO ogrenci_notlari (ogrenci_id, sinav_adi, not, agirlik) VALUES\n(1, 'Vize', 70, 0.4),\n(1, 'Final', 85, 0.6),\n(2, 'Vize', 90, 0.4),\n(2, 'Final', 75, 0.6);<\/code><\/pre>\n<p>\u015eimdi, her \u00f6\u011frencinin a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131n\u0131 hesaplayal\u0131m:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    ogrenci_id,\n    SUM(not * agirlik) \/ SUM(agirlik) AS agirlikli_ortalama\nFROM\n    ogrenci_notlari\nGROUP BY\n    ogrenci_id;<\/code><\/pre>\n<p>Bu sorgu, her \u00f6\u011frenci i\u00e7in <code class=\"language-\">not<\/code> ve <code class=\"language-\">agirlik<\/code> de\u011ferlerini \u00e7arpar, bunlar\u0131n toplam\u0131n\u0131 al\u0131r ve sonra t\u00fcm a\u011f\u0131rl\u0131klar\u0131n toplam\u0131na b\u00f6ler.  Sonu\u00e7 olarak, her \u00f6\u011frencinin a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131n\u0131 elde ederiz.<\/p>\n<p><strong>Ger\u00e7ek Hayat \u00d6rne\u011fi: \u00dcr\u00fcn Fiyatlar\u0131n\u0131n A\u011f\u0131rl\u0131kl\u0131 Ortalamas\u0131 (Orta Seviye)<\/strong><\/p>\n<p>Bir e-ticaret platformunda, ayn\u0131 \u00fcr\u00fcn\u00fcn farkl\u0131 sat\u0131c\u0131lardan farkl\u0131 fiyatlarla sat\u0131ld\u0131\u011f\u0131n\u0131 d\u00fc\u015f\u00fcnelim.  Her sat\u0131c\u0131n\u0131n sat\u0131\u015f hacmini de bildi\u011fimize g\u00f6re, \u00fcr\u00fcn\u00fcn a\u011f\u0131rl\u0131kl\u0131 ortalama fiyat\u0131n\u0131 hesaplayabiliriz.<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE urun_fiyatlari (\n    urun_id INT,\n    satici_adi TEXT,\n    fiyat NUMERIC,\n    satis_hacim INT\n);\n\nINSERT INTO urun_fiyatlari (urun_id, satici_adi, fiyat, satis_hacim) VALUES\n(1, 'SaticiA', 100, 100),\n(1, 'SaticiB', 120, 50),\n(1, 'SaticiC', 90, 150);<\/code><\/pre>\n<p>A\u011f\u0131rl\u0131kl\u0131 ortalama fiyat\u0131 hesaplamak i\u00e7in \u015fu sorguyu kullanabiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    urun_id,\n    SUM(fiyat * satis_hacim)::NUMERIC \/ SUM(satis_hacim) AS agirlikli_ortalama_fiyat\nFROM\n    urun_fiyatlari\nGROUP BY\n    urun_id;<\/code><\/pre>\n<p>Burada <code class=\"language-\">::NUMERIC<\/code> casting&#8217;i, olas\u0131 b\u00f6lme i\u015flemi hatalar\u0131n\u0131 \u00f6nlemek i\u00e7in kullan\u0131l\u0131r.  <code class=\"language-\">satis_hacim<\/code> de\u011ferleri a\u011f\u0131rl\u0131k olarak kullan\u0131l\u0131r.<\/p>\n<p><strong>Performans Optimizasyonu \u0130pu\u00e7lar\u0131 (Orta Seviye)<\/strong><\/p>\n<p>B\u00fcy\u00fck veri setlerinde performans\u0131 iyile\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki ipu\u00e7lar\u0131n\u0131 kullanabilirsiniz:<\/p>\n<p>* <strong>\u0130ndexler:<\/strong> <code class=\"language-\">ogrenci_id<\/code> ve <code class=\"language-\">urun_id<\/code> gibi s\u0131k kullan\u0131lan s\u00fctunlara index eklemek sorgu performans\u0131n\u0131 art\u0131r\u0131r.<br \/>\n* <strong>View&#8217;ler:<\/strong> Karma\u015f\u0131k sorguyu bir view olarak tan\u0131mlayarak tekrar kullan\u0131labilirlik ve performans kazanc\u0131 sa\u011flayabilirsiniz.<br \/>\n* <strong>Analiz:<\/strong> <code class=\"language-\">ANALYZE urun_fiyatlari;<\/code> komutu ile veritaban\u0131 istatistiklerini g\u00fcncelleyerek sorgu planlay\u0131c\u0131s\u0131n\u0131n daha iyi kararlar vermesini sa\u011flayabilirsiniz.<\/p>\n<p><strong>PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalaman\u0131n \u0130leri D\u00fczey Teknikleri (\u0130leri Seviye)<\/strong><\/p>\n<p>Daha karma\u015f\u0131k senaryolar i\u00e7in, pencere fonksiyonlar\u0131 ve ortak tablo ifadeleri (CTE&#8217;ler) kullanabiliriz. \u00d6rne\u011fin, her \u00f6\u011frencinin s\u0131n\u0131f\u0131ndaki s\u0131ras\u0131n\u0131 da hesaba katarak a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131n\u0131 hesaplayabiliriz:<\/p>\n<pre class=\"language-sql\"><code>WITH OgrenciNotlariAgirlikli AS (\n    SELECT\n        ogrenci_id,\n        SUM(not * agirlik) \/ SUM(agirlik) AS agirlikli_ortalama\n    FROM\n        ogrenci_notlari\n    GROUP BY\n        ogrenci_id\n),\nSinifSiralamasi AS (\n    SELECT\n        ogrenci_id,\n        agirlikli_ortalama,\n        RANK() OVER (ORDER BY agirlikli_ortalama DESC) as sinif_siralamasi\n    FROM\n        OgrenciNotlariAgirlikli\n)\nSELECT * FROM SinifSiralamasi;<\/code><\/pre>\n<p>Bu \u00f6rnekte, \u00f6nce a\u011f\u0131rl\u0131kl\u0131 ortalama hesaplan\u0131r, daha sonra pencere fonksiyonu <code class=\"language-\">RANK()<\/code> kullan\u0131larak her \u00f6\u011frencinin s\u0131n\u0131f i\u00e7indeki s\u0131ralamas\u0131 belirlenir.  Bu \u015fekilde daha detayl\u0131 analizler yapabiliriz.<\/p>\n<p><strong>Kenar Durumlar\u0131 (Edge Case&#8217;ler) ve Hata Y\u00f6netimi (\u0130leri Seviye)<\/strong><\/p>\n<p>A\u011f\u0131rl\u0131klar\u0131n toplam\u0131n\u0131n s\u0131f\u0131r olmas\u0131 gibi kenar durumlar\u0131, b\u00f6lme i\u015fleminde hata olu\u015fmas\u0131na neden olabilir.  Bunun \u00f6n\u00fcne ge\u00e7mek i\u00e7in <code class=\"language-\">CASE<\/code> ifadesi kullanabiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    ogrenci_id,\n    CASE\n        WHEN SUM(agirlik) = 0 THEN 0  -- A\u011f\u0131rl\u0131klar\u0131n toplam\u0131 s\u0131f\u0131r ise 0 d\u00f6nd\u00fcr\n        ELSE SUM(not * agirlik) \/ SUM(agirlik)\n    END AS agirlikli_ortalama\nFROM\n    ogrenci_notlari\nGROUP BY\n    ogrenci_id;<\/code><\/pre>\n<p>Bu kod blo\u011fu, a\u011f\u0131rl\u0131klar\u0131n toplam\u0131n\u0131n s\u0131f\u0131r olmas\u0131 durumunda s\u0131f\u0131r de\u011ferini d\u00f6nd\u00fcrerek hata olu\u015fmas\u0131n\u0131 engeller.  Di\u011fer kenar durumlar\u0131n\u0131 da benzer \u015fekilde ele alabilirsiniz.  \u00d6rne\u011fin, <code class=\"language-\">NULL<\/code> de\u011ferleri i\u00e7in uygun i\u015flemler yapman\u0131z gerekebilir.<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>PostgreSQL&#8217;de a\u011f\u0131rl\u0131kl\u0131 ortalama hesaplamak, verileri daha anlaml\u0131 bir \u015fekilde analiz etmenizi sa\u011flar.  Bu makalede, temel kavramlardan ileri d\u00fczey tekniklere kadar geni\u015f bir yelpazede bilgi vermeye \u00e7al\u0131\u015ft\u0131k.  Veri setinizin b\u00fcy\u00fckl\u00fc\u011f\u00fcne ve karma\u015f\u0131kl\u0131\u011f\u0131na ba\u011fl\u0131 olarak, performans optimizasyonu i\u00e7in farkl\u0131 stratejiler kullanman\u0131z gerekebilir.  Unutmay\u0131n ki verimli ve do\u011fru sonu\u00e7lar elde etmek i\u00e7in verilerinizi ve sorgu performans\u0131n\u0131z\u0131 dikkatlice analiz etmeniz \u00f6nemlidir. Daha fazla PostgreSQL ipucu ve p\u00fcf noktas\u0131 i\u00e7in [fatihsoysal.com](https:\/\/fatihsoysal.com) sitesini ziyaret edebilirsiniz.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong>A\u011f\u0131rl\u0131kl\u0131 ortalama, standart ortalamadan ne zaman daha uygundur?<\/strong>  Baz\u0131 veri noktalar\u0131n\u0131n di\u011ferlerinden daha \u00f6nemli oldu\u011fu durumlarda, a\u011f\u0131rl\u0131kl\u0131 ortalama daha do\u011fru sonu\u00e7lar verir.<\/p>\n<p>2. <strong>A\u011f\u0131rl\u0131klar negatif olabilir mi?<\/strong> Evet, ancak yorumlanmas\u0131 daha karma\u015f\u0131k olabilir. Negatif a\u011f\u0131rl\u0131klar, veri noktas\u0131n\u0131n ortalamay\u0131 a\u015fa\u011f\u0131 \u00e7ekti\u011fini g\u00f6sterir.<\/p>\n<p>3. <strong>PostgreSQL&#8217;de a\u011f\u0131rl\u0131kl\u0131 medyan nas\u0131l hesaplan\u0131r?<\/strong>  A\u011f\u0131rl\u0131kl\u0131 medyan hesaplamak i\u00e7in daha karma\u015f\u0131k sorgu yap\u0131lar\u0131n\u0131 kullanman\u0131z gerekebilir.  Bu, pencere fonksiyonlar\u0131 ve \u00f6zelle\u015ftirilmi\u015f fonksiyonlar gerektirebilir.<\/p>\n<p>4. <strong>\u00c7ok b\u00fcy\u00fck veri setleri i\u00e7in performans\u0131 nas\u0131l iyile\u015ftirebilirim?<\/strong>  Par\u00e7al\u0131 i\u015fleme (partitioning), materyalize view&#8217;ler ve daha geli\u015fmi\u015f optimizasyon teknikleri kullanabilirsiniz.<\/p>\n<p>5. <strong>A\u011f\u0131rl\u0131kl\u0131 ortalamada hatalar\u0131 nas\u0131l \u00f6nleyebilirim?<\/strong>  A\u011f\u0131rl\u0131klar\u0131n toplam\u0131n\u0131n s\u0131f\u0131r olmamas\u0131 ve NULL de\u011ferlerinin do\u011fru bir \u015fekilde ele al\u0131nmas\u0131 \u00f6nemlidir.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r? PostgreSQL veritaban\u0131n\u0131zda farkl\u0131 \u00f6neme sahip verileriniz mi var? \u00d6rne\u011fin, \u00f6\u011frencilerin farkl\u0131 a\u011f\u0131rl\u0131kl\u0131&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[644],"tags":[],"class_list":{"0":"post-25416","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL&#039;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r<\/title>\n<meta name=\"description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL&#039;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-06T00:15:24+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r\",\"datePublished\":\"2025-07-06T00:15:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/\"},\"wordCount\":983,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/\",\"name\":\"PostgreSQL'de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-06T00:15:24+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL'de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r","description":"Hi\u00e7bir etiketi bulunamad\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL'de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-06T00:15:24+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r","datePublished":"2025-07-06T00:15:24+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/"},"wordCount":983,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PostgreSQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/","name":"PostgreSQL'de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-06T00:15:24+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresqlde-agirlikli-ortalama-nasil-hesaplanir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL&#8217;de A\u011f\u0131rl\u0131kl\u0131 Ortalama Nas\u0131l Hesaplan\u0131r"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=25416"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25416\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=25416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=25416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=25416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}