{"id":79039,"date":"2020-04-23T19:43:26","date_gmt":"2020-04-23T17:43:26","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/ekonomim-kopeechku-na-bolshih-obemah-v-postgresql"},"modified":"2020-04-23T19:43:26","modified_gmt":"2020-04-23T17:43:26","slug":"ekonomim-kopeechku-na-bolshih-obemah-v-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/ekonomim-kopeechku-na-bolshih-obemah-v-postgresql","title":{"rendered":"Ietaup\u0101m naudu lielos apjomos PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Turpinot t\u0113mu par lielu datu pl\u016bsmu ierakst\u012b\u0161anu, kas tika uzs\u0101kta <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/497008\/\">ieguld\u012bjuma rakst\u0101 par sektoriz\u0101ciju<\/a><\/noindex>, \u0161aj\u0101 tiks apl\u016bkoti veidi, k\u0101 <b>samazin\u0101t hronolo\u0123isko<\/b> apjomu, kas tiek glab\u0101ts<\/p>\n<p>PostgreSQL, un to ietekmi uz servera sniegumu. <b>Run\u0101sim par<\/b>TOAST iestat\u012bjumiem un datu izl\u012bdzin\u0101\u0161anu.<\/p>\n<p><img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/4d43b9b43edb10c4c8f13159c7dd1eac.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n\u201eVid\u0113ji\u201d \u0161ie pa\u0146\u0113mieni \u013caus ietaup\u012bt ne p\u0101r\u0101k daudz resursu, bet \u2014 piln\u012bgi bez koda modifik\u0101cijas. <b>Tom\u0113r m\u016bsu pieredze \u0161aj\u0101 jom\u0101 izr\u0101d\u012bj\u0101s diezgan produkt\u012bva, jo uzglab\u0101\u0161ana praktiski jebkura uzraudz\u012bbas sist\u0113ma p\u0113c savas b\u016bt\u012bbas ir<\/b> liel\u0101koties append-only <b>attiec\u012bb\u0101 uz rakst\u012btajiem datiem. Un, ja jums interes\u0113, k\u0101 var\u0113tu iem\u0101c\u012bt datub\u0101zei rakst\u012bt uz diska ar \u0101trumu<\/b> 200MB\/s<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>pusstund\u0101, l\u016bdzu, dodieties uz leju.<\/h2>\n<p>\nMazi nosl\u0113pumi par lieliem datiem <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/487380\/\">M\u016bsu pakalpojuma profil\u0101<\/a><\/noindex>, tam regul\u0101ri tiek sa\u0146emti no \u017eurn\u0101liem <b>teksta paketi.<\/b>.<\/p>\n<p>Un, \u0146emot v\u0113r\u0101, ka <noindex><a rel=\"nofollow\" href=\"https:\/\/sbis.ru\/all_services\">SIBS komplekss<\/a><\/noindex>, kuru datub\u0101zes m\u0113s uzraudz\u0101m, \u2014 ir multipl\u0101 komponenta produkts ar sare\u017e\u0123\u012bt\u0101m datu strukt\u016br\u0101m, tad <b>pieprasa maksim\u0101las produktivit\u0101tes<\/b> tiek ieg\u016bti diezgan <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/486072\/\">\u201edaudzs\u0113riju\u201d ar sare\u017e\u0123\u012btu algoritmisko lo\u0123iku.<\/a><\/noindex>T\u0101p\u0113c katra atsevi\u0161\u0137\u0101 piepras\u012bjuma vai rezult\u0101tu izpildes pl\u0101na apjoms, kas non\u0101k pie mums \u017eurn\u0101l\u0101, izr\u0101d\u0101s \u201evid\u0113ji\u201d pietiekami liels.<\/p>\n<p>Apskat\u012bsim vienas no tabul\u0101m strukt\u016bru, uz kuru m\u0113s rakst\u0101m \u201eneapstr\u0101d\u0101tos\u201d datus \u2014 tas ir, tie\u0161i ori\u0123in\u0101lais teksts no \u017eurn\u0101la ieraksta:<\/p>\n<pre><code class=\"sql\">CREATE TABLE rawdata_orig(\n  pack -- PK\n    uuid NOT NULL\n, recno -- PK\n    smallint NOT NULL\n, dt -- sektora atsl\u0113ga\n    date\n, data -- pats svar\u012bg\u0101kais\n    text\n, PRIMARY KEY(pack, recno)\n);<\/code><\/pre>\n<p>\nTipiska \u0161\u0101da tabula (jau sektoriz\u0113ta, protams, t\u0101d\u0113\u013c \u0161\u012b ir sektora veidne), kur svar\u012bg\u0101kais ir teksts. Da\u017ek\u0101rt pietiekami apjom\u012bgs.<\/p>\n<p>Atg\u0101din\u0101sim, ka \u201efiziskais\u201d katras ieraksta lielums PG nevar p\u0101rsniegt vienu datu lapu, bet \u201elo\u0123iskais\u201d lielums \u2014 ir pavisam cita lieta. Lai ierakst\u012btu lauk\u0101 apjom\u012bgu v\u0113rt\u012bbu (varchar\/text\/bytea), tiek izmantota <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/storage-toast\">TOAST tehnolo\u0123ija.<\/a><\/noindex>:<\/p>\n<blockquote><p>PostgreSQL izmanto fiks\u0113tu lapas izm\u0113ru (parasti 8 KB) un ne\u013cauj tupleiem aiz\u0146emt vair\u0101kas lapas. T\u0101d\u0113\u013c tie\u0161i glab\u0101t \u013coti lielas lauku v\u0113rt\u012bbas nav iesp\u0113jams. Lai apietu \u0161o ierobe\u017eojumu, lielas lauku v\u0113rt\u012bbas tiek saspiestas un\/vai sadal\u012btas vair\u0101k\u0101s fizisk\u0101s rind\u0101s. Tas notiek neman\u0101mi lietot\u0101jam un uz liel\u0101ko da\u013cu servera koda ietekme ir minim\u0101la. \u0160\u012b metode ir paz\u012bstama k\u0101 TOAST \u2026<\/p><\/blockquote>\n<p>\nFaktiski, katrai tabulai ar \"potenci\u0101li lieliem\" laukiem autom\u0101tiski <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/storage-toast#STORAGE-TOAST-ONDISK\">tiek izveidota p\u0101ra tabula ar \"\u0161\u0137\u0113l\u0113m\"<\/a><\/noindex> katrai \"lielai\" rindai segment\u0113s pa 2KB:<\/p>\n<pre><code class=\"sql\">TOAST(\n  chunk_id\n    integer\n, chunk_seq\n    integer\n, chunk_data\n    bytea\n, PRIMARY KEY(chunk_id, chunk_seq)\n);<\/code><\/pre>\n<p>\nTas noz\u012bm\u0113, ja mums ir j\u0101ieraksta rinda ar \"lielu\" v\u0113rt\u012bbu, <code>data<\/code>, tad re\u0101lais ieraksts notiks <b>ne tikai galvenaj\u0101 tabul\u0101 un t\u0101s PK, bet ar\u012b TOAST un t\u0101s PK<\/b>.<\/p>\n<h4>Samazin\u0101t TOAST ietekmi<\/h4>\n<p>\nBet liel\u0101k\u0101 da\u013ca ierakstu mums tom\u0113r nav tik lieli, <b>8KB b\u016btu j\u0101ietilpst<\/b> \u2014 k\u0101 \u0161o ietaup\u012bt?..<\/p>\n<p>Te mums pal\u012bdz atrib\u016bts <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/12\/storage-toast#STORAGE-TOAST-ONDISK\"><code>STORAGE<\/code><\/a><\/noindex> tabulas kolonn\u0101:<\/p>\n<blockquote>\n<ul>\n<li><b>EXTENDED<\/b> at\u013cauj gan saspiest, gan atsevi\u0161\u0137u glab\u0101\u0161anu. Tas <b>ir standarta variants<\/b> \u013coti daudziem datu tipiem, kas ir sader\u012bgi ar TOAST. Vispirms notiek m\u0113\u0123in\u0101jums veikt saspie\u0161anu, tad \u2014 saglab\u0101\u0161ana \u0101rpus tabulas, ja rinda joproj\u0101m ir p\u0101r\u0101k liela.<\/li>\n<li><b>MAIN<\/b> at\u013cauj saspiest, bet ne atsevi\u0161\u0137u glab\u0101\u0161anu. (Faktiski, atsevi\u0161\u0137a glab\u0101\u0161ana \u0161\u0101dos laukos tom\u0113r tiks veikta, bet tikai <b>k\u0101 ekstrem\u0101ls pas\u0101kums<\/b>, kad nav cita veida, k\u0101 samazin\u0101t rindi\u0146u t\u0101, lai t\u0101 ietilptu lap\u0101.)<\/li>\n<\/ul>\n<\/blockquote>\n<p>Faktiski, tas ir tie\u0161i tas, kas mums nepiecie\u0161ams tekstam \u2014 <b>maksim\u0101li saspiest, un ja nu nevar t\u0101pat, \u2014 izvietot TOAST<\/b>. To var izdar\u012bt tie\u0161i \"gais\u0101\", ar vienu komandu:<\/p>\n<pre><code class=\"sql\">ALTER TABLE rawdata_orig ALTER COLUMN data SET STORAGE MAIN;<\/code><\/pre>\n<p><\/p>\n<h4>K\u0101 nov\u0113rt\u0113t efektu<\/h4>\n<p>\nKop\u0161 katru dienu datu pl\u016bsma main\u0101s, m\u0113s nevaram sal\u012bdzin\u0101t absol\u016bt\u0101s skaitlisk\u0101s v\u0113rt\u012bbas, bet relat\u012bvi jo <b>maz\u0101ku da\u013cu<\/b> m\u0113s ierakst\u012bj\u0101m TOAST \u2014 jo lab\u0101k. Bet \u0161eit ir b\u012bstam\u012bba \u2014 jo liel\u0101ks ir m\u016bsu \"fiziskais\" apjoms katram atsevi\u0161\u0137am ierakstam, jo \"plat\u0101ks\" k\u013c\u016bst indekss, jo t\u0101d\u0113\u013c ir j\u0101p\u0101rkl\u0101j liel\u0101ks skaits datu lapu.<\/p>\n<p>Sekcija <b>pirms izmai\u0146\u0101m<\/b>:<\/p>\n<pre><code class=\"plaintext\">heap  = 37GB (39%)\nTOAST = 54GB (57%)\nPK    =  4GB ( 4%)\n<\/code><\/pre>\n<p>\nSekcija <b>p\u0113c izmai\u0146\u0101m<\/b>:<\/p>\n<pre><code class=\"plaintext\">heap  = 37GB (67%)\nTOAST = 16GB (29%)\nPK    =  2GB ( 4%)<\/code><\/pre>\n<p>\nFaktiski, m\u0113s <b>s\u0101k\u0101m rakst\u012bt TOAST divas reizes ret\u0101k<\/b>, kas atbr\u012bvoja ne tikai disku, bet ar\u012b CPU:<\/p>\n<p><img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/547485eff9c6491ffe4d59e5c81f656d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/6bd3b18146c20959693f961e41fff447.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nPiez\u012bm\u0113\u0161u, ka m\u0113s tagad ar\u012b \"las\u012bt\" disku s\u0101k\u0101m maz\u0101k, ne tikai \"rakst\u012bt\" \u2014 jo, ievietojot ierakstu k\u0101d\u0101 tabul\u0101, ir j\u0101p\u0101rbauda ar\u012b da\u013ca no katra indeksa koka, lai noteiktu t\u0101s turpm\u0101ko poz\u012bciju tajos.<\/p>\n<h2>Kam PostgreSQL 11 ir labs<\/h2>\n<p>\nP\u0113c atjaunin\u0101\u0161anas uz PG11 m\u0113s nol\u0113m\u0101m turpin\u0101t \"uzlabot\" TOAST un piev\u0113r\u0161am uzman\u012bbu tam, ka kop\u0161 \u0161\u012bs versijas ir pieejama konfigur\u0101cijai opcija <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/11\/storage-toast#STORAGE-TOAST-ONDISK\"><code>toast_tuple_target<\/code><\/a><\/noindex>:<\/p>\n<blockquote><p>TOAST apstr\u0101des kods darbojas tikai tad, ja rinda, kas j\u0101uzglab\u0101 tabul\u0101, ir liel\u0101ka par TOAST_TUPLE_THRESHOLD baitiem (parasti tas ir 2 KB). TOAST kods saspiest un\/vai p\u0101rvietot laukus \u0101rpus tabulas, l\u012bdz rindas izm\u0113rs k\u013c\u016bst maz\u0101ks par TOAST_TUPLE_TARGET baitiem (main\u012bgs lielums, parasti ar\u012b 2 KB) vai samazin\u0101t to apjomu vairs nav iesp\u0113jams.<\/p><\/blockquote>\n<p>M\u0113s nol\u0113m\u0101m, ka m\u016bsu dati parasti ir vai nu \"\u013coti \u012bsi\", vai uzreiz \"\u013coti gari\", t\u0101p\u0113c nol\u0113m\u0101m ierobe\u017eoties ar minim\u0101li iesp\u0113jamo v\u0113rt\u012bbu:<\/p>\n<pre><code class=\"sql\">ALTER TABLE rawplan_orig SET (toast_tuple_target = 128);<\/code><\/pre>\n<p>\nApskat\u012bsim, k\u0101 jaun\u0101s iestat\u012bjums ietekm\u0113ja diska slodzi p\u0113c p\u0101rkonfigur\u0113\u0161anas:<\/p>\n<p><img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/ccaa4879e413a566b362d01582eb8c19.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nLabi! Vid\u0113j\u0101 <b>rindas garums uz diska samazin\u0101j\u0101s<\/b> aptuveni 1,5 reizes, un diska \"aiz\u0146em\u0161ana\" \u2014 par 20%! Bet, iesp\u0113jams, tas kaut k\u0101 ietekm\u0113ja CPU?<\/p>\n<p><img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/f7026e5809853d35c6fb7a8376b9f369.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nVismaz slikt\u0101k noteikti nav palicis. Tom\u0113r gr\u016bti spriest, ja pat \u0161\u0101di apjomi joproj\u0101m nevar palielin\u0101t vid\u0113jo CPU slodzi virs <b>5%<\/b>.<\/p>\n<h2>No vietu mai\u0146as summas\u2026 summa main\u0101s!<\/h2>\n<p>\nK\u0101 zin\u0101ms, maznauda kr\u0101j rubli, un pie m\u016bsu uzglab\u0101\u0161anas apjomiem apm\u0113ram <b>10TB\/m\u0113nes\u012b<\/b> pat neliela optimiz\u0101cija var sniegt labu pe\u013c\u0146u. T\u0101p\u0113c m\u0113s piev\u0113rs\u0101m uzman\u012bbu fiziskajai datu strukt\u016brai \u2014 k\u0101 tie\u0161i <b>\"sak\u0101rtoti\" lauki katra ieraksta iek\u0161ien\u0113<\/b> katrai no tabul\u0101m.<\/p>\n<p>Jo <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/postgrespro\/blog\/444536\/\">datu izk\u0101rtojuma d\u0113\u013c<\/a><\/noindex> tas tie\u0161i <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.gitlab.com\/ee\/development\/ordering_table_columns.html\">ietekm\u0113 rezult\u0101t\u0101 ieg\u016bto apjomu.<\/a><\/noindex>:<\/p>\n<blockquote><p>Daudzas arhitekt\u016bras paredz datu izk\u0101rto\u0161anu p\u0113c ma\u0161\u012bnu v\u0101rdu robe\u017e\u0101m. Piem\u0113ram, 32 bitu x86 sist\u0113m\u0101 veseli skait\u013ci (integer tips, aiz\u0146em 4 baitus) tiks izk\u0101rtojami pa 4 baitus v\u0101rdus, k\u0101 ar\u012b dubultas precizit\u0101tes skait\u013ci (double precision, 8 baitus). Un 64 bitu sist\u0113m\u0101 dubult\u0101 v\u0113rt\u012bba tiks izk\u0101rtojama pa 8 baitus v\u0101rdiem. Tas ir v\u0113l viens nesader\u012bbas iemesls.<\/p>\n<p>Lai noregul\u0113tu izm\u0113ru, tabulas rinda ir atkar\u012bga no lauku izvieto\u0161anas sec\u012bbas. Parasti \u0161is efekts nav \u013coti paman\u0101ms, ta\u010du da\u017eos gad\u012bjumos tas var rad\u012bt iev\u0113rojamu izm\u0113ra palielin\u0101jumu. Piem\u0113ram, ja lauki, piem\u0113ram, char(1) un integer, ir pied\u0101v\u0101ti kop\u0101, starp tiem, k\u0101 noteikti, pazud\u012bs 3 baiti.<\/p><\/blockquote>\n<p>\nS\u0101ksim ar sint\u0113tiskaj\u0101m mode\u013ciem:<\/p>\n<pre><code class=\"sql\">SELECT pg_column_size(ROW(\n  '0000-0000-0000-0000-0000-0000-0000-0000'::uuid\n, 0::smallint\n, '2019-01-01'::date\n));\n-- 48 baiti\n\nSELECT pg_column_size(ROW(\n  '2019-01-01'::date\n, '0000-0000-0000-0000-0000-0000-0000-0000'::uuid\n, 0::smallint\n));\n-- 46 baiti<\/code><\/pre>\n<p>\nK\u0101p\u0113c pirmaj\u0101 gad\u012bjum\u0101 ir par p\u0101ris liekiem baitiem? Viss ir vienk\u0101r\u0161i \u2014 <b>2-baitu smallint tiek noregul\u0113ts uz 4-baitu robe\u017eas<\/b> pirms n\u0101kam\u0101 lauka, bet kad tas ir p\u0113d\u0113jais \u2014 nav nek\u0101, ko noregul\u0113t.<\/p>\n<p>Teorij\u0101 \u2014 viss ir labi un lauki var tikt p\u0101rvietoti k\u0101 vien v\u0113las. P\u0101rbaud\u012bsim re\u0101los datus, \u0146emot par pamatu k\u0101du no tabul\u0101m, kuras dienas da\u013ca aiz\u0146em no 10-15GB.<\/p>\n<p>S\u0101kotn\u0113j\u0101 strukt\u016bra:<\/p>\n<pre><code class=\"sql\">CREATE TABLE public.plan_20190220\n(\n-- Manto\u0161ana no tabulas plan:  pack uuid NOT NULL,\n-- Manto\u0161ana no tabulas plan:  recno smallint NOT NULL,\n-- Manto\u0161ana no tabulas plan:  host uuid,\n-- Manto\u0161ana no tabulas plan:  ts timestamp with time zone,\n-- Manto\u0161ana no tabulas plan:  exectime numeric(32,3),\n-- Manto\u0161ana no tabulas plan:  duration numeric(32,3),\n-- Manto\u0161ana no tabulas plan:  bufint bigint,\n-- Manto\u0161ana no tabulas plan:  bufmem bigint,\n-- Manto\u0161ana no tabulas plan:  bufdsk bigint,\n-- Manto\u0161ana no tabulas plan:  apn uuid,\n-- Manto\u0161ana no tabulas plan:  ptr uuid,\n-- Manto\u0161ana no tabulas plan:  dt date,\n  CONSTRAINT plan_20190220_pkey PRIMARY KEY (pack, recno),\n  CONSTRAINT chck_ptr CHECK (ptr IS NOT NULL),\n  CONSTRAINT plan_20190220_dt_check CHECK (dt = '2019-02-20'::date)\n)\nINHERITS (public.plan)<\/code><\/pre>\n<p>\nSekcija p\u0113c kolonnas sec\u012bbas mai\u0146as \u2014 tie\u0161i <b>tie pa\u0161i lauki, tikai cita sec\u012bba<\/b>:<\/p>\n<pre><code class=\"sql\">CREATE TABLE public.plan_20190221\n(\n-- Manto\u0161ana no tabulas plan:  dt date NOT NULL,\n-- Manto\u0161ana no tabulas plan:  ts timestamp with time zone,\n-- Manto\u0161ana no tabulas plan:  pack uuid NOT NULL,\n-- Manto\u0161ana no tabulas plan:  recno smallint NOT NULL,\n-- Manto\u0161ana no tabulas plan:  host uuid,\n-- Manto\u0161ana no tabulas plan:  apn uuid,\n-- Manto\u0161ana no tabulas plan:  ptr uuid,\n-- Manto\u0161ana no tabulas plan:  bufint bigint,\n-- Manto\u0161ana no tabulas plan:  bufmem bigint,\n-- Manto\u0161ana no tabulas plan:  bufdsk bigint,\n-- Manto\u0161ana no tabulas plan:  exectime numeric(32,3),\n-- Manto\u0161ana no tabulas plan:  duration numeric(32,3),\n  CONSTRAINT plan_20190221_pkey PRIMARY KEY (pack, recno),\n  CONSTRAINT chck_ptr CHECK (ptr IS NOT NULL),\n  CONSTRAINT plan_20190221_dt_check CHECK (dt = '2019-02-21'::date)\n)\nINHERITS (public.plan)<\/code><\/pre>\n<p>\nKop\u0113jais sekcijas apjoms tiek noteikts ar \u2018faktiem\u2019 un ir atkar\u012bgs tikai no \u0101r\u0113j\u0101m procesa, t\u0101p\u0113c dal\u012bsim heap izm\u0113ru (<code>pg_relation_size<\/code>) uz ierakstu skaitu taj\u0101 \u2014 t\u0101tad ieg\u016bstam <b>vid\u0113jo re\u0101li saglab\u0101to ierakstu izm\u0113ru<\/b>:<\/p>\n<p><img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/06be2d7d70d223e7678f9a478e4c293f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<b>M\u012bnus 6% apjoma<\/b>, lieliski!<\/p>\n<p>Bet viss, protams, nav tik ro\u017eaini \u2014 jo <b>m\u0113s nevaram main\u012bt lauku k\u0101rt\u012bbu indeksos<\/b>, un t\u0101d\u0113\u013c \u201ekopum\u0101\u201c (<code>pg_total_relation_size<\/code>)\u2026<\/p>\n<p><img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/8beff38e5034fc0d40665b75cb3b3625.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n\u2026 tom\u0113r ar\u012b \u0161eit <b>ietaup\u012bj\u0101m 1.5%<\/b>, neizmainot ne rindi\u0146u koda. Tie\u0161\u0101m!<\/p>\n<p><img decoding=\"async\" alt=\"Ietaup\u0101m naudu lielos apjomos PostgreSQL\" src=\"\/wp-content\/uploads\/2020\/04\/10f4a2151465a38bf45823a5d360302b.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Piez\u012bm\u0113\u0161u, ka iepriek\u0161 min\u0113tais lauku izvietojuma variants \u2014 nav fakts, ka tas ir visoptim\u0101l\u0101kais. Jo da\u017ei laukumu bloki negrib\u0113tos \u201esadrupin\u0101t\u201c jau no est\u0113tiskajiem apsv\u0113rumiem \u2014 piem\u0113ram, p\u0101ris <code>(pack, recno)<\/code>, kas ir PK \u0161ai tabulai.<\/p>\n<p>Kopum\u0101, \u201eminim\u0101l\u0101s\u201c lauku izvietojuma noteik\u0161ana \u2014 ir diezgan vienk\u0101r\u0161a \u201eizm\u0113\u0123in\u0101juma\u201c uzdevums. T\u0101p\u0113c j\u016bs varat uz saviem datiem ieg\u016bt rezult\u0101tus pat lab\u0101kus nek\u0101 mums \u2014 m\u0113\u0123iniet!<br \/>\n<br \/>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/tensor\/blog\/498292\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044f \u0442\u0435\u043c\u0443 \u0437\u0430\u043f\u0438\u0441\u0438 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043f\u043e\u0442\u043e\u043a\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u043e\u0434\u043d\u044f\u0442\u0443\u044e \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435\u0439 \u043f\u0440\u043e \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435, \u0432 \u044d\u0442\u043e\u0439 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0441\u043f\u043e\u0441\u043e\u0431\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u043c\u043e\u0436\u043d\u043e \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u00ab\u0444\u0438\u0437\u0438\u0447\u0435\u0441\u043a\u0438\u0439\u00bb \u0440\u0430\u0437\u043c\u0435\u0440 \u0445\u0440\u0430\u043d\u0438\u043c\u043e\u0433\u043e \u0432 PostgreSQL, \u0438 \u0438\u0445 \u0432\u043b\u0438\u044f\u043d\u0438\u0435 \u043d\u0430 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0441\u0435\u0440\u0432\u0435\u0440\u0430. \u0420\u0435\u0447\u044c \u043f\u043e\u0439\u0434\u0435\u0442 \u043f\u0440\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 TOAST \u0438 \u0432\u044b\u0440\u0430\u0432\u043d\u0438\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u00ab\u0412 \u0441\u0440\u0435\u0434\u043d\u0435\u043c\u00bb \u044d\u0442\u0438 \u0441\u043f\u043e\u0441\u043e\u0431\u044b \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0442 \u0441\u044d\u043a\u043e\u043d\u043e\u043c\u0438\u0442\u044c \u043d\u0435 \u0441\u043b\u0438\u0448\u043a\u043e\u043c \u043c\u043d\u043e\u0433\u043e \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432, \u0437\u0430\u0442\u043e \u2014 \u0432\u043e\u043e\u0431\u0449\u0435 \u0431\u0435\u0437 \u043c\u043e\u0434\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u0438 \u043a\u043e\u0434\u0430 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f. \u041e\u0434\u043d\u0430\u043a\u043e, [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":79040,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-79039","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 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044f \u0442\u0435\u043c\u0443 \u0437\u0430\u043f\u0438\u0441\u0438 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043f\u043e\u0442\u043e\u043a\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u043e\u0434\u043d\u044f\u0442\u0443\u044e \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435\u0439 \u043f\u0440\u043e \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435, \u0432 \u044d\u0442\u043e\u0439 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0441\u043f\u043e\u0441\u043e\u0431\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u043c\u043e\u0436\u043d\u043e.\" \/>\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\/lv\/blog\/administrirovanie\/ekonomim-kopeechku-na-bolshih-obemah-v-postgresql\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\u042d\u043a\u043e\u043d\u043e\u043c\u0438\u043c \u043a\u043e\u043f\u0435\u0435\u0447\u043a\u0443 \u043d\u0430 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043e\u0431\u044a\u0435\u043c\u0430\u0445 \u0432 PostgreSQL | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044f \u0442\u0435\u043c\u0443 \u0437\u0430\u043f\u0438\u0441\u0438 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043f\u043e\u0442\u043e\u043a\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u043e\u0434\u043d\u044f\u0442\u0443\u044e \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435\u0439 \u043f\u0440\u043e \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435, \u0432 \u044d\u0442\u043e\u0439 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0441\u043f\u043e\u0441\u043e\u0431\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u043c\u043e\u0436\u043d\u043e.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/ekonomim-kopeechku-na-bolshih-obemah-v-postgresql\" \/>\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:26+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-23T17:43:26+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\udd47Ietaup\u0101m mazliet naudas uz lieliem apjomiem PostgreSQL | ProHoster","description":"Turpinot t\u0113mu par lielo datu straumju ierakstiem, kas tika uzs\u0101kta iepriek\u0161\u0113j\u0101 rakst\u0101 par sekciju, \u0161aj\u0101 apl\u016bkosim veidus, k\u0101d\u0101m m\u0113s varam.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/ekonomim-kopeechku-na-bolshih-obemah-v-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\u042d\u043a\u043e\u043d\u043e\u043c\u0438\u043c \u043a\u043e\u043f\u0435\u0435\u0447\u043a\u0443 \u043d\u0430 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043e\u0431\u044a\u0435\u043c\u0430\u0445 \u0432 PostgreSQL | ProHoster","og:description":"\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044f \u0442\u0435\u043c\u0443 \u0437\u0430\u043f\u0438\u0441\u0438 \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043f\u043e\u0442\u043e\u043a\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u043e\u0434\u043d\u044f\u0442\u0443\u044e \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435\u0439 \u043f\u0440\u043e \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435, \u0432 \u044d\u0442\u043e\u0439 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0441\u043f\u043e\u0441\u043e\u0431\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u043c\u043e\u0436\u043d\u043e.","og:url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/ekonomim-kopeechku-na-bolshih-obemah-v-postgresql","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:26+00:00","article:modified_time":"2020-04-23T17:43:26+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"79039","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:33","updated":"2022-09-28 06:02:32","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/79039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=79039"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/79039\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media\/79040"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=79039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=79039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=79039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}