{"id":79028,"date":"2020-04-23T19:43:19","date_gmt":"2020-04-23T17:43:19","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb"},"modified":"2020-04-23T19:43:19","modified_gmt":"2020-04-23T17:43:19","slug":"pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb","title":{"rendered":"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nedavno sem povedal, kako z uporabo standardnih receptov <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/tensor\/blog\/492694\/\">pove\u010dati u\u010dinkovitost SQL poizvedb \"za branje\"<\/a><\/noindex> iz PostgreSQL baze. Danes pa bomo govorili o tem, kako <b>mo\u017eno narediti u\u010dinkovitej\u0161e zapisovanje<\/b> v BDP, brez uporabe kakr\u0161nih koli \"vzvodov\" v konfiguraciji \u2014 preprosto z organizacijo podatkovnih tokov.<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/cbebbe0ed0e9a6590a4e8dd144f82f40.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<h2>#1. \u0421\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435<\/h2>\n<p>\n\u010clanek o tem, kako in zakaj je smiselno organizirati <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/483170\/\">prakti\u010dno sekcioniranje \"v teoriji\"<\/a><\/noindex> je \u017ee bil, tukaj pa se bomo osredoto\u010dili na prakti\u010dno uporabo nekaterih pristopov v okviru na\u0161ega <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/487380\/\">monitoring servisa za stotine PostgreSQL stre\u017enikov<\/a><\/noindex>.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h4>\u00bbDela davno minulih dni\u2026\u00ab<\/h4>\n<p>\nSprva, kot vsak MVP, je na\u0161 projekt za\u010del z relativno majhnim obremenitvijo \u2014 spremljanje je potekalo le za deset najkriti\u010dnej\u0161ih stre\u017enikov, vse tabele so bile razmeroma kompaktne\u2026 A \u010das je mineval, \u0161tevilo spremljanih gostiteljev se je pove\u010devalo, in ko smo poizku\u0161ali enkrat ve\u010d narediti nekaj z eno od <b>tabelami velikosti 1.5TB<\/b>, smo spoznali, da se da \u017eiveti tako, a je vseeno zelo neprijetno.<\/p>\n<p>\u010casi so bili skorajda juna\u0161ki, aktualni so bili razli\u010dni razli\u010dici PostgreSQL 9.x, zato je bilo vse sekcioniranje treba izvajati \"ro\u010dno\" \u2014 preko <b>podedovanja tabel in spro\u017eilcev<\/b> usmerjanja s dinami\u010dnim <code>EXECUTE<\/code>.<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/a480e75ccec73080aa2d0be1435d2a2e.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nRe\u0161itev se je izkazala za dovolj univerzalno, da jo je bilo mogo\u010de prenesti na vse tabele:<\/p>\n<ul>\n<li>Razgla\u0161ena je bila prazna \"glavna\" nadtabela, na kateri so bile opisane vse <b>potrebne indekse in spro\u017eilce<\/b>.<\/li>\n<li>Zapis z vidika odjemalca se je izvajal v \"koreninsko\" tabelo, znotraj pa s pomo\u010djo <b>spro\u017eilca usmerjanja<\/b> <code>BEFORE INSERT<\/code> zapisi \u00bbfizi\u010dno\u00ab vstavili v potrebno sekcijo. \u010ce tak\u0161ne \u0161e ni bilo - smo ujeli izjemo in \u2026<\/li>\n<li>\u2026 s pomo\u010djo <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/492464\/\"><code>CREATE TABLE ... (LIKE ... INCLUDING ...)<\/code><\/a><\/noindex> po predlogi glavne tabele je bila ustvarjena <b>sekcija z omejitvijo na potrebno datum<\/b>, da se pri pridobivanju podatkov branje izvaja samo v njej.<\/li>\n<\/ul>\n<p><\/p>\n<h4>PG10: prva vaja<\/h4>\n<p>\nA vendar je bilo sekcioniranje preko podedovanja zgodovinsko slabo prilagodljivo za delo z aktivnim tokom zapisovanja ali velikim \u0161tevilom sekcij-podedkov. Na primer, lahko se spomnimo, da je imel algoritem izbire potrebne sekcije <b>kvadratno kompleksnost<\/b>, kar pri 100+ sekcijah deluje, kot si lahko predstavljate \u2026<\/p>\n<p>V PG10 so to situacijo mo\u010dno optimizirali, saj so uvedli podporo <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/10\/ddl-partitioning\">nativnemu sekcioniranju<\/a><\/noindex>Zato smo takoj poskusili uporabiti takoj po selitvi shrambe, ampak...<\/p>\n<p>Kot se je izkazalo po pregledovanju priro\u010dnika, nativno sekcionirana tabela v tej razli\u010dici:<\/p>\n<ul>\n<li>ne podpira opisa indeksov<\/li>\n<li>ne podpira spro\u017eilcev<\/li>\n<li>ne more biti sama ni\u010dji 'potomec'<\/li>\n<li>ne podpira <code>INSERT ... ON CONFLICT<\/code><\/li>\n<li>ne zna samodejno ustvariti sekcijo<\/li>\n<\/ul>\n<p>\nPo\u0161teno smo se udarili po \u010delu z grabljami in spoznali, da brez spremembe aplikacije ne bo \u0161lo, ter smo nadaljnje raziskave odlo\u017eili za pol leta.<\/p>\n<h4>PG10: druga prilo\u017enost<\/h4>\n<p>\nTorej, za\u010deli smo re\u0161evati nastale te\u017eave eno za drugo:<\/p>\n<ol>\n<li>Ker so spro\u017eilci in <code>ON CONFLICT<\/code> bili nekje vseeno potrebni, smo za njihovo delovanje naredili vmesno <b>proxy tabelo<\/b>.<\/li>\n<li><b>Opravi\u010dili smo se od 'usmerjanja'<\/b> v spro\u017eilcih \u2014 torej od <code>EXECUTE<\/code>.<\/li>\n<li>Lo\u010dili smo posebej <b>predlogo z vsemi indeksi<\/b>, da ne bi niti bili prisotni na proxy tabeli.<\/li>\n<\/ol>\n<p>\n<img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/db3118798357575568489f6b575373b6.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nNazadnje, po vsem tem, smo \u017ee nativno sekcionirali glavno tabelo. Ustvarjanje nove sekcije je ostalo \u0161e vedno na vest aplikacije.<\/p>\n<h4>Delamo na slovarjih<\/h4>\n<p>\nKot v vsakem analiti\u010dnem sistemu, smo imeli tudi mi <b>'fakte' in 'razreze'<\/b> (slovarji). V na\u0161em primeru so to predstavljali na primer <noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/5XKbFb-l5Do?t=2487\">telo 'predloge'<\/a><\/noindex> homogenih po\u010dasnih poizvedb ali besedilo same poizvedbe.<\/p>\n<p>'Fakti' so bili \u017ee dolgo sekcionirani po dnevih, tako da smo mirno odstranjevali zastarele sekcije, in niso nam motile (saj so logi!). Ustvarila pa se je te\u017eava s slovarji...<\/p>\n<p>Ni mogo\u010de re\u010di, da jih je bilo zelo veliko, ampak pribli\u017eno <b>na 100TB 'faktov' smo dobili slovar na 2.5TB.<\/b>Iz tak\u0161ne tabele ni enostavno ni\u010desar izbrisati, niti stisniti v razumljivem \u010dasu, poleg tega je pisanje vanjo postopoma postajalo vse po\u010dasnej\u0161e.<\/p>\n<p>Tako da je slovar... v njem mora biti vsak zapis predstavljen natan\u010dno enkrat... in to je pravilno, ampak!.. Nih\u010de nam ne prepre\u010duje, da imamo <b>po posameznem slovarju za vsak dan<\/b>! Ja, to prina\u0161a dolo\u010deno odve\u010dnost, vendar omogo\u010da:<\/p>\n<ul>\n<li><b>hitrej\u0161e pisanje\/branje<\/b> z manj\u0161o velikostjo sekcije<\/li>\n<li><b>manj\u0161o porabo pomnilnika<\/b> z delom s bolj kompaktnimi indeksi<\/li>\n<li><b>manj podatkov<\/b> z mo\u017enostjo hitrega odstranjevanja zastarelih<\/li>\n<\/ul>\n<p>\nKot rezultat celotnega kompleksa ukrepov <b>se je obremenitev CPU zmanj\u0161ala za ~30%, obremenitev diska pa za ~50%<\/b>:<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/fd3a219a304dc46173a7eb435502fe02.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nPri tem smo nadaljevali s pisanjem v bazo ravno to, le z manj\u0161o obremenitvijo.<\/p>\n<h2>#2. \u042d\u0432\u043e\u043b\u044e\u0446\u0438\u044f \u0438 \u0440\u0435\u0444\u0430\u043a\u0442\u043e\u0440\u0438\u043d\u0433 \u0411\u0414<\/h2>\n<p>\nTorej, ustavili smo se pri tem, da imamo <b>za vsak dan svojo sekcijo<\/b> z podatki. Dejansko, <code>CHECK (dt = '2018-10-12'::date)<\/code> \u2014 in to je klju\u010d sekcioniranja ter pogoj za uvrstitev zapisa v dolo\u010deno sekcijo.<\/p>\n<p>Ker so vsi poro\u010dila v na\u0161i storitvi zgrajena glede na dolo\u010dene datume, so tudi indeksi \u017ee iz \"nesectioniranih \u010dasov\" vsi tipi <i>(Stre\u017enik, <b>Datum<\/b>, Predloga na\u010drta)<\/i>, <i>(Stre\u017enik, <b>Datum<\/b>, Vozli\u0161\u010de na\u010drta)<\/i>, <i>(<b>Datum<\/b>, Razred napake, Stre\u017enik)<\/i>,\u2026<\/p>\n<p>Ampak zdaj v vsaki sekciji \u017eivijo <u>svoja instanca<\/u> vsakega tak\u0161nega indeksa\u2026 In v okviru vsake sekcije <u>datum \u2014 konstanta<\/u>\u2026 Izkazalo se je, da zdaj v vsak tak indeks <b>preprosto vpi\u0161emo konstanto<\/b> kot eno od polj, kar pove\u010duje tako njegovo velikost kot tudi \u010das iskanja po njem, ne prina\u0161a pa nobenih rezultatov. Sami smo si postavili pasti, ups\u2026<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/c7644644b960c568c4adaeec57cfef2d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nUsmeritev optimizacije je o\u010ditna \u2014 enostavno <b>odstranimo polje z datumom iz vseh indeksov<\/b> na sekcioniranih tabelah. Pri na\u0161ih volumenih je prihranek \u2014 pribli\u017eno <b>1TB\/teden<\/b>!<\/p>\n<p>In zdaj opazimo, da je bilo ta terabajt \u0161e treba nekako zabele\u017eiti. Torej moramo tudi <b>disk zdaj obremenjevati manj<\/b>! Na tej sliki je dobro vidna dose\u017eena u\u010dinkovitost po izvedeni \u010di\u0161\u010denju, ki smo ji posvetili en teden:<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/f45e3b26337074a07751ea28961009bf.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>#3. \u00ab\u0420\u0430\u0437\u043c\u0430\u0437\u044b\u0432\u0430\u0435\u043c\u00bb \u043f\u0438\u043a\u043e\u0432\u0443\u044e \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0443<\/h2>\n<p>\nEna od velikih te\u017eav obremenjenih sistemov je <b>odve\u010dno sinhroniziranje<\/b> neke operacije, ki tega ne zahtevajo. V\u010dasih \"ker nismo opazili\", v\u010dasih \"tako je bilo la\u017eje\", a prej ali slej se moramo tega znebiti.<\/p>\n<p>Povezujemo s prej\u0161njo sliko \u2014 in vidimo, da na\u0161 disk <b>\"nosi\" obremenitev z dvakratno amplitudo<\/b> med sosednjimi meritvami, kar o\u010ditno \"statisti\u010dno\" ne bi smelo biti pri tak\u0161nem \u0161tevilu operacij:<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/ac3f19213cba0f111864c6dbf9a73912.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDose\u010di to je dovolj preprosto. Na\u0161a monitoring je \u017ee obsegala <b>skoraj 1000 stre\u017enikov<\/b>, vsak obdelan z lo\u010denim logi\u010dnim tokom, vsak tok pa odda akumulirane informacije za po\u0161iljanje v bazo s dolo\u010denim \u010dasovnim intervalom, pribli\u017eno takole:<\/p>\n<pre><code class=\"javascript\">setInterval(sendToDB, interval)<\/code><\/pre>\n<p>\nTe\u017eava je v tem, da <b>vsi tokovi za\u010denjajo pribli\u017eno ob istem \u010dasu<\/b>, zato se trenutki po\u0161iljanja skoraj vedno ujemajo \"do to\u010dke\". Ups \u0161tevilka 2\u2026<\/p>\n<p>Na sre\u010do se to da precej enostavno popraviti, <b>z dodajanjem \"naklju\u010dnega\" zamika<\/b> po \u010dasu:<\/p>\n<pre><code class=\"javascript\">setInterval(sendToDB, interval * (1 + 0.1 * (Math.random() - 0.5)))<\/code><\/pre>\n<p><\/p>\n<h2>#4. \u041a\u044d\u0448\u0438\u0440\u0443\u0435\u043c, \u0447\u0442\u043e \u043d\u0443\u0436\u043d\u043e \u043c\u043e\u0436\u043d\u043e<\/h2>\n<p>\nTretja tradicionalna te\u017eava highload \u2014 <b>pomanjkanje predpomnilnika<\/b> tja, kjer bi moral <i>lahko<\/i> biti.<\/p>\n<p>Na primjer, omogu\u0107ili smo analizu prema \u010dvorovima plana (svi ti <code>Seq Scan na korisnicima<\/code>), ali odmah pomisliti da su oni, u masi, isti - zaboravili su.<\/p>\n<p>Ne, naravno, ni\u0161ta se ne pi\u0161e ponovo u bazu, to isklju\u010duje okida\u010d s <code>INSERT ... ON CONFLICT DO NOTHING<\/code>. Ali podaci ipak sti\u017eu do baze, a jo\u0161 i dodatno <b>\u010ditati za provjeru sukoba<\/b> mora se raditi. Ups br. 3\u2026<\/p>\n<p>Razlika u broju unosa u bazu prije\/nakon uklju\u010divanja ke\u0161iranja - o\u010dita:<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/37fa7e64a674f03a79f2765a79ec8138.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nA ovo je - prate\u0107i pad optere\u0107enja na skladi\u0161tu:<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/b2c563b4b41755211e77768d80f8702f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>Ukupno<\/h2>\n<p>\n\u00abTerabajt-na-dan\u00bb samo zvu\u010di zastra\u0161uju\u0107e. Ako sve radite ispravno, to je samo <b>2^40 bajtova \/ 86400 sekundi = ~12.5MB\/s<\/b>, \u0161to su i desktop IDE tvrdnji mogli dr\u017eati. \ud83d\ude42<\/p>\n<p>A ako ozbiljno, \u010dak i pri desetostrukom \u00abiskretanju\u00bb optere\u0107enja tokom dana, mo\u017eete se lako uklopiti u mogu\u0107nosti modernih SSD-ova.<\/p>\n<p><img decoding=\"async\" alt=\"Pisanje v PostgreSQL pri svetlobni hitrosti: 1 gostitelj, 1 dan, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/6f3f8d4636ba50f3d5401bf4e456757f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/497008\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u043b, \u043a\u0430\u043a \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0438\u043f\u043e\u0432\u044b\u0445 \u0440\u0435\u0446\u0435\u043f\u0442\u043e\u0432 \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u00ab\u043d\u0430 \u0447\u0442\u0435\u043d\u0438\u0435\u00bb \u0438\u0437 PostgreSQL-\u0431\u0430\u0437\u044b. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0436\u0435 \u0440\u0435\u0447\u044c \u043f\u043e\u0439\u0434\u0435\u0442 \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0431\u043e\u043b\u0435\u0435 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u0437\u0430\u043f\u0438\u0441\u044c \u0432 \u0411\u0414 \u0431\u0435\u0437 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u043a\u0430\u043a\u0438\u0445-\u043b\u0438\u0431\u043e \u00ab\u043a\u0440\u0443\u0442\u0438\u043b\u043e\u043a\u00bb \u0432 \u043a\u043e\u043d\u0444\u0438\u0433\u0435 \u2014 \u043f\u0440\u043e\u0441\u0442\u043e \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043e\u0432\u0430\u0432 \u043f\u043e\u0442\u043e\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. #1. \u0421\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0421\u0442\u0430\u0442\u044c\u044f \u043f\u0440\u043e \u0442\u043e, \u043a\u0430\u043a \u0438 \u0437\u0430\u0447\u0435\u043c \u0441\u0442\u043e\u0438\u0442 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043e\u0432\u044b\u0432\u0430\u0442\u044c \u043f\u0440\u0438\u043a\u043b\u0430\u0434\u043d\u043e\u0435 \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u00ab\u0432 \u0442\u0435\u043e\u0440\u0438\u0438\u00bb [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":79029,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-79028","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u043b, \u043a\u0430\u043a \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0438\u043f\u043e\u0432\u044b\u0445 \u0440\u0435\u0446\u0435\u043f\u0442\u043e\u0432 \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u00ab\u043d\u0430 \u0447\u0442\u0435\u043d\u0438\u0435\u00bb \u0438\u0437.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sl_SI\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041f\u0438\u0448\u0435\u043c \u0432 PostgreSQL \u043d\u0430 \u0441\u0443\u0431\u0441\u0432\u0435\u0442\u043e\u0432\u043e\u0439: 1 host, 1 day, 1TB | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u043b, \u043a\u0430\u043a \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0438\u043f\u043e\u0432\u044b\u0445 \u0440\u0435\u0446\u0435\u043f\u0442\u043e\u0432 \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u00ab\u043d\u0430 \u0447\u0442\u0435\u043d\u0438\u0435\u00bb \u0438\u0437.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-04-23T17:43:19+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-23T17:43:19+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Pi\u0161emo u PostgreSQL na subsvetlosnoj brzini: 1 host, 1 dan, 1TB | ProHoster","description":"Nedavno sam govorio o tome kako koristiti standardne recepte za pobolj\u0161anje performansi SQL upita \u00abza \u010ditanje\u00bb iz.","canonical_url":"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sl_SI","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041f\u0438\u0448\u0435\u043c \u0432 PostgreSQL \u043d\u0430 \u0441\u0443\u0431\u0441\u0432\u0435\u0442\u043e\u0432\u043e\u0439: 1 host, 1 day, 1TB | ProHoster","og:description":"\u041d\u0435\u0434\u0430\u0432\u043d\u043e \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u043b, \u043a\u0430\u043a \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0438\u043f\u043e\u0432\u044b\u0445 \u0440\u0435\u0446\u0435\u043f\u0442\u043e\u0432 \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u00ab\u043d\u0430 \u0447\u0442\u0435\u043d\u0438\u0435\u00bb \u0438\u0437.","og:url":"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-04-23T17:43:19+00:00","article:modified_time":"2020-04-23T17:43:19+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"79028","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 16:46:34","updated":"2022-10-01 20:30:41","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/79028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/comments?post=79028"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/79028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media\/79029"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media?parent=79028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/categories?post=79028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/tags?post=79028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}