Nibe noLwesihlanu oluhle nonke! Sincane isikhathi esisele ngaphambi kokuthi kuqalwe isifundo , ngakho namuhla sabelana ngokuhunyushwa kokunye okuwusizo ngesihloko.
Esiteji sokuthuthuka Kube nomsebenzi oncomekayo owenziwe ukuthuthukisa ukwahlukanisa amathebula. Amathebula okuhlukanisa - lona umsebenzi owawukhona ku-PostgreSQL isikhathi eside, kodwa wona, ngomqondo ongokomfanekiso, wawungekho kwaze kwaba yinguqulo 10, lapho yaba umsebenzi owusizo kakhulu. Ngaphambilini sasho ukuthi ifa letafula liwukusebenzisa kwethu ukwahlukanisa, futhi lokhu kuyiqiniso. Yile ndlela kuphela ekuphoqe ukuthi wenze umsebenzi omningi mathupha. Isibonelo, uma ubufuna ama-tuples afakwe ezigabeni ngesikhathi so-INSERTs, kuzomele ulungiselele izibangeli ukuze zikwenzele lokhu. Ukwehlukanisa ngokusebenzisa ifa bekuhamba kancane futhi kunzima ukuthuthukisa ukusebenza okwengeziwe ngaphezulu.
Ku-PostgreSQL 10, sibone ukuzalwa βkokwahlukanisa okumemezelayo,β isici esiklanyelwe ukuxazulula izinkinga eziningi ebezingaxazululeki kusetshenziswa indlela endala yefa. Lokhu kuholele ethuluzini elinamandla kakhulu elisivumele ukuthi sihlukanise idatha ngokuvundlile!
Ukuqhathaniswa kwesici
I-PostgreSQL 11 yethula isethi ehlaba umxhwele yezici ezintsha ezisiza ukuthuthukisa ukusebenza nokwenza amathebula ahlukanisiwe abe sobala kakhudlwana ezinhlelweni zokusebenza.
1. Ukusebenzisa Okuhlukile Okukhawulayo
2. Yengeza amanodi kuphela
3. Okwetafula elihlukanisiwe kuphela elibhekisela kwelingahlukanisiwe
4. Izinkomba kufanele zibe nawo wonke amakholomu ayinhloko we-partition
5. Imikhawulo yesigaba nhlangothi zombili kumele ifane
Ukukhiqiza
Sinezindaba ezinhle nalapha! Indlela entsha yengeziwe . Le algorithm entsha inganquma izigaba ezifanele ngokubheka isimo sombuzo WHERE. I-algorithm yangaphambilini, yona, ihlole isigaba ngasinye ukuze sinqume ukuthi singahlangabezana nalesi simo WHERE. Lokhu kubangele ukwanda okwengeziwe kwesikhathi sokuhlela njengoba inani lezigaba landa.
Ku-9.6, ngokuhlukaniswa ngefa, ukuhambisa ama-tuples abe yizingxenye ngokuvamile kwakwenziwa ngokubhala umsebenzi wokucupha oqukethe uchungechunge lwezitatimende ze-IF ukuze kufakwe i-tuple engxenyeni efanele. Le misebenzi ingase yephuze kakhulu ukuze iqalise. Ngokuhlukaniswa okumemezelayo kwengezwe kunguqulo 10, lokhu kusebenza ngokushesha okukhulu.
Sisebenzisa ithebula elihlukanisiwe elinama-partitions angu-100, singahlola ukusebenza kokulayisha imigqa eyizigidi ezingu-10 kuthebula elinekholomu engu-1 BIGINT namakholomu angu-5 INT.
Ukusebenza kokubuza leli thebula ukuze uthole irekhodi elilodwa elinenkomba nokusebenzisa i-DML ukuze ulawule irekhodi elilodwa (usebenzisa iphrosesa engu-1 kuphela):
Lapha singabona ukuthi ukusebenza komsebenzi ngamunye kukhuphuke kakhulu kusukela ku-PG 9.6. Izicelo SELECT zibukeka zingcono kakhulu, ikakhulukazi lezo ezikwazi ukukhipha ama-partitions amaningi ngesikhathi sokuhlela imibuzo. Lokhu kusho ukuthi umhleli angeqa umsebenzi omningi obekufanele ngabe wenziwe ngaphambilini. Isibonelo, izindlela azisakhelwe izigaba ezingadingekile.
isiphetho
Ukuhlukaniswa kwethebula sekuqala ukuba isici esinamandla kakhulu ku-PostgreSQL. Ikuvumela ukuthi ubonise ngokushesha idatha ku-inthanethi futhi uyeke ungaxhunyiwe ku-inthanethi ngaphandle kokulinda ukusebenza okuhamba kancane, okukhulu kwe-DML ukuthi kuqedwe.. Lokhu kusho nokuthi idatha ehlobene ingagcinwa ndawonye, ββokusho ukuthi idatha oyidingayo ingafinyelelwa kahle kakhulu. Ukuthuthukiswa okwenziwe kule nguqulo bekungeke kwenzeke ngaphandle konjiniyela, ababuyekezi kanye nabasebenza ngokuzikhandla kuzo zonke lezi zici.
Siyabonga kubo bonke! I-PostgreSQL 11 ibukeka imnandi!
Nansi indatshana emfushane kodwa ethokozisayo. Yabelana ngamazwana akho futhi ungakhohlwa ukubhalisela , lapho uhlelo lwezifundo luzochazwa ngokuningiliziwe.
Source: www.habr.com