{"id":33872,"date":"2019-10-31T21:55:09","date_gmt":"2019-10-31T18:55:09","guid":{"rendered":"https:\/\/prohoster.info\/blog\/postgresql-11-evolyutsiya-sektsionirovaniya-ot-postgres-9-6-do-postgres-11\/"},"modified":"2019-10-31T21:55:09","modified_gmt":"2019-10-31T18:55:09","slug":"postgresql-11-evolyutsiya-sektsionirovaniya-ot-postgres-9-6-do-postgres-11","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/postgresql-11-evolyutsiya-sektsionirovaniya-ot-postgres-9-6-do-postgres-11","title":{"rendered":"PostgreSQL 11: Evolucioni i sekcioni nga Postgres 9.6 n\u00eb Postgres 11","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

T\u00eb enjten e shk\u00eblqyer p\u00ebr t\u00eb gjith\u00ebve! Po afron koha p\u00ebr fillimin e kursit \u00abBaza t\u00eb dh\u00ebnash relacionale\u00bb<\/a><\/noindex>, prandaj sot po ndajm\u00eb p\u00ebrkthimin e nj\u00eb materiali tjet\u00ebr t\u00eb dobish\u00ebm mbi tem\u00ebn.<\/p>\n

N\u00eb procesin e zhvillimit PostgreSQL 11<\/a><\/noindex> u b\u00eb nj\u00eb pun\u00eb mbres\u00ebl\u00ebn\u00ebse p\u00ebr p\u00ebrmir\u00ebsimin e seksionimit t\u00eb tabelave. Seksionimi i tabelave<\/b> \u2014 \u00ebsht\u00eb nj\u00eb funksion q\u00eb ka ekzistuar n\u00eb PostgreSQL p\u00ebr nj\u00eb periudh\u00eb t\u00eb gjat\u00eb, por n\u00eb thelb nuk ka pasur vler\u00eb deri n\u00eb versionin 10, ku u b\u00eb nj\u00eb funksion shum\u00eb i dobish\u00ebm. M\u00eb par\u00eb kishim deklaruar se trash\u00ebgimia e tabelave \u00ebsht\u00eb implementimi yn\u00eb i seksionimit, dhe kjo \u00ebsht\u00eb e v\u00ebrtet\u00eb. Vet\u00ebm ky metod\u00eb ju detyronte t\u00eb b\u00ebnit shumic\u00ebn e pun\u00ebs manualisht. P\u00ebr shembull, n\u00ebse d\u00ebshironit q\u00eb regjistrimet t\u00eb vendoseshin n\u00eb seksione gjat\u00eb INSERT-it, duhej t\u00eb konfiguroni trigger-a q\u00eb ta b\u00ebnin k\u00ebt\u00eb p\u00ebr ju. Seksionimi me trash\u00ebgimi ishte shum\u00eb i ngadalt\u00eb dhe i nd\u00ebrlikuar p\u00ebr t\u00eb zhvilluar funksione shtes\u00eb mbi t\u00eb.<\/a><\/noindex><\/p>\n

N\u00eb PostgreSQL 10 pam\u00eb lindjen e \"seksionimit deklarativ\" \u2014 nj\u00eb tipar i krijuar p\u00ebr t\u00eb zgjidhur shum\u00eb probleme q\u00eb ishin t\u00eb pazgjidhshme me metod\u00ebn e vjet\u00ebr t\u00eb trash\u00ebgimis\u00eb. Kjo solli n\u00eb jet\u00eb nj\u00eb mjet shum\u00eb m\u00eb t\u00eb fuqish\u00ebm q\u00eb na lejon t\u00eb ndajm\u00eb t\u00eb dh\u00ebnat horizontalisht!<\/p>\n

Krahasimi i tipareve<\/b><\/p>\n

N\u00eb PostgreSQL 11 u prezantua nj\u00eb set mbres\u00ebl\u00ebn\u00ebs i tipareve t\u00eb reja q\u00eb ndihmojn\u00eb n\u00eb rritjen e efikasitetit dhe e b\u00ebjn\u00eb tabelat e seksionuara m\u00eb t\u00eb qarta p\u00ebr aplikacionet.<\/p>\n

\"PostgreSQL
\n\"PostgreSQL
\n\"PostgreSQL
\n1. Duke p\u00ebrdorur p\u00ebrjashtime kufizuese
\n2. Shton vet\u00ebm nodet
\n3. Vet\u00ebm p\u00ebr tabelat e seksionuara, q\u00eb referohen n\u00eb ato jo-seksionuara
\n4. Indekset duhet t\u00eb p\u00ebrfshijn\u00eb t\u00eb gjitha kolonat kryesore t\u00eb seksionit
\n5. Kufizimi mbi seksionin nga t\u00eb dyja an\u00ebt duhet t\u00eb p\u00ebrputhen<\/i><\/p>\n

Performanca<\/b><\/p>\n

K\u00ebtu gjithashtu kemi disa lajme t\u00eb mira! Nj\u00eb metod\u00eb e re \u00ebsht\u00eb shtuar p\u00ebr fshirjen e seksioneve<\/a><\/noindex>. Ky algorit\u00ebm i ri mund t\u00eb identifikoj\u00eb seksionet e duhura duke shqyrtuar kushtin e k\u00ebrkes\u00ebs KU<\/code>. Algoritmi i m\u00ebparsh\u00ebm, nga ana tjet\u00ebr, kontrollonte \u00e7do seksion p\u00ebr t\u00eb p\u00ebrcaktuar n\u00ebse mund t\u00eb p\u00ebrputhej me kushtin KU<\/code>. Kjo \u00e7onte n\u00eb nj\u00eb rritje t\u00eb konsiderueshme t\u00eb koh\u00ebs s\u00eb planifikimit me rritjen e numrit t\u00eb seksioneve.<\/p>\n

N\u00eb versionin 9.6, me seksionimin p\u00ebrmes trash\u00ebgimis\u00eb, rrug\u00ebzgjidhja e tupleve n\u00eb seksion zakonisht b\u00ebhej duke shkruar nj\u00eb funksion trigger, i cili p\u00ebrmbante nj\u00eb seri operacionesh IF p\u00ebr t\u00eb inseruar tuple n\u00eb seksionin e duhur. K\u00ebto funksione mund t\u00eb ishin shum\u00eb t\u00eb ngadalta gjat\u00eb ekzekutimit. Me seksionimin deklarativ, t\u00eb shtuar n\u00eb versionin 10, kjo filloi t\u00eb punonte shum\u00eb m\u00eb shpejt.<\/p>\n

Duke p\u00ebrdorur nj\u00eb tabel\u00eb t\u00eb seksionuar me 100 seksione, ne mund t\u00eb vler\u00ebsojm\u00eb performanc\u00ebn e ngarkes\u00ebs s\u00eb 10 milion rreshtave n\u00eb nj\u00eb tabel\u00eb nga 1 kolon\u00eb BIGINT dhe 5 kolona INT.<\/p>\n

\"PostgreSQL
\n
\nPerformanca e k\u00ebrkes\u00ebs p\u00ebr k\u00ebt\u00eb tabel\u00eb p\u00ebr t\u00eb gjetur nj\u00eb regjist\u00ebr t\u00eb indeksuar dhe p\u00ebr t\u00eb kryer DML p\u00ebr t\u00eb manipuluar nj\u00eb regjist\u00ebr (duke p\u00ebrdorur vet\u00ebm 1 procesor):<\/p>\n

\"PostgreSQL
\n
\nK\u00ebtu shohim se performanca e \u00e7do operacioni u rrit ndjesh\u00ebm pas PG 9.6. K\u00ebrkesat SELECT<\/code> duken shum\u00eb m\u00eb mir\u00eb, sidomos ato q\u00eb jan\u00eb n\u00eb gjendje t\u00eb p\u00ebrjashtojn\u00eb shum\u00eb seksione gjat\u00eb planifikimit t\u00eb k\u00ebrkesave. Kjo do t\u00eb thot\u00eb q\u00eb planifikuesi mund t\u00eb anashkaloj\u00eb nj\u00eb pjes\u00eb t\u00eb madhe t\u00eb pun\u00ebs q\u00eb duhej t\u00eb b\u00ebnte m\u00eb par\u00eb. P\u00ebr shembull, nuk nd\u00ebrtohen m\u00eb rrug\u00eb p\u00ebr seksione t\u00eb panevojshme.<\/p>\n

P\u00ebrfundim<\/b><\/p>\n

Seksionimi i tabelave po fillon t\u00eb b\u00ebhet nj\u00eb funksion shum\u00eb t\u00eb fuqish\u00ebm n\u00eb PostgreSQL. Ai lejon shfaqjen e shpejt\u00eb t\u00eb t\u00eb dh\u00ebnave online dhe kalimin e tyre n\u00eb offline, pa pritur p\u00ebrfundimin e operacioneve t\u00eb ngadalta masive t\u00eb DML.<\/b>. Kjo gjithashtu do t\u00eb thot\u00eb se t\u00eb dh\u00ebnat e lidhura mund t\u00eb ruhen s\u00eb bashku, pra, t\u00eb dh\u00ebnat e k\u00ebrkuara mund t\u00eb accesohen shum\u00eb m\u00eb efikas. P\u00ebrmir\u00ebsimet e b\u00ebra n\u00eb k\u00ebt\u00eb version nuk do ishin t\u00eb mundshme pa zhvilluesit, rishikuesit dhe komitator\u00ebt q\u00eb punuan pa pushim mbi t\u00eb gjitha k\u00ebto ve\u00e7ori.
\nFaleminderit t\u00eb gjith\u00ebve! PostgreSQL 11 duket thjesht fantastike!<\/b><\/p>\n

Ja nj\u00eb artikull i shkurt\u00ebr, por mjaft interesant. Ndani komentet tuaja dhe mos harroni t\u00eb regjistroheni p\u00ebr dit\u00ebn e hapur<\/a><\/noindex>, ku do t\u00eb p\u00ebrshkruhet n\u00eb detaje programi i kursit.
\n
Burimi: habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041e\u0442\u043b\u0438\u0447\u043d\u043e\u0439 \u0432\u0441\u0435\u043c \u043f\u044f\u0442\u043d\u0438\u0446\u044b! \u0412\u0441\u0435 \u043c\u0435\u043d\u044c\u0448\u0435 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u043e\u0441\u0442\u0430\u0435\u0442\u0441\u044f \u0434\u043e \u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u043a\u0443\u0440\u0441\u0430 \u00ab\u0420\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0435 \u0421\u0423\u0411\u0414\u00bb, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0441\u0435\u0433\u043e\u0434\u043d\u044f \u0434\u0435\u043b\u0438\u043c\u0441\u044f \u043f\u0435\u0440\u0435\u0432\u043e\u0434\u043e\u043c \u0435\u0449\u0435 \u043e\u0434\u043d\u043e\u0433\u043e \u043f\u043e\u043b\u0435\u0437\u043d\u043e\u0433\u043e \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u0430 \u043f\u043e \u0442\u0435\u043c\u0435. \u0412 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0435 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 PostgreSQL 11 \u0431\u044b\u043b\u0430 \u043f\u0440\u043e\u0434\u0435\u043b\u0430\u043d\u0430 \u0432\u043f\u0435\u0447\u0430\u0442\u043b\u044f\u044e\u0449\u0430\u044f \u0440\u0430\u0431\u043e\u0442\u0430 \u043f\u043e \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044e \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446. \u0421\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u2014 \u044d\u0442\u043e \u0444\u0443\u043d\u043a\u0446\u0438\u044f, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043b\u0430 \u0432 PostgreSQL \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0434\u043e\u043b\u0433\u043e\u0435 \u0432\u0440\u0435\u043c\u044f, \u043d\u043e \u0435\u0435, \u0435\u0441\u043b\u0438 \u043c\u043e\u0436\u043d\u043e \u0442\u0430\u043a \u0432\u044b\u0440\u0430\u0437\u0438\u0442\u044c\u0441\u044f, \u043f\u043e \u0441\u0443\u0442\u0438 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":25538,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-33872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47PostgreSQL 11: Evolucioni i seksionimit nga Postgres 9.6 deri n\u00eb Postgres 11 | ProHoster","description":"T\u00eb gjith\u00eb nj\u00eb t\u00eb premte t\u00eb mrekullueshme!","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/postgresql-11-evolyutsiya-sektsionirovaniya-ot-postgres-9-6-do-postgres-11","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\udd47PostgreSQL 11: \u042d\u0432\u043e\u043b\u044e\u0446\u0438\u044f \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u0442 Postgres 9.6 \u0434\u043e Postgres 11 | ProHoster","og:description":"\u041e\u0442\u043b\u0438\u0447\u043d\u043e\u0439 \u0432\u0441\u0435\u043c \u043f\u044f\u0442\u043d\u0438\u0446\u044b!","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/postgresql-11-evolyutsiya-sektsionirovaniya-ot-postgres-9-6-do-postgres-11","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":"2019-10-31T18:55:09+00:00","article:modified_time":"2019-10-31T18:55:09+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"33872","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":"2026-01-21 17:02:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 02:32:26","updated":"2026-01-21 17:02:19","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\/33872","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=33872"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/33872\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/25538"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=33872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=33872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=33872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}