{"id":27520,"date":"2025-08-14T18:15:34","date_gmt":"2025-08-14T15:15:34","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/"},"modified":"2025-08-14T18:15:34","modified_gmt":"2025-08-14T15:15:34","slug":"how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/","title":{"rendered":"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)"},"content":{"rendered":"<p># PostgreSQL&#8217;de Kayan Toplam Nas\u0131l Hesaplan\u0131r? (\u00d6rneklerle)<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda zaman serileri verisiyle \u00e7al\u0131\u015f\u0131yorsan\u0131z, kayan toplam (rolling sum) hesaplamak muhtemelen s\u0131k kar\u015f\u0131la\u015faca\u011f\u0131n\u0131z bir i\u015flemdir.  \u00d6rne\u011fin, son 7 g\u00fcnl\u00fck sat\u0131\u015flar\u0131n toplam\u0131n\u0131, her g\u00fcn i\u00e7in g\u00fcncel olarak hesaplamak isteyebilirsiniz veya her ay\u0131n k\u00fcm\u00fclatif sat\u0131\u015flar\u0131n\u0131 takip etmek isteyebilirsiniz.  Bu makale, PostgreSQL&#8217;de kayan toplam\u0131 hesaplaman\u0131n farkl\u0131 y\u00f6ntemlerini, performans optimizasyonunu ve ger\u00e7ek d\u00fcnya senaryolar\u0131n\u0131 ad\u0131m ad\u0131m ele alarak, yeni ba\u015flayanlardan uzmanlara kadar herkese rehberlik edecektir.<\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131:<\/strong><\/p>\n<p>* <strong>Yeni Ba\u015flayan:<\/strong> Ad\u0131m ad\u0131m a\u00e7\u0131klama, basit kod \u00f6rne\u011fi<br \/>\n* <strong>Orta Seviye:<\/strong> Ger\u00e7ek hayat \u00f6rne\u011fi, optimizasyon ipu\u00e7lar\u0131<br \/>\n* <strong>\u0130leri Seviye:<\/strong> Performans analizi, edge case&#8217;ler<\/p>\n<p><strong>PostgreSQL&#8217;de Kayan Toplam: Temel Kavramlar<\/strong><\/p>\n<p>Kayan toplam, bir veri k\u00fcmesinde belirli bir pencere b\u00fcy\u00fckl\u00fc\u011f\u00fcnde (\u00f6rne\u011fin, son 7 g\u00fcn, son 3 ay) ard\u0131\u015f\u0131k de\u011ferlerin toplam\u0131n\u0131 hesaplama i\u015flemidir.  Bu i\u015flem, trend analizi, anomalidete\u015fim tespiti ve tahminleme gibi bir\u00e7ok uygulamada kullan\u0131l\u0131r. PostgreSQL&#8217;de kayan toplam\u0131 hesaplamak i\u00e7in genellikle pencere fonksiyonlar\u0131 kullan\u0131l\u0131r. Pencere fonksiyonlar\u0131, bir sat\u0131r\u0131n belirli bir sat\u0131r k\u00fcmesi \u00fczerindeki (pencere) di\u011fer sat\u0131rlara g\u00f6re hesaplama yapmas\u0131na olanak tan\u0131r.  Bu pencere, <code class=\"language-\">ORDER BY<\/code> c\u00fcmleci\u011fi ile s\u0131ralan\u0131r ve <code class=\"language-\">PARTITION BY<\/code> c\u00fcmleci\u011fi ile grupland\u0131r\u0131labilir.<\/p>\n<p><strong>PostgreSQL&#8217;de Kayan Toplam Nas\u0131l Hesaplan\u0131r? (Ad\u0131m Ad\u0131m)<\/strong><\/p>\n<p>\u00d6ncelikle basit bir \u00f6rnek ile ba\u015flayal\u0131m.  A\u015fa\u011f\u0131daki tabloda g\u00fcnl\u00fck sat\u0131\u015f verilerimiz oldu\u011funu varsayal\u0131m:<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE sales (\n    sale_date DATE,\n    amount NUMERIC\n);\n\nINSERT INTO sales (sale_date, amount) VALUES\n('2024-01-01', 100),\n('2024-01-02', 150),\n('2024-01-03', 200),\n('2024-01-04', 120),\n('2024-01-05', 180),\n('2024-01-06', 250),\n('2024-01-07', 100);<\/code><\/pre>\n<p>Son 3 g\u00fcnl\u00fck kayan toplam\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    sale_date,\n    amount,\n    SUM(amount) OVER (ORDER BY sale_date ASC ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) as rolling_sum_3\nFROM\n    sales;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">SUM()<\/code> pencere fonksiyonunu kullanarak, her sat\u0131r i\u00e7in kendisinden \u00f6nceki iki sat\u0131r ve kendisinin toplam\u0131n\u0131 hesaplar (<code class=\"language-\">ROWS BETWEEN 2 PRECEDING AND CURRENT ROW<\/code>). <code class=\"language-\">ORDER BY sale_date ASC<\/code> c\u00fcmleci\u011fi, toplam\u0131n tarih s\u0131ras\u0131na g\u00f6re hesaplanmas\u0131n\u0131 sa\u011flar.<\/p>\n<p><strong>Ger\u00e7ek Hayat \u00d6rne\u011fi: Web Sitesi Trafi\u011fi Analizi<\/strong><\/p>\n<p>Bir web sitesinin g\u00fcnl\u00fck ziyaret\u00e7i say\u0131lar\u0131n\u0131 takip etti\u011finizi ve son 7 g\u00fcnl\u00fck ziyaret\u00e7i say\u0131s\u0131n\u0131n kayan toplam\u0131n\u0131 hesaplamak istedi\u011finizi varsayal\u0131m.  A\u015fa\u011f\u0131daki tabloda g\u00fcnl\u00fck ziyaret\u00e7i say\u0131lar\u0131 bulunmaktad\u0131r:<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE website_traffic (\n    visit_date DATE,\n    visitors INTEGER\n);\n\n--\u00d6rnek Veriler (buraya ger\u00e7ek verileriniz gelecek)\nINSERT INTO website_traffic (visit_date, visitors) VALUES\n('2024-01-20', 1000), ('2024-01-21', 1200), ('2024-01-22', 1500), ('2024-01-23', 1100),\n('2024-01-24', 1300), ('2024-01-25', 1400), ('2024-01-26', 1600), ('2024-01-27', 1800),\n('2024-01-28', 2000);<\/code><\/pre>\n<p>Son 7 g\u00fcnl\u00fck kayan toplam\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabilirsiniz:<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    visit_date,\n    visitors,\n    SUM(visitors) OVER (ORDER BY visit_date ASC ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as rolling_sum_7\nFROM\n    website_traffic;<\/code><\/pre>\n<p><strong>Kayan Toplam Hesaplamas\u0131nda Performans Optimizasyonu<\/strong><\/p>\n<p>B\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in kayan toplam hesaplamas\u0131 performans sorunlar\u0131na yol a\u00e7abilir.  Performans\u0131 optimize etmek i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz:<\/p>\n<p>* <strong>\u0130ndeksler:<\/strong> <code class=\"language-\">sale_date<\/code> veya <code class=\"language-\">visit_date<\/code> s\u00fctununa bir indeks eklemek sorgu performans\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir.<br \/>\n* <strong>Materyalize G\u00f6r\u00fcn\u00fcmler:<\/strong> S\u0131k kullan\u0131lan kayan toplam hesaplamalar\u0131 i\u00e7in materyalize g\u00f6r\u00fcn\u00fcmler olu\u015fturmak, verileri \u00f6nceden hesaplayarak sorgu s\u00fcresini k\u0131saltabilir.<br \/>\n* <strong>Pencere Fonksiyonu Optimizasyonu:<\/strong> Gereksiz pencere fonksiyonu kullanmaktan ka\u00e7\u0131n\u0131n.  Gerekti\u011finde, <code class=\"language-\">RANGE<\/code> yerine <code class=\"language-\">ROWS<\/code> kullan\u0131n, \u00e7\u00fcnk\u00fc <code class=\"language-\">ROWS<\/code> daha h\u0131zl\u0131d\u0131r.  Ancak, <code class=\"language-\">RANGE<\/code> baz\u0131 durumlarda daha uygun olabilir.<\/p>\n<p><strong>Kayan Toplam: \u0130leri D\u00fczey Teknikler ve Edge Case&#8217;ler<\/strong><\/p>\n<p>Daha karma\u015f\u0131k senaryolar i\u00e7in, <code class=\"language-\">PARTITION BY<\/code> c\u00fcmleci\u011fini kullanarak farkl\u0131 gruplar i\u00e7in kayan toplam hesaplayabilirsiniz.  \u00d6rne\u011fin, farkl\u0131 \u00fcr\u00fcnler i\u00e7in g\u00fcnl\u00fck sat\u0131\u015flar\u0131n kayan toplam\u0131n\u0131 hesaplamak isteyebilirsiniz.  A\u015fa\u011f\u0131daki \u00f6rnekte, <code class=\"language-\">product_id<\/code> s\u00fctununa g\u00f6re grupland\u0131rma yap\u0131lm\u0131\u015ft\u0131r:<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE sales_by_product (\n    sale_date DATE,\n    product_id INTEGER,\n    amount NUMERIC\n);\n-- \u00d6rnek veriler\nINSERT INTO sales_by_product (sale_date, product_id, amount) VALUES\n('2024-01-01', 1, 100), ('2024-01-01', 2, 50),\n('2024-01-02', 1, 150), ('2024-01-02', 2, 75),\n('2024-01-03', 1, 200), ('2024-01-03', 2, 100);\n\nSELECT\n    sale_date,\n    product_id,\n    amount,\n    SUM(amount) OVER (PARTITION BY product_id ORDER BY sale_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) as rolling_sum_2\nFROM\n    sales_by_product;<\/code><\/pre>\n<p>Ayr\u0131ca, eksik tarihler veya s\u0131f\u0131r de\u011ferler gibi edge case&#8217;leri ele almak i\u00e7in ek sorgu mant\u0131\u011f\u0131 eklemeniz gerekebilir.  Bu durumlar i\u00e7in <code class=\"language-\">COALESCE<\/code> fonksiyonu veya ko\u015fullu ifadeler kullan\u0131labilir.  \u00d6rne\u011fin, eksik tarihler i\u00e7in s\u0131f\u0131r de\u011fer atamak i\u00e7in <code class=\"language-\">COALESCE<\/code> fonksiyonunu kullanabilirsiniz.  Daha detayl\u0131 bilgi i\u00e7in [fatihsoysal.com](https:\/\/fatihsoysal.com) adresini ziyaret edebilirsiniz. (Buraya ilgili bir makale linki eklenebilir.)<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>PostgreSQL&#8217;de kayan toplam hesaplamak, pencere fonksiyonlar\u0131n\u0131n do\u011fru kullan\u0131m\u0131yla nispeten kolayd\u0131r.  Ancak, b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans optimizasyonu \u00f6nemlidir.  Bu makalede ele al\u0131nan y\u00f6ntemler ve ipu\u00e7lar\u0131, farkl\u0131 karma\u015f\u0131kl\u0131k seviyelerindeki kayan toplam hesaplamalar\u0131nda size yard\u0131mc\u0131 olacakt\u0131r.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong>Kayan toplam i\u00e7in hangi pencere fonksiyonlar\u0131n\u0131 kullanabilirim?<\/strong>  <code class=\"language-\">SUM()<\/code>, <code class=\"language-\">AVG()<\/code>, <code class=\"language-\">COUNT()<\/code>, <code class=\"language-\">MIN()<\/code>, <code class=\"language-\">MAX()<\/code> gibi bir\u00e7ok pencere fonksiyonu kayan toplam hesaplamas\u0131nda kullan\u0131labilir.<br \/>\n2. <strong><code class=\"language-\">ROWS<\/code> ve <code class=\"language-\">RANGE<\/code> aras\u0131ndaki fark nedir?<\/strong> <code class=\"language-\">ROWS<\/code>, belirli say\u0131da sat\u0131r\u0131 kapsar; <code class=\"language-\">RANGE<\/code>, belirli bir de\u011fer aral\u0131\u011f\u0131n\u0131 kapsar.<br \/>\n3. <strong>Kayan toplam hesaplamas\u0131n\u0131 nas\u0131l optimize edebilirim?<\/strong> \u0130ndeksler, materyalize g\u00f6r\u00fcn\u00fcmler ve pencere fonksiyonu optimizasyonu kullanarak.<br \/>\n4. <strong>Eksik verilerle nas\u0131l ba\u015fa \u00e7\u0131kabilirim?<\/strong> <code class=\"language-\">COALESCE<\/code> fonksiyonu veya ko\u015fullu ifadeler kullanarak.<br \/>\n5. <strong>Farkl\u0131 gruplar i\u00e7in kayan toplam nas\u0131l hesaplan\u0131r?<\/strong> <code class=\"language-\">PARTITION BY<\/code> c\u00fcmleci\u011fini kullanarak.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de Kayan Toplam Nas\u0131l Hesaplan\u0131r? (\u00d6rneklerle) PostgreSQL veritaban\u0131n\u0131zda zaman serileri verisiyle \u00e7al\u0131\u015f\u0131yorsan\u0131z, kayan toplam (rolling sum) hesaplamak&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-27520","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>How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)<\/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\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-14T15:15:34+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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)\",\"datePublished\":\"2025-08-14T15:15:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/\"},\"wordCount\":777,\"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\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/\",\"name\":\"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-08-14T15:15:34+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)\"}]},{\"@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":"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)","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\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/","og_locale":"tr_TR","og_type":"article","og_title":"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-08-14T15:15:34+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)","datePublished":"2025-08-14T15:15:34+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/"},"wordCount":777,"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\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/","url":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/","name":"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-08-14T15:15:34+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/how-to-calculate-a-rolling-sum-in-postgresql-with-example-ceviri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Calculate a Rolling Sum in PostgreSQL (With Example) (\u00c7eviri)"}]},{"@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\/27520","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=27520"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/27520\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=27520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=27520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=27520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}