Khalani ndi Lachisanu labwino nonse! Patsala nthawi yochepa kuti maphunzirowo ayambe , kotero lero tikugawana kumasulira kwa zinthu zina zothandiza pamutuwu.
Pa chitukuko siteji Pakhala pali ntchito yochititsa chidwi yomwe yachitika pofuna kukonza magawo a tebulo. Matebulo ogawa - iyi ndi ntchito yomwe idakhalapo mu PostgreSQL kwa nthawi yayitali, koma, titero, inalibe mpaka mtundu 10, momwe idakhala yothandiza kwambiri. Tidanenapo kale kuti cholowa cha tebulo ndikukhazikitsa kwathu magawo, ndipo izi ndi zoona. Njira yokhayo inakukakamizani kuti mugwire ntchito zambiri pamanja. Mwachitsanzo, ngati mukufuna kuti ma tuples ayikidwe m'magawo panthawi ya INSERTs, muyenera kukonza zoyambitsa kuti zikuchitireni izi. Kugawa kudzera mu cholowa kunali kochedwa kwambiri komanso kovuta kupanga zina zowonjezera pamwamba pa.
Mu PostgreSQL 10, tidawona kubadwa kwa "declarative partitioning," gawo lomwe lidapangidwa kuti lithetse mavuto ambiri omwe anali osatheka kugwiritsa ntchito njira yakale yolowa. Izi zidapangitsa kuti pakhale chida champhamvu kwambiri chomwe chidatilola kugawa deta mozungulira!
Kufananiza mawonekedwe
PostgreSQL 11 imabweretsa zochititsa chidwi zatsopano zomwe zimathandizira kukonza magwiridwe antchito ndikupanga matebulo ogawidwa kukhala owonekera pamapulogalamu.
1. Kugwiritsa Ntchito Zopatula Zochepetsa
2. Amawonjezera ma node okha
3. Pokhapo pa tebulo logawanika losonyeza lomwe silinagawidwe
4. Ma index ayenera kukhala ndi zigawo zonse zazikulu za magawo
5. Zoletsa za magawo mbali zonse ziwiri ziyenera kufanana
Kukonzekera
Tilinso ndi uthenga wabwino kuno! Njira yatsopano yowonjezeredwa . Algorithm yatsopanoyi imatha kudziwa magawo oyenera poyang'ana momwe amafunsa WHERE. Algorithm yam'mbuyomu, idayang'ananso gawo lililonse kuti liwone ngati lingakwaniritse zomwe zilili WHERE. Izi zinapangitsa kuti pakhale nthawi yowonjezereka yokonzekera pamene chiwerengero cha zigawo chinawonjezeka.
Mu 9.6, ndi kugawa kudzera mu cholowa, kuwongolera ma tuples kukhala magawo kunkachitika polemba choyambitsa chomwe chimakhala ndi mawu angapo a IF kuti muyike tuple mugawo lolondola. Izi zitha kukhala zochedwa kwambiri kuti zichitike. Ndi magawo olengeza omwe awonjezeredwa mu mtundu 10, izi zimagwira ntchito mwachangu kwambiri.
Pogwiritsa ntchito tebulo logawidwa lokhala ndi magawo 100, titha kuwunika momwe ntchito yokweza mizere 10 miliyoni patebulo yokhala ndi 1 BIGINT columns ndi 5 INT columns.
Kagwiritsidwe kakufunsa tebulo ili kuti mupeze mbiri yolondolera ndikuchita DML kuti muwononge mbiri imodzi (pogwiritsa ntchito purosesa imodzi yokha):
Apa titha kuwona kuti magwiridwe antchito aliwonse awonjezeka kwambiri kuyambira PG 9.6. Zopempha SELECT amawoneka bwino kwambiri, makamaka omwe amatha kusiya magawo angapo pokonzekera mafunso. Izi zikutanthauza kuti wokonza mapulani akhoza kudumpha ntchito zambiri zomwe akanayenera kuchita kale. Mwachitsanzo, njira sizimapangidwiranso magawo osafunika.
Pomaliza
Kugawa patebulo kukuyamba kukhala gawo lamphamvu kwambiri mu PostgreSQL. Zimakupatsani mwayi wowonetsa mwachangu zambiri pa intaneti ndikuzichotsa popanda kudikirira pang'onopang'ono, ntchito zazikulu za DML kuti ithe.. Izi zikutanthawuzanso kuti deta yogwirizana ikhoza kusungidwa palimodzi, kutanthauza kuti deta yomwe mukufuna ingapezeke bwino kwambiri. Zosintha zomwe zidapangidwa mumtunduwu sizikanatheka popanda opanga, owunikira komanso ochita ntchito omwe adagwira ntchito molimbika pazinthu zonsezi.
Zikomo kwa onse! PostgreSQL 11 ikuwoneka bwino!
Nayi nkhani yayifupi koma yosangalatsa. Gawani ndemanga zanu ndipo osayiwala kulemba , momwe maphunzirowa adzafotokozedwera mwatsatanetsatane.
Source: www.habr.com