PostgreSQL 11: Juyin Rarrabuwa daga Postgres 9.6 zuwa Postgres 11

Barka da juma'a kowa da kowa! Kadan kuma kaɗan ya rage kafin ƙaddamar da kwas ɗin "Relational DBMS", don haka a yau muna raba fassarar wani abu mai amfani akan batun.

A mataki na ci gaba PostgreSQL 11 An yi wasu ayyuka masu ban sha'awa don inganta rabon tebur. Tebur masu rarrabawa - wannan aiki ne da ya wanzu a cikin PostgreSQL na dogon lokaci, amma shi, don yin magana, da gaske bai wanzu ba sai sigar 10, wanda ya zama aiki mai matukar amfani. A baya mun bayyana cewa gadon tebur shine aiwatar da rabonmu, kuma wannan gaskiya ne. Wannan hanya ce kawai ta tilasta muku yin yawancin aikin da hannu. Misali, idan kuna son a saka tuples cikin sassa yayin INSERTs, dole ne ku saita abubuwan jan hankali don yin hakan a gare ku. Rarraba ta hanyar gado yana da sannu a hankali kuma yana da wahalar haɓaka ƙarin ayyuka a saman.

A cikin PostgreSQL 10, mun ga haihuwar “bangare na shela,” fasalin da aka tsara don magance matsaloli da yawa waɗanda ba za a iya warware su ta amfani da tsohuwar hanyar gado. Wannan ya haifar da kayan aiki mafi ƙarfi wanda ya ba mu damar raba bayanai a kwance!

Kwatancen fasali

PostgreSQL 11 yana gabatar da saiti mai ban sha'awa na sabbin fasalulluka waɗanda ke taimakawa haɓaka aiki da kuma sanya allunan da aka raba su zama bayyananne ga aikace-aikace.

1. Amfani da Iyakance Keɓancewa
2. Yana ƙara nodes kawai
3. Sai kawai don tebur da aka raba da ke yin nuni ga wanda ba a raba shi ba
4. Fihirisa dole ne ya ƙunshi dukkan ginshiƙan maɓalli na ɓangaren
5. Dole ne ƙuntatawa sashe a bangarorin biyu su dace

Yawan aiki

Muna da albishir a nan kuma! An ƙara sabuwar hanya share sassa. Wannan sabon algorithm na iya ƙayyade sassan da suka dace ta hanyar duba yanayin tambaya WHERE. Algorithm na baya, bi da bi, ya duba kowane sashe don tantance ko zai iya cika yanayin WHERE. Wannan ya haifar da ƙarin haɓaka lokacin tsarawa yayin da adadin sassan ya karu.

A cikin 9.6, tare da rarrabuwa ta hanyar gado, tura tuples zuwa ɓangarorin yawanci ana yin su ta hanyar rubuta aikin faɗakarwa wanda ke ɗauke da jerin kalamai na IF don saka tuple cikin daidaitaccen bangare. Waɗannan ayyuka na iya yin jinkirin aiwatarwa. Tare da rarrabuwar da aka ƙara a cikin sigar 10, wannan yana aiki da sauri.

Yin amfani da teburin da aka raba tare da ɓangarori 100, za mu iya kimanta aikin lodin layuka miliyan 10 a cikin tebur mai ginshiƙi 1 BIGINT da ginshiƙan INT 5.

Ayyukan tambayar wannan tebur don nemo rikodin ƙididdiga guda ɗaya kuma aiwatar da DML don sarrafa rikodin guda ɗaya (ta amfani da processor 1 kawai):

Anan zamu iya ganin cewa aikin kowane aiki ya karu sosai tun daga PG 9.6. Bukatu SELECT suna da kyau sosai, musamman waɗanda ke da ikon keɓance ɓangarori da yawa yayin shirin tambaya. Wannan yana nufin cewa mai tsara jadawalin zai iya tsallake ayyukan da ya kamata ya yi a baya. Misali, ba a sake gina hanyoyi don sassan da ba dole ba.

ƙarshe

Rarraba tebur ya fara zama fasali mai ƙarfi a cikin PostgreSQL. Yana ba ku damar nuna bayanai cikin sauri akan layi kuma ɗauka ta layi ba tare da jira jinkirin, manyan ayyukan DML don kammala ba.. Wannan kuma yana nufin ana iya adana bayanan da ke da alaƙa tare, ma'ana za a iya samun damar bayanan da kuke buƙata sosai. Abubuwan haɓakawa da aka yi a cikin wannan sigar ba za su yiyu ba ba tare da masu haɓakawa, masu bita da masu ba da gudummawa ba waɗanda suka yi aiki tuƙuru akan duk waɗannan fasalulluka.
Godiya gare su duka! PostgreSQL 11 yayi kyau!

Ga irin wannan ɗan gajeren labari amma mai ban sha'awa. Raba ra'ayoyin ku kuma kar ku manta da yin rajista don Ranar Budewa, wanda a cikinsa za a bayyana tsarin kwas dalla-dalla.

source: www.habr.com