Nibe nolwesihlanu olumnandi nonke! Lincinci ixesha eliseleyo phambi kokuba ikhosi iqaliswe , ngoko namhlanje sabelana ngokuguqulelwa kwenye into ebalulekileyo kwisihloko.
Kwinqanaba lophuhliso Kubekho umsebenzi oncomekayo owenziweyo ukuphucula ukwahlulahlula kwetafile. Iitafile zokwahlula - lo ngumsebenzi okhoyo kwi-PostgreSQL ixesha elide, kodwa, ngokuthetha, awuzange ubekho de kube yinguqulo ye-10, apho yaba ngumsebenzi oluncedo kakhulu. Ngaphambili satsho ukuba ilifa letafile kukuphunyezwa kwethu kokwahlulahlula, kwaye oku kuyinyani. Kuphela le ndlela ikunyanzele ukuba wenze uninzi lomsebenzi ngesandla. Umzekelo, ukuba ubufuna ukuba ii-tuples zifakwe kumacandelo ngexesha le-INSERTs, kuya kufuneka uqwalasele izichukumisi ukuba zikwenzele oku. Ukwahlula ngelifa kwakucotha kakhulu kwaye kunzima ukuphuhlisa umsebenzi owongezelelweyo ngaphezulu.
Kwi-PostgreSQL 10, sabona ukuzalwa "kokwahlula-hlula," into eyenzelwe ukusombulula iingxaki ezininzi ezazingenakusonjululwa kusetyenziswa indlela endala yelifa. Oku kukhokelele kwisixhobo esinamandla ngakumbi esivumele ukuba sahlule idatha ngokuthe tye!
Uthelekiso lophawu
I-PostgreSQL 11 yazisa ngeseti enomtsalane yeempawu ezintsha ezinceda ukuphucula ukusebenza kunye nokwenza iitafile ezahlulahluliweyo zicace ngakumbi kwizicelo.
1. Ukusebenzisa iMida eKhethekileyo
2. Yongeza iindawo kuphela
3. Kuphela kwitheyibhile eyohluliweyo ebhekisa kwengahlulwanga
4. Izalathisi maziqulathe zonke iikholamu eziphambili zesahlulelo
5. Izithintelo zecandelo kumacala omabini mazihambelane
Imveliso
Sineendaba ezimnandi nalapha! Indlela entsha yongezwa . Le algorithm entsha inokumisela amacandelo afanelekileyo ngokujonga imeko yombuzo WHERE. I-algorithm yangaphambili, ngokulandelayo, ihlolisise icandelo ngalinye ukuze iqinisekise ukuba ingahlangabezana nemeko WHERE. Oku kubangele ukongezwa kwexesha lokucwangcisa njengoko inani lamacandelo lisanda.
Ku-9.6, kunye nokwahlula ngelifa, ukuhambisa i-tuples kwizahlulo zenziwa ngokubhala umsebenzi wokuxhobisa oqulathe uthotho lweengxelo ze-IF ukufaka i-tuple kwisahlulelo esichanekileyo. Le misebenzi inokucotha kakhulu ukuphumeza. Ngokwahlula okuchazayo okongeziweyo kwinguqulo ye-10, oku kusebenza ngokukhawuleza okukhulu.
Ukusebenzisa itafile edibeneyo kunye nezahlulo ze-100, sinokuvavanya ukusebenza kokulayisha imiqolo yezigidi ezili-10 kwitheyibhile kunye nekholomu ye-1 BIGINT kunye ne-5 INT columns.
Ukusebenza kokubuza le theyibhile ukufumana irekhodi enye enesalathiso kunye nokusebenzisa i-DML ukwenza irekhodi enye (usebenzisa iprosesa enye kuphela):
Apha sinokubona ukuba ukusebenza komsebenzi ngamnye kunyuke kakhulu ukusukela kwi-PG 9.6. Izicelo SELECT jonga ngcono kakhulu, ngakumbi ezo zikwaziyo ukukhuphela ngaphandle izahlulo ezininzi ngexesha locwangciso lombuzo. Oku kuthetha ukuba umcwangcisi unokutsiba umsebenzi omninzi ebekufanele ukuba wenziwe ngaphambili. Umzekelo, iindlela azisakhiwanga amacandelo angeyomfuneko.
isiphelo
Ukwahlulahlula kwetafile kuyaqala ukuba yinto enamandla kakhulu kwiPostgreSQL. Ikuvumela ukuba ubonise idatha kwi-intanethi ngokukhawuleza kwaye uyikhuphe ngaphandle kweintanethi ngaphandle kokulinda ukucotha, ukusebenza okukhulu kwe-DML ukugqibezela.. Oku kukwathetha ukuba idatha ehambelanayo inokugcinwa kunye, okuthetha ukuba idatha oyifunayo inokufumaneka ngokufanelekileyo kakhulu. Uphuculo olwenziwa kule nguqulo ngekhe lwenzeke ngaphandle kwabaphuhlisi, abahlaziyi kunye nabazinikeleyo abasebenza ngokungakhathali kuzo zonke ezi mpawu.
Enkosi kubo bonke! I-PostgreSQL 11 ibonakala imnandi!
Nali inqaku elifutshane kodwa elinomdla kakhulu. Yabelana ngezimvo zakho kwaye ungalibali ukubhalisela , apho iprogram yekhosi iya kucaciswa ngokweenkcukacha.
umthombo: www.habr.com