I-PostgreSQL uhlelo lokuphatha i-database oluqondiswe entweni futhi imahhala, ikhishwe ngaphansi kwelayisense lePostgreSQL, efana neBSD noma iMIT.
Njengamanye amaphrojekthi amaningi avulekile, Ukuthuthukiswa kwePostgreSQL akuphethwe yinkampani eyodwa noma umuntu, kepha kwenziwa ngumphakathi wabathuthukisi abasebenza ngokuzidela, ngokuzidela, mahhala noma ngokusekelwa yizinhlangano zezohwebo.
Ezinye zezici zayo eziyinhloko yilezi:
Ababekhona kakhulu
Ngohlelo olubizwa nge-MVCC (Multiversion Concurrent Access, ngesifinyezo sayo esiNgisini) PostgreSQL ivumela ukuthi ngenkathi inqubo eyodwa ibhalela itafula, abanye bangena etafuleni elifanayo ngaphandle kwesidingo sokukhiya. Umsebenzisi ngamunye uthola umbono ohambisanayo.
IPostgreSQL ngokwendabuko inikela ukusekelwa kwe:
- Izinombolo zokucacisa ngokungafanele.
- Umbhalo wobude obungenamkhawulo.
- Izibalo zeJiyomethri (ezinemisebenzi ehlukahlukene ehambisanayo).
- Amakheli we-IP (IPv4 ne-IPv6).
- Ikheli lesitayela se-CIDR livimba.
- Amakheli e-MAC.
Ukufika.
Ngokwengeziwe abasebenzisi bangazakhela izinhlobo zabo zedatha, ezingabekeka ngokuphelele ngenxa yengqalasizinda yeGiST kwePostgreSQL. Ezinye izibonelo yizinhlobo zedatha ye-GIS eyenziwe iphrojekthi ye-PostGIS.
Mayelana nenguqulo entsha yePostgreSQL 11.0
Ezinsukwini ezimbalwa ezedlule kukhishwe inguqulo entsha yePostgreSQL efinyelele enguqulweni yayo yePostgreSQL 11 ngayo ingeza izici ezintsha futhi ngaphezu kwakho konke ukulungiswa kwamaphutha okuhlukahlukene.
Ama-novelties aphambili ukuthi agxile ekuphathweni kwemininingwane enedatha enkulu yedatha.
Ukwahlukanisa okuthuthukisiwe
I-PostgreSQL isivele ivumela ukwahlukaniswa isikhathi eside, kumayelana nokugcina idatha kumatafula ahlukene ahlukene ngokunengqondo etafuleni elilodwa.
Umsebenzisi wedatha akayiboni le ndlela futhi lokhu kwenza kube nokwenzeka ukugcina idatha kumasistimu wamafayela ahlukahlukene ukuze abe nezici ezahlukahlukene ngokusho kwedatha. Isibonelo, idatha yakamuva igcinwa ku-SSD futhi idatha yakudala igcinwa kwi-hard drive.
Kwakunokwenzeka ukwahlukanisa kuhlu lwedatha noma ngezikhathi. Manje kungenzeka ukwahlukanisa i-hash eyisihluthulelo yokwenza idatha ingahleliwe.
Lokhu kwenza kube nokwenzeka ukusabalalisa imisebenzi yokufunda nokubhala ezitolo eziningi.
Izinkinobho zokuqala nezangaphandle, kanye nezinkomba nezimbangela, manje zingamenyezelwa ezingeni letafula eliyisisekelo futhi zizokhonjiswa kuwo wonke amatafula amalungu kulunga.
I-PostgreSQL Manje usungashintsha nedatha yokuhlukanisa ngokuzenzakalela uma ukhiye wokusabalalisa ushintshwa.
Ukusebenza okufundwayo kwamatafula ahlukanisiwe nakho kuthuthukisiwe ngecebo elisha lokususa ukwahlukanisa.
Isici UPHATHA manje itholakalela amatafula ahlukanisiwe.
Ukutholakala kwemisebenzi kuzinqubo ezigciniwe
Izinqubo ezigciniwe bezitholakala ku-PostgreSQL isikhathi eside, kepha bekungenzeki ukudala ukuthengiselana lapho. Manje kungenzeka.
Ukusebenza okuthuthukisiwe
Manje imisebenzi eminingi ingenziwa ngokufana ukusizakala ngamakhokho amaningi amaprosesa anamuhla.
Ngakho-ke amatafula ahlukanisiwe angafundwa ngokufana, kepha futhi uma umbuzo KHETHA kufaka umbandela INYUNYANA .
Ukwenziwa kwezinkomba nakho kuyafana, kanye neminye imiyalo yolimi lweDatha Definition (I-DDL), njengoba DALA ITHEBULA o DALA UMBONO OPHAKATHI.
Yakha ohambweni
Isihlanganisi sesikhathi siyatholakala. Ungakhulisa imibuzo eyinkimbinkimbi ukuze uthuthukise isivinini sabo sokwenza. I-PostgreSQL isebenzisa i-LLVM compiler ngale njongo.
Ukuyisebenzisa, kufanele bayingeze jit = phambili ukumisa ifayela noma chaza ukuguquguquka kweseshini SET jit = kuvuliwe.
Ukwenza lula = isivinini
Akunasidingo sokubhala kabusha lonke itafula lapho kwenziwa ikholi ALTER TABLE… ENGEZA IKHOLAMU… OKUZENZAKALELAYO … Ngenani elizenzakalelayo elingeyona i-NULL. Lokhu kuthuthukisa kakhulu isivinini sokwenza lo myalo, uma itafula likhulu.
Okuhlangenwe nakho komsebenzisi
Amagama angukhiye ukuphuma kwemali manje sezibonwa yi-interface line line (psql) ukuqedela inqubo, ngaphezu kwe-q.
Ukuze uthole le nguqulo entsha ungavakashela isixhumanisi esilandelayo.