{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"PostgreSQL'e G\u00f6\u00e7: Tablo S\u00fctun T\u00fcrleri ve S\u0131ras\u0131","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"XbeD0rUpkg\"><a href=\"https:\/\/fatihsoysal.com\/blog\/postgresqle-goc-tablo-sutun-turleri-ve-sirasi\/\">PostgreSQL&#8217;e G\u00f6\u00e7: Tablo S\u00fctun T\u00fcrleri ve S\u0131ras\u0131<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/postgresqle-goc-tablo-sutun-turleri-ve-sirasi\/embed\/#?secret=XbeD0rUpkg\" width=\"600\" height=\"338\" title=\"&#8220;PostgreSQL&#8217;e G\u00f6\u00e7: Tablo S\u00fctun T\u00fcrleri ve S\u0131ras\u0131&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"XbeD0rUpkg\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"PostgreSQL, g\u00fc\u00e7l\u00fc \u00f6zellikleri ve \u00f6l\u00e7eklenebilirli\u011fi ile bir\u00e7ok geli\u015ftirici taraf\u0131ndan tercih edilen bir veritaban\u0131 y\u00f6netim sistemidir. Ancak, mevcut bir veritaban\u0131ndan PostgreSQL'e ge\u00e7i\u015f yaparken, tablo s\u00fctun t\u00fcrleri ve bunlar\u0131n s\u0131ralamas\u0131 performans ve verimlilik a\u00e7\u0131s\u0131ndan b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. Bu makalede, bu ge\u00e7i\u015f s\u00fcrecinde dikkate alman\u0131z gereken \u00f6nemli noktalar\u0131 ele alaca\u011f\u0131z. Ba\u015flang\u0131\u00e7ta, mevcut veritaban\u0131n\u0131z\u0131n yap\u0131s\u0131n\u0131 ve verilerinizi analiz etmeniz \u015fartt\u0131r. Ard\u0131ndan, bu analize g\u00f6re en uygun PostgreSQL veri tiplerini se\u00e7meniz gerekir."}