{"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 secionimit nga Postgres 9.6 deri n\u00eb Postgres 11","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

T\u00eb gjitha t\u00eb premteve t\u00eb shk\u00eblqyera! Po i ka mbetur gjithnj\u00eb e m\u00eb pak koh\u00eb deri n\u00eb lancimin e kursit \u00abSistemet e Menaxhimit t\u00eb t\u00eb Dh\u00ebnave Relacionale\u00bb<\/a><\/noindex>, prandaj sot po ndajem p\u00ebrkthimin e nj\u00eb materiali tjet\u00ebr t\u00eb dobish\u00ebm mbi k\u00ebt\u00eb tem\u00eb.<\/p>\n

Gjat\u00eb zhvillimit PostgreSQL 11<\/a><\/noindex> \u00ebsht\u00eb b\u00ebr\u00eb nj\u00eb pun\u00eb mbres\u00ebl\u00ebn\u00ebse p\u00ebr p\u00ebrmir\u00ebsimin e sekcionimit t\u00eb tabelave. Sekcionimi i tabelave<\/b> \u2014 \u00ebsht\u00eb nj\u00eb funksion q\u00eb ka ekzistuar n\u00eb PostgreSQL p\u00ebr nj\u00eb koh\u00eb t\u00eb gjat\u00eb, por, n\u00ebse mund t\u00eb shprehem ashtu, n\u00eb esenc\u00eb nuk ka qen\u00eb i pranish\u00ebm deri n\u00eb versionin 10, kur u b\u00eb nj\u00eb funksion shum\u00eb i dobish\u00ebm. M\u00eb par\u00eb ne kemi deklaruar se trash\u00ebgimia e tabelave \u00ebsht\u00eb realizimi yn\u00eb i sekcionimit, dhe kjo \u00ebsht\u00eb e v\u00ebrtet\u00eb. Vet\u00ebm se ky metod\u00eb ju detyronte t\u00eb b\u00ebnit shumic\u00ebn e pun\u00ebs manualisht. P\u00ebr shembull, n\u00ebse donit q\u00eb rreshtat t\u00eb futeshin n\u00eb seksione gjat\u00eb INSERT-imeve, duhej t\u00eb konfiguroni triggere p\u00ebr ta b\u00ebr\u00eb k\u00ebt\u00eb p\u00ebr ju. Sekcionimi p\u00ebrmes trash\u00ebgimis\u00eb ishte shum\u00eb i ngadalsh\u00ebm dhe i komplikuar p\u00ebr t\u00eb zhvilluar funksione t\u00eb tjera mbi t\u00eb.<\/a><\/noindex><\/p>\n

N\u00eb PostgreSQL 10 ne pam\u00eb lindjen e \"sekcionimit deklarativ\" \u2014 nj\u00eb tipar i destinuar p\u00ebr t\u00eb zgjidhur shum\u00eb probleme q\u00eb ishin t\u00eb pazgjidhshme me p\u00ebrdorimin e metod\u00ebs s\u00eb vjet\u00ebr me trash\u00ebgimi. Kjo \u00e7oi n\u00eb krijimin e nj\u00eb instrumenti shum\u00eb m\u00eb t\u00eb fuqish\u00ebm q\u00eb na lejon t\u00eb ndahen t\u00eb dh\u00ebnat horizontalisht!<\/p>\n

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

N\u00eb PostgreSQL 11 u shfaq nj\u00eb grup mbres\u00ebl\u00ebn\u00ebs i karakteristikave t\u00eb reja q\u00eb ndihmojn\u00eb n\u00eb rritjen e performanc\u00ebs dhe e b\u00ebjn\u00eb tabelat e sekcionuara m\u00eb t\u00eb qarta p\u00ebr aplikacionet.<\/p>\n

\"PostgreSQL
\n\"PostgreSQL
\n\"PostgreSQL
\n1. P\u00ebrdorimi i p\u00ebrjashtimeve kufizuese
\n2. Shtimi vet\u00ebm i nod\u00ebve
\n3. Vet\u00ebm p\u00ebr tabelat e sekcionuara, q\u00eb referohen n\u00eb tabelat jo t\u00eb sekcionuara
\n4. Indekset duhet t\u00eb p\u00ebrmbajn\u00eb t\u00eb gjitha kolonat kryesore t\u00eb seksionit
\n5. Kufizimi i seksionit nga t\u00eb dy an\u00ebt duhet t\u00eb p\u00ebrputhet<\/i><\/p>\n

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

K\u00ebtu kemi edhe lajm t\u00eb mir\u00eb! \u00cbsht\u00eb shtuar nj\u00eb metod\u00eb e re p\u00ebr fshirjen e seksioneve<\/a><\/noindex>. Ky algorit\u00ebm i ri mund t\u00eb identifikoj\u00eb seksionet e p\u00ebrshtatshme duke shqyrtuar kushtin e k\u00ebrkes\u00ebs WHERE<\/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 WHERE<\/code>. Kjo shkaktonte nj\u00eb rritje t\u00eb koh\u00ebs s\u00eb planifikimit nd\u00ebrsa rritej numri i seksioneve.<\/p>\n

N\u00eb 9.6, me sekcionimin p\u00ebrmes trash\u00ebgimis\u00eb, rrug\u00ebtimi i rreshtave n\u00eb seksione zakonisht b\u00ebhej p\u00ebrmes shkruarjes s\u00eb nj\u00eb funksioni trigger q\u00eb p\u00ebrmbante nj\u00eb seri operator\u00ebsh IF p\u00ebr t\u00eb futur rreshtin n\u00eb seksionin e duhur. K\u00ebto funksione mund t\u00eb ishin shum\u00eb t\u00eb ngadalta gjat\u00eb ekzekutimit. Me sekcionimin deklarativ, i shtuar n\u00eb versionin 10, kjo filloi t\u00eb funksiononte shum\u00eb m\u00eb shpejt.<\/p>\n

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

\"PostgreSQL
\n
\nPerformanca e k\u00ebrkes\u00ebs ndaj k\u00ebsaj tabele p\u00ebr t\u00eb gjetur nj\u00eb regjistrim t\u00eb indekseve dhe p\u00ebr t\u00eb realizuar DML p\u00ebr t\u00eb manipuluar nj\u00eb regjistrim (duke p\u00ebrdorur vet\u00ebm 1 procesor):<\/p>\n

\"PostgreSQL
\n
\nK\u00ebtu shohim se performanca e \u00e7do operacioni \u00ebsht\u00eb rritur ndjesh\u00ebm pas PG 9.6. K\u00ebrkesat SELECT<\/code> duken shum\u00eb m\u00eb mir\u00eb, ve\u00e7an\u00ebrisht 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 se planifikuesi mund t\u00eb shmang\u00eb nj\u00eb pjes\u00eb t\u00eb madhe t\u00eb pun\u00ebs q\u00eb duhet t\u00eb kishte b\u00ebr\u00eb m\u00eb par\u00eb. P\u00ebr shembull, nuk ndodhin m\u00eb nd\u00ebrtimi i rrug\u00ebve p\u00ebr seksione q\u00eb nuk jan\u00eb t\u00eb nevojshme.<\/p>\n

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

Sekcionimi i tabelave 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 n\u00eb offline, pa pritur p\u00ebr p\u00ebrfundimin e operacioneve t\u00eb ngadalta DML<\/b>. Kjo do t\u00eb thot\u00eb gjithashtu se t\u00eb dh\u00ebnat e lidhura mund t\u00eb ruhen s\u00eb bashku, duke e b\u00ebr\u00eb shum\u00eb m\u00eb t\u00eb efektshme qasjen n\u00eb t\u00eb dh\u00ebnat e nevojshme. P\u00ebrmir\u00ebsimet e b\u00ebra n\u00eb k\u00ebt\u00eb version nuk do t\u00eb ishin t\u00eb mundura pa zhvilluesit, rishikuesit dhe komitet\u00ebt q\u00eb punuan pa u lodhur mbi t\u00eb gjitha k\u00ebto karakteristika.
\nFaleminderit atyre t\u00eb gjith\u00eb! 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 n\u00eb dit\u00ebn e hapur<\/a><\/noindex>, n\u00eb kuad\u00ebr t\u00eb cilit 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 sekcionimit nga Postgres 9.6 n\u00eb Postgres 11 | ProHoster","description":"T\u00eb gjitha t\u00eb premteve t\u00eb shk\u00eblqyera! Po i ka mbetur gjithnj\u00eb e m\u00eb pak koh\u00eb deri n\u00eb lancimin e kursit \"Sistemet e Menaxhimit t\u00eb Marr\u00ebdh\u00ebnieve\", prandaj sot po ndajem p\u00ebrkthimin e nj\u00eb materiali tjet\u00ebr t\u00eb dobish\u00ebm mbi k\u00ebt\u00eb tem\u00eb. Gjat\u00eb zhvillimit t\u00eb PostgreSQL 11 \u00ebsht\u00eb b\u00ebr\u00eb nj\u00eb pun\u00eb mbres\u00ebl\u00ebn\u00ebse p\u00ebr p\u00ebrmir\u00ebsimin e sekcionimit t\u00eb tabelave. Sekcionimi i tabelave \u00ebsht\u00eb nj\u00eb funksion q\u00eb ka ekzistuar n\u00eb PostgreSQL p\u00ebr nj\u00eb koh\u00eb t\u00eb gjat\u00eb, por, n\u00ebse mund t\u00eb shprehem ashtu, n\u00eb esenc\u00eb","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! \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","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}]}}