Inguqulo entsha yePostgreSQL 11.0 isivele ikhishiwe

postgresql

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.

okuthunyelwe 11

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. 


Yiba ngowokuqala ukuphawula

Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.