{"id":184209,"date":"2026-11-10T23:41:15","date_gmt":"2026-11-10T21:41:15","guid":{"rendered":"https:\/\/prohoster.info\/blog\/news\/vypusk-apache-cloudberry-2-2-0-otkrytoj-alternativy-subd-greenplum"},"modified":"2026-11-10T23:41:20","modified_gmt":"2026-11-10T21:41:20","slug":"apache-cloudberry-2-2-0-released-an-open-source-alternative-to-greenplum-dbms","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/apache-cloudberry-2-2-0-released-an-open-source-alternative-to-greenplum-dbms","title":{"rendered":"L\u00ebshimi i Apache Cloudberry 2.2.0, nj\u00eb alternativ\u00eb e hapur ndaj DBMS Greenplum","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>U prezantua versioni i sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave t\u00eb shp\u00ebrndara Apache Cloudberry 2.2.0, q\u00eb vazhdon zhvillimin e kodit t\u00eb hapur t\u00eb sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave Greenplum, e cila u shnd\u00ebrrua nga kompania Broadcom n\u00eb nj\u00eb produkt t\u00eb mbyllur pas blerjes s\u00eb VMware. Projekti aktualisht \u00ebsht\u00eb n\u00eb inkubatorin Apache dhe do t\u00eb kaloj\u00eb n\u00eb list\u00ebn e projekteve kryesore t\u00eb Apache kur infrastruktura dhe p\u00ebrkrahja t\u00eb jen\u00eb gati.<\/p>\n<p>Baza e t\u00eb dh\u00ebnave Cloudberry \u00ebsht\u00eb nj\u00eb redaksion i shp\u00ebrndar\u00eb i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave me kod burimor PostgreSQL, e optimizuar p\u00ebr ekzekutimin e pyetjeve analitike mbi sasi t\u00eb m\u00ebdha t\u00eb dh\u00ebnash (Data Warehouse). P\u00ebr p\u00ebrpunimin paralel t\u00eb t\u00eb dh\u00ebnave p\u00ebrdoret nj\u00eb arkitektur\u00eb masive-paralele (MPP, massively parallel processing), e cila siguron shkall\u00ebzim t\u00eb depozit\u00ebs n\u00eb p\u00ebrmasa petabaitesh p\u00ebrmes ndarjes s\u00eb t\u00eb dh\u00ebnave n\u00eb segmente dhe angazhimit t\u00eb nj\u00eb grumbulli p\u00ebr ruajtjen dhe p\u00ebrpunimin e tyre. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/\"   title=\"server\u00ebsh\" data-wpil-keyword-link=\"linked\">server\u00ebsh<\/a>. <\/p>\n<p>N\u00eb mesin e p\u00ebrmir\u00ebsimeve n\u00eb Apache Cloudberry 2.2.0:<\/p>\n<ul>\n<li class=\"l\"> U transferuan rregullimet e gabimeve, eliminimi i dob\u00ebsive dhe optimizimet nga l\u00ebshimet PostgreSQL 14.4-14.10 (dega Cloudberry 2.x \u00ebsht\u00eb nd\u00ebrtuar mbi kodin burimor t\u00eb PostgreSQL 14).\n<li class=\"l\"> Shtuar gjasht\u00eb shtesa: diskquota, gp_stats_collector, gp_relsizes_stats, reject_partition_fullscan, try_convert dhe yezzey.\n<li class=\"l\"> Shtuar zgjerimi interconnect, q\u00eb ofron numra p\u00ebrmbledh\u00ebs nga protokolli UDPIFC, t\u00eb disponuesh\u00ebm p\u00ebrmes pamjeve gp_interconnect_stats, gp_interconnect_stats_per_segment dhe gp_interconnect_stats_per_host. Zgjerimi mund\u00ebson analizimin e statistikave t\u00eb bashk\u00ebpunimit midis nyjeve p\u00ebrmes k\u00ebrkesave SQL n\u00eb vend t\u00eb analizimit t\u00eb logjeve.\n<li class=\"l\"> N\u00eb optimizuesin ORCA \u00ebsht\u00eb implementuar skanimi i brendsh\u00ebm t\u00eb tabelave n\u00eb m\u00ebnyr\u00eb paralele. Numri i procesor\u00ebve q\u00eb drejtohen paralelisht konfigurohet p\u00ebrmes parametrave max_parallel_workers_per_gather.\n<li class=\"l\"> Siguruar mund\u00ebsia e ekzekutimit paralel t\u00eb operacioneve Full Join dhe Right Join.\n<li class=\"l\"> P\u00ebr k\u00ebrkesat q\u00eb p\u00ebrfshijn\u00eb operacione t\u00eb bashkimit t\u00eb disa tabelave (JOIN), \u00ebsht\u00eb implementuar teknika e optimizimit AQUMV (P\u00ebrgjigje-K\u00ebrkese-P\u00ebrdorim me Pamje t\u00eb Materializuara).\n<li class=\"l\"> Shtuar mb\u00ebshtetje p\u00ebr shp\u00ebrndarjet Rocky Linux 8\/9\/10 dhe Ubuntu 22.04\/24.04. Ndihma p\u00ebr Ubuntu 20.04 \u00ebsht\u00eb nd\u00ebrprer\u00eb.\n<li class=\"l\"> Automatizuar ndihm\u00ebn n\u00eb nd\u00ebrtimin e pakove n\u00eb formate DEB dhe RPM p\u00ebr arkitekturat x86_64 dhe ARM64.\n<li class=\"l\"> Shtuar tabela me statistikat e serverit PXF pxf_stat_activity, si dhe funksionet pxf_cancel_backend dhe pxf_interrupt_backend p\u00ebr ndalimin e k\u00ebrkesave t\u00eb jashtme pa rinisur PXF. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-los-angeles\/\"   title=\"server\u00eb\" data-wpil-keyword-link=\"linked\">server\u00eb<\/a> PXF.\n<li class=\"l\"> Shtuar mb\u00ebshtetje p\u00ebr Java 17.\n<li class=\"l\"> Shtuar utilitarin gpbackman p\u00ebr menaxhimin e kopjeve rezerv\u00eb, si dhe p\u00ebrpunuesin gpbackup_exporter p\u00ebr eksportimin e informacionit mbi kopjet rezerv\u00eb n\u00eb sistemin e monitorimit Prometheus.\n<li class=\"l\"> P\u00ebrgatitur versionin e par\u00eb cloudberry-go-libs, nj\u00eb grup bibliotekash n\u00eb gjuh\u00ebn Go, t\u00eb p\u00ebrdorura n\u00eb Apache Cloudberry.\n<\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=66660\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Apache Cloudberry 2.2.0, \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044e\u0449\u0435\u0439 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0439 \u043a\u043e\u0434\u043e\u0432\u043e\u0439 \u0431\u0430\u0437\u044b \u0421\u0423\u0411\u0414 Greenplum, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0431\u044b\u043b\u0430 \u043f\u0440\u0435\u0432\u0440\u0430\u0449\u0435\u043d\u0430 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Broadcom \u0432 \u0437\u0430\u043a\u0440\u044b\u0442\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442 \u043f\u043e\u0441\u043b\u0435 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u0442\u0435\u043d\u0438\u044f VMware. \u041f\u0440\u043e\u0435\u043a\u0442 \u043f\u043e\u043a\u0430 \u043d\u0430\u0445\u043e\u0434\u0438\u0442\u0441\u044f \u0432 \u0438\u043d\u043a\u0443\u0431\u0430\u0442\u043e\u0440\u0435 Apache \u0438 \u0431\u0443\u0434\u0435\u0442 \u043f\u0435\u0440\u0435\u0432\u0435\u0434\u0451\u043d \u0432 \u0447\u0438\u0441\u043b\u043e \u043f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 Apache \u043f\u043e\u0441\u043b\u0435 \u0433\u043e\u0442\u043e\u0432\u043d\u043e\u0441\u0442\u0438 \u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0438 \u0441\u043e\u043f\u0440\u043e\u0432\u043e\u0436\u0434\u0430\u044e\u0449\u0438\u0445. \u0421\u0423\u0411\u0414 Cloudberry \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0431\u043e\u0439 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0443\u044e \u0440\u0435\u0434\u0430\u043a\u0446\u0438\u044e \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0439 \u0421\u0423\u0411\u0414 PostgreSQL, \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u0443\u044e \u0434\u043b\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-184209","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Apache Cloudberry 2.2.0, \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044e\u0449\u0435\u0439 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0439 \u043a\u043e\u0434\u043e\u0432\u043e\u0439 \u0431\u0430\u0437\u044b \u0421\u0423\u0411\u0414 Greenplum, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0431\u044b\u043b\u0430 \u043f\u0440\u0435\u0432\u0440\u0430\u0449\u0435\u043d\u0430 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Broadcom \u0432 \u0437\u0430\u043a\u0440\u044b\u0442\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442 \u043f\u043e\u0441\u043b\u0435 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u0442\u0435\u043d\u0438\u044f VMware.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Alexander Kovalev\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/news\/apache-cloudberry-2-2-0-released-an-open-source-alternative-to-greenplum-dbms\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a Apache Cloudberry 2.2.0, \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0439 \u0430\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u044b \u0421\u0423\u0411\u0414 Greenplum | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Apache Cloudberry 2.2.0, \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044e\u0449\u0435\u0439 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0439 \u043a\u043e\u0434\u043e\u0432\u043e\u0439 \u0431\u0430\u0437\u044b \u0421\u0423\u0411\u0414 Greenplum, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0431\u044b\u043b\u0430 \u043f\u0440\u0435\u0432\u0440\u0430\u0449\u0435\u043d\u0430 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Broadcom \u0432 \u0437\u0430\u043a\u0440\u044b\u0442\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442 \u043f\u043e\u0441\u043b\u0435 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u0442\u0435\u043d\u0438\u044f VMware.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/news\/apache-cloudberry-2-2-0-released-an-open-source-alternative-to-greenplum-dbms\" \/>\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=\"2026-11-10T21:41:15+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-11-10T21:41:20+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Versioni i Apache Cloudberry 2.2.0, alternativ\u00eb e hapur p\u00ebr sistemin e menaxhimit t\u00eb t\u00eb dh\u00ebnave Greenplum | ProHoster","description":"U prezantua versioni i sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave t\u00eb shp\u00ebrndara Apache Cloudberry 2.2.0, q\u00eb vazhdon zhvillimin e kodit t\u00eb hapur t\u00eb sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave Greenplum, e cila u shnd\u00ebrrua nga kompania Broadcom n\u00eb nj\u00eb produkt t\u00eb mbyllur pas blerjes s\u00eb VMware.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/apache-cloudberry-2-2-0-released-an-open-source-alternative-to-greenplum-dbms","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\u0412\u044b\u043f\u0443\u0441\u043a Apache Cloudberry 2.2.0, \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0439 \u0430\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u044b \u0421\u0423\u0411\u0414 Greenplum | ProHoster","og:description":"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Apache Cloudberry 2.2.0, \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u044e\u0449\u0435\u0439 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0439 \u043a\u043e\u0434\u043e\u0432\u043e\u0439 \u0431\u0430\u0437\u044b \u0421\u0423\u0411\u0414 Greenplum, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0431\u044b\u043b\u0430 \u043f\u0440\u0435\u0432\u0440\u0430\u0449\u0435\u043d\u0430 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Broadcom \u0432 \u0437\u0430\u043a\u0440\u044b\u0442\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442 \u043f\u043e\u0441\u043b\u0435 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u0442\u0435\u043d\u0438\u044f VMware.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/apache-cloudberry-2-2-0-released-an-open-source-alternative-to-greenplum-dbms","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":"2026-11-10T21:41:15+00:00","article:modified_time":"2026-11-10T21:41:20+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/184209","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=184209"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/184209\/revisions"}],"predecessor-version":[{"id":184210,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/184209\/revisions\/184210"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=184209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=184209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=184209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}