{"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\/sq\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb","title":{"rendered":"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Pak\u00ebm nj\u00eb diskutim s\u00eb fundmi rreth asaj se si t\u00eb rrisim performanc\u00ebn e pyetjeve SQL \"p\u00ebr lexim\" <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/tensor\/blog\/492694\/\">nga baza e t\u00eb dh\u00ebnave PostgreSQL. Sot do t\u00eb flasim p\u00ebr m\u00ebnyrat<\/a><\/noindex> se si mund t\u00eb b\u00ebjm\u00eb regjistrimin <b>n\u00eb DB pa p\u00ebrdorur ndonj\u00eb \"rr\u00ebz\u00eb\" n\u00eb konfigurim \u2014 thjesht duke organizuar n\u00eb m\u00ebnyr\u00eb t\u00eb duhur rrjedhat e t\u00eb dh\u00ebnave.<\/b> Ky \u00ebsht\u00eb nj\u00eb artikull mbi m\u00ebnyrat dhe arsyet p\u00ebr t\u00eb organizuar<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 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>\nsegmentimin aplikativ \"n\u00eb teori\" <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/483170\/\">n\u00eb t\u00eb kaluar\u00ebn, dhe k\u00ebtu do t\u00eb flasim p\u00ebr praktik\u00ebn e p\u00ebrdorimit t\u00eb disa qasjeve brenda<\/a><\/noindex> sh\u00ebrbimit ton\u00eb t\u00eb monitorimit t\u00eb qindra server\u00ebve PostgreSQL <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/487380\/\">\"Koh\u00ebra t\u00eb kaluara...\"<\/a><\/noindex>.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h4>\u00abK\u00ebto jan\u00eb koh\u00ebt e kaluara&#8230;\u00bb<\/h4>\n<p>\ntabelat me madh\u00ebsi 1.5TB <b>, ku kuptuam se mund t\u00eb vazhdojm\u00eb, por ishte shum\u00eb e pap\u00ebrshtatshme.<\/b>Koha ishte pothuajse si n\u00eb legjenda, versionet e ndryshme t\u00eb PostgreSQL 9.x ishin t\u00eb zakonshme, prandaj t\u00eb gjitha segmentimet duhej t\u00eb b\u00ebheshin \"n\u00eb dor\u00eb\" - p\u00ebrmes<\/p>\n<p>trash\u00ebgimis\u00eb s\u00eb tabelave dhe trigger-ave <b>t\u00eb rrug\u00ebs me dinamik.<\/b> Zgjidhja q\u00eb mor\u00ebm rezultoi mjaft universale, p\u00ebr t'u aplikuar mbi t\u00eb gjitha tabelat: <code>EKZEKUTO<\/code>.<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/a480e75ccec73080aa2d0be1435d2a2e.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nIshte shpallur nj\u00eb tabel\u00eb e \"praz\u00ebt\" prind\u00ebrore, ku p\u00ebrshkruheshin t\u00eb gjitha<\/p>\n<ul>\n<li>indeksit dhe triggerat e nevojsh\u00ebm. <b>Regjistrimi nga pik\u00ebpamja e klientit b\u00ebhej n\u00eb tabel\u00ebn \"rr\u00ebnj\u00eb\", dhe brenda me an\u00eb t\u00eb<\/b>.<\/li>\n<li>trigger-it t\u00eb rrug\u00ebs <b>BEFORE INSERT<\/b> <code>regjistrimi \"fizikisht\" iu ngjit n\u00eb seksionin e duhur. N\u00ebse ajo nuk ekzistonte ende \u2014 ne zbulonim nj\u00eb p\u00ebrjashtim dhe \u2026<\/code> pjesa \u00abfizikisht\u00bb u fut n\u00eb seksionin e duhur. N\u00ebse nj\u00eb e till\u00eb nuk ekzistonte akoma \u2014 ne kapnim nj\u00eb p\u00ebrjashtim dhe &#8230;<\/li>\n<li>CREATE TABLE ... (LIKE ... INCLUDING ...) <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/492464\/\"><code>sipas modelit t\u00eb tabel\u00ebs prind\u00ebrore krijohej<\/code><\/a><\/noindex> nj\u00eb seksion me kufizimin e dat\u00ebs s\u00eb d\u00ebshiruar <b>, q\u00eb gjat\u00eb nxjerrjes s\u00eb t\u00eb dh\u00ebnave, leximi t\u00eb b\u00ebhej vet\u00ebm aty.<\/b>PG10: p\u00ebrpjekja e par\u00eb<\/li>\n<\/ul>\n<p><\/p>\n<h4>Por segmentimi p\u00ebrmes trash\u00ebgimis\u00eb historikisht nuk ishte shum\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr pun\u00eb me nj\u00eb fluks aktiv regjistrimi ose num\u00ebr t\u00eb madh seksionesh pasardh\u00ebse. P\u00ebr shembull, duhet t\u00eb kujtojm\u00eb q\u00eb algoritmi i zgjedhjes s\u00eb seksionit t\u00eb duhur kishte<\/h4>\n<p>\nkompleksitet katror <b>, q\u00eb me 100+ seksione punon, e kuptohet si\u2026<\/b>N\u00eb PG10 kjo situat\u00eb u optimizua ndjesh\u00ebm, duke implementuar mb\u00ebshtetje p\u00ebr<\/p>\n<p>segmentimin natyror <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/10\/ddl-partitioning\">seksionimi natyror<\/a><\/noindex>Prandaj, ne humb\u00ebm kohe dhe e provuam menj\u00ebher\u00eb pas migrimit t\u00eb ruajtjes, por\u2026<\/p>\n<p>Si\u00e7 u zbulua pas shfletimit t\u00eb manualit, tabela e ndar\u00eb natyrale n\u00eb k\u00ebt\u00eb version:<\/p>\n<ul>\n<li>nuk mb\u00ebshtet p\u00ebrshkrimin e indekseve<\/li>\n<li>nuk mb\u00ebshtet aktivizimin e tyre<\/li>\n<li>nuk mund t\u00eb jet\u00eb vet\u00eb asnj\u00eb \"trash\u00ebguese\"<\/li>\n<li>nuk mb\u00ebshtet <code>INSERT ... ON CONFLICT<\/code><\/li>\n<li>nuk di t\u00eb krijoj\u00eb nj\u00eb seksion automatikisht<\/li>\n<\/ul>\n<p>\nPas nj\u00eb goditjeje n\u00eb ball\u00eb nga gjethet, kuptuam se pa modifikimin e aplikacionit nuk do t'ia dilnim, dhe e shtym\u00eb k\u00ebrkimin p\u00ebr gjasht\u00eb muaj.<\/p>\n<h4>PG10: nj\u00eb mund\u00ebsi e dyt\u00eb<\/h4>\n<p>\nPra, filluam t\u00eb zgjidhim problemet q\u00eb kishim nj\u00ebri pas tjetrit:<\/p>\n<ol>\n<li>Pasi q\u00eb aktivizimet dhe <code>ON CONFLICT<\/code> na u duk\u00ebn t\u00eb nevojshme n\u00eb disa raste, p\u00ebr t'i p\u00ebrballuar ato krijuam nj\u00eb <b>tabel\u00eb nd\u00ebrmjet\u00ebse<\/b>.<\/li>\n<li><b>U shp\u00ebtuam \"routings\"<\/b> n\u00eb aktivizime - pra nga <code>EKZEKUTO<\/code>.<\/li>\n<li>Ndar\u00ebm ve\u00e7mas <b>nj\u00eb tabel\u00eb-model me t\u00eb gjitha indekset<\/b>, q\u00eb ato t\u00eb mos ishin t\u00eb pranishme as n\u00eb tabel\u00ebn nd\u00ebrmjet\u00ebse.<\/li>\n<\/ol>\n<p>\n<img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/db3118798357575568489f6b575373b6.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nP\u00ebrfundimisht, pas gjith\u00eb k\u00ebsaj, ndam\u00eb tabel\u00ebn kryesore natyralisht. Krijimi i nj\u00eb seksioni t\u00eb ri mbeti n\u00eb duar t\u00eb aplikacionit.<\/p>\n<h4>\"Dizem\" fjalor\u00ebt<\/h4>\n<p>\nSi n\u00eb \u00e7do sistem analitik, ne gjithashtu kishim <b>\"fakte\" dhe \"ndarje\"<\/b> (fjalor\u00eb). N\u00eb rastin ton\u00eb, n\u00eb k\u00ebt\u00eb rol u paraqit\u00ebn, p\u00ebr shembull, <noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/5XKbFb-l5Do?t=2487\">trupi i \"modelit\"<\/a><\/noindex> t\u00eb pyetjeve t\u00eb ngadalta ose teksti i vet\u00eb pyetjes.<\/p>\n<p>\"Faktet\" tona ishin ndar\u00eb sipas dit\u00ebve prej koh\u00ebsh, prandaj ne i fshim\u00eb pa problem seksionet e vjetra, dhe ato nuk na penguan (t\u00eb dh\u00ebnat b\u00ebhen!). Megjithat\u00eb, me fjalor\u00ebt rezultoi t\u00eb ishte nj\u00eb problem...<\/p>\n<p>Nuk mund t\u00eb thuhet se kishte shum\u00eb, por rreth <b>p\u00ebr \u00e7do 100TB \"faktesh\" kishte nj\u00eb fjalor 2.5TB.<\/b>Nga nj\u00eb tabel\u00eb e till\u00eb nuk \u00ebsht\u00eb e leht\u00eb t\u00eb hiqet apo t\u00eb kompresohet ndonj\u00eb gj\u00eb n\u00eb nj\u00eb koh\u00eb t\u00eb arsyeshme, dhe regjistrimi n\u00eb t\u00eb b\u00ebhej gjithnj\u00eb e m\u00eb i ngadalsh\u00ebm.<\/p>\n<p>Duket si nj\u00eb fjalor\u2026 \u00e7do regjistrim duhet t\u00eb jet\u00eb i pranish\u00ebm nj\u00eb her\u00eb sakt\u00ebsisht\u2026 dhe kjo \u00ebsht\u00eb e sakt\u00eb, por!.. Askush nuk na ndalon t\u00eb kemi <b>nj\u00eb fjalor t\u00eb ve\u00e7ant\u00eb p\u00ebr \u00e7do dit\u00eb<\/b>! Po, kjo sjell nj\u00eb tepric\u00eb t\u00eb caktuar, por lejon:<\/p>\n<ul>\n<li><b>t\u00eb shkruajm\u00eb \/ lexojm\u00eb m\u00eb shpejt<\/b> p\u00ebr shkak t\u00eb madh\u00ebsis\u00eb m\u00eb t\u00eb vog\u00ebl t\u00eb seksionit<\/li>\n<li><b>t\u00eb konsumojm\u00eb m\u00eb pak memorie<\/b> p\u00ebr shkak t\u00eb pun\u00ebs me indekse m\u00eb kompakte<\/li>\n<li><b>t\u00eb ruajm\u00eb m\u00eb pak t\u00eb dh\u00ebna<\/b> p\u00ebr shkak t\u00eb mund\u00ebsis\u00eb p\u00ebr t\u00eb fshir\u00eb shpejt t\u00eb dh\u00ebnat e vjetra<\/li>\n<\/ul>\n<p>\nSi rezultat i gjith\u00eb kompleksit t\u00eb masave <b>ngarkesa e CPU u ul me ~30%, ngarkesa p\u00ebr disk - me ~50%<\/b>:<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/fd3a219a304dc46173a7eb435502fe02.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nN\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb vazhduam t\u00eb shkruajm\u00eb n\u00eb baz\u00eb pik\u00ebrisht t\u00eb nj\u00ebjtat gj\u00ebra, thjesht me ngarkes\u00eb m\u00eb t\u00eb vog\u00ebl.<\/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>\nPra ndaj, ne u ndal\u00ebm tek se kemi <b>nj\u00eb seksion p\u00ebr \u00e7do dit\u00eb<\/b> me t\u00eb dh\u00ebna. N\u00eb fakt, <code>CHECK (dt = '2018-10-12'::date)<\/code> \u2013 dhe ky \u00ebsht\u00eb \u00e7el\u00ebsi i seksionimit dhe kushti p\u00ebr t\u00eb hyr\u00eb regjistrimin n\u00eb seksionin p\u00ebrkat\u00ebs.<\/p>\n<p>Duke qen\u00eb se t\u00eb gjitha raportet n\u00eb sh\u00ebrbimin ton\u00eb nd\u00ebrtohen sipas dat\u00ebs specifike, indeksat e krijuar q\u00eb nga \"koha pa seksionim\" p\u00ebr ato ishin gjithmon\u00eb t\u00eb tipit <i>(Server, <b>Data<\/b>, Shablloni i planit)<\/i>, <i>(Server, <b>Data<\/b>, Nodi i planit)<\/i>, <i>(<b>Data<\/b>, Klas\u00eb Gabimi, Server)<\/i>,\u2026<\/p>\n<p>Por tani n\u00eb \u00e7do seksion jan\u00eb <u>instancat e veta<\/u> t\u00eb \u00e7do indeksi t\u00eb till\u00eb... Dhe n\u00eb kuad\u00ebr t\u00eb \u00e7do seksioni <u>data \u00ebsht\u00eb nj\u00eb konstant\u00eb<\/u>... K\u00ebshtu q\u00eb tani ne n\u00eb \u00e7do indeks t\u00eb till\u00eb <b>thjesht e shkruajm\u00eb konstant\u00ebn<\/b> si nj\u00eb nga fushat, \u00e7ka rrit si madh\u00ebsin\u00eb e tij, ashtu edhe koh\u00ebn e k\u00ebrkimit p\u00ebr t\u00eb, por nuk sjell asnj\u00eb rezultat. Vet\u00eb i kemi l\u00ebn\u00eb gabimet, ups...<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/c7644644b960c568c4adaeec57cfef2d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nDrejtimi i optimizimit \u00ebsht\u00eb evident \u2014 thjesht <b>heqim fush\u00ebn me dat\u00eb nga t\u00eb gjith\u00eb indeksat<\/b> n\u00eb tabelat e seksionuara. Me volume tona, fitimi \u00ebsht\u00eb rreth <b>1TB\/ja n\u00eb jav\u00eb<\/b>!<\/p>\n<p>Dhe tani le t\u00eb v\u00ebm\u00eb re se ky terabajt ende duhet t\u00eb regjistrohet ndonj\u00ebher\u00eb. Pra, ne gjithashtu <b>duhet ta ngarkojm\u00eb disku tani m\u00eb pak<\/b>! N\u00eb k\u00ebt\u00eb imazh duket mir\u00eb efekti i arritur nga pastrimi i kryer, t\u00eb cilin ia kushtuam nj\u00eb jav\u00eb:<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 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>\nNj\u00eb nga fatkeq\u00ebsit\u00eb e m\u00ebdha t\u00eb sistemeve t\u00eb ngarkuara \u00ebsht\u00eb <b>sinkronizimi i tepruar<\/b> i disa operacioneve q\u00eb nuk e k\u00ebrkojn\u00eb at\u00eb. Nganj\u00ebher\u00eb \"sepse nuk e vun\u00eb re\", nganj\u00ebher\u00eb \"ishte m\u00eb e thjesht\u00eb\", por n\u00eb nj\u00eb moment duhet t\u00eb heqim dor\u00eb prej saj.<\/p>\n<p>Afrojm\u00eb imazhin e m\u00ebparsh\u00ebm \u2014 dhe shohim se disku yn\u00eb <b>\u201cngarkon\u201d n\u00eb ngarkes\u00eb me amplitud\u00eb dyfish<\/b> n\u00eb mes t\u00eb matjeve fqinj\u00ebsore, gj\u00eb q\u00eb duksh\u00ebm \"statistikisht\" nuk duhet t\u00eb ndodhte me nj\u00eb num\u00ebr t\u00eb till\u00eb operacionesh:<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/ac3f19213cba0f111864c6dbf9a73912.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nT\u00eb arrijm\u00eb k\u00ebt\u00eb \u00ebsht\u00eb mjaft e thjesht\u00eb. Ne kishim tashm\u00eb <b>praktikisht 1000 servera<\/b>, secili p\u00ebrpunon nj\u00eb rrjedh\u00eb logjike t\u00eb ve\u00e7ant\u00eb, dhe secila rrjedh\u00eb l\u00ebshon informacionin e akumuluar p\u00ebr t'u d\u00ebrguar n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave me nj\u00eb periodicitet t\u00eb caktuar, m\u00eb pak si kjo:<\/p>\n<pre><code class=\"javascript\">setInterval(sendToDB, interval)<\/code><\/pre>\n<p>\nProblemi k\u00ebtu q\u00ebndron n\u00eb faktin se <b>t\u00eb gjitha rrjedhat nisin n\u00eb nj\u00eb koh\u00eb t\u00eb ngjashme<\/b>, prandaj momentet e d\u00ebrgimit pothuajse gjithmon\u00eb p\u00ebrputhen \"deri n\u00eb pik\u00eb\". Ups \u21162...<\/p>\n<p>P\u00ebr fat, kjo rregullohet mjaft leht\u00eb, <b>duke shtuar \"rast\u00ebsisht\" distanc\u00ebn<\/b> n\u00eb koh\u00eb:<\/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>\nProblemi i tret\u00eb tradicional i highload - <b>mungesa e caches<\/b> atje ku duhej <i>mund t\u00eb<\/i> t\u00eb jet\u00eb.<\/p>\n<p>P\u00ebr shembull, ne kemi b\u00ebr\u00eb t\u00eb mundur analiz\u00ebn n\u00eb katror\u00ebt e planetit (t\u00eb gjitha k\u00ebto <code>Seq Scan mbi p\u00ebrdoruesit<\/code>), por menj\u00ebher\u00eb t\u00eb mendojm\u00eb se ato, n\u00eb mas\u00eb, jan\u00eb t\u00eb nj\u00ebjtat \u2014 kemi harruar.<\/p>\n<p>Jo, sigurisht, n\u00eb baz\u00eb nuk shkruhet asgj\u00eb p\u00ebrs\u00ebri, kjo e ndalon triggerin me <code>INSERT ... ON CONFLICT DO NOTHING<\/code>. Por deri te baza, k\u00ebto t\u00eb dh\u00ebna prap\u00eb arrijn\u00eb, madje edhe me nj\u00eb <b>lexim t\u00eb tepruar p\u00ebr t\u00eb verifikuar konfliktin<\/b> duke b\u00ebr\u00eb detyr\u00eb. Ups \u21163\u2026<\/p>\n<p>Diferen\u00e7a n\u00eb numrin e sh\u00ebnimeve t\u00eb d\u00ebrguara n\u00eb baz\u00eb p\u00ebrpara\/pas aktivizimit t\u00eb caching-ut \u00ebsht\u00eb e qart\u00eb:<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/37fa7e64a674f03a79f2765a79ec8138.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDhe kjo \u00ebsht\u00eb nj\u00eb r\u00ebnie shoq\u00ebruese e ngarkes\u00ebs n\u00eb depo:<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/b2c563b4b41755211e77768d80f8702f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>P\u00ebrve\u00e7 k\u00ebsaj<\/h2>\n<p>\n\u00abTera-byty n\u00eb dit\u00eb\u00bb vet\u00ebm ting\u00ebllon tmerrsh\u00ebm. N\u00ebse b\u00ebni gjith\u00e7ka si\u00e7 duhet, at\u00ebher\u00eb kjo \u00ebsht\u00eb vet\u00ebm <b>2^40 byte \/ 86400 sekonda = ~12.5MB\/s<\/b>, q\u00eb e mbajn\u00eb madje edhe hard disk\u00ebt IDE t\u00eb tavolin\u00ebs. \ud83d\ude42<\/p>\n<p>Dhe n\u00ebse jemi serioz, edhe me nj\u00eb \u2018ferkim\u2019 dhjet\u00ebfish t\u00eb ngarkes\u00ebs n\u00eb nj\u00eb dit\u00eb, ju mund t\u00eb p\u00ebrputheni leht\u00ebsisht me mund\u00ebsit\u00eb e SSD-ve moderne.<\/p>\n<p><img decoding=\"async\" alt=\"Shkruajm\u00eb n\u00eb PostgreSQL n\u00eb sublumin: 1 host, 1 dit\u00eb, 1TB\" src=\"\/wp-content\/uploads\/2020\/04\/6f3f8d4636ba50f3d5401bf4e456757f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>Burimi: <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.2 - 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\/sq\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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\udd47Shkruajm\u00eb n\u00eb PostgreSQL me n\u00ebnshkronim: 1 host, 1 dit\u00eb, 1TB | ProHoster","description":"S\u00eb fundmi kam treguar se si me ndihm\u00ebn e receta standarde t\u00eb rritet performanca e pyetjeve SQL \u201cp\u00ebr lexim\u201d nga.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/pishem-v-postgresql-na-subsvetovoj-1-host-1-day-1tb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/79028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=79028"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/79028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/79029"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=79028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=79028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=79028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}