I-PostgreSQL yinkqubo yolawulo lwedatha ehambelana nezinto kwaye isimahla, ikhutshwe phantsi kwelayisensi yePostgreSQL, efanayo ne-BSD okanye iMIT.
Njengezinye iiprojekthi ezininzi ezivulekileyo, Uphuhliso lwePostgreSQL alulawulwa yinkampani enye okanye umntu, kodwa luqhutywa luluntu lwabaphuhlisi abasebenza ngokuzingca, ngokuzithandela, ngokukhululekileyo okanye ngenkxaso yemibutho yorhwebo.
Ezinye zeempawu zayo eziphambili zezi:
Ukuzimasa okuphezulu
Ngenkqubo ebizwa ngokuba yi-MVCC (Multi-Version Access Concurrent Access, ngesifinyezo sayo ngesiNgesi) PostgreSQL ivumela ukuba ngelixa enye inkqubo ibhalela itafile, abanye bangena kwitafile efanayo ngaphandle kwesitshixo. Umsebenzisi ngamnye ufumana umbono ohambelanayo.
Iposi ye-PostgreSQL inika inkxaso:
- Amanani okuchaneka ngokungahambelaniyo.
- Isicatshulwa esingapheliyo.
- Amanani ejiyometri (enemisebenzi eyahlukeneyo ehambelana nayo).
- Iidilesi ze-IP (IPv4 kunye ne-IPv6).
- Iibhloko zedilesi yesitayile seCIDR.
- Iidilesi zeMAC.
Ukufika.
Ukongeza Abasebenzisi banokwenza iindidi zabo zedatha, ezinokubonisa ngokupheleleyo ukubonga kwiziseko zophuhliso zeGiST KwiPostgreSQL. Eminye imizekelo ziintlobo zedatha ye-GIS eyenziwe yiprojekthi yePostGIS.
Malunga nenguqulelo entsha yePostgreSQL 11.0
Kwiintsuku ezimbalwa ezidlulileyo inguqulelo entsha yePostgreSQL yakhutshwa efikelele kwinguqulelo yayo yePostgreSQL 11 ngayo yongeza amanqaku amatsha kwaye ngaphezulu kwako konke ukulungiswa kwe-bug.
Izinto ezintsha ezinqabileyo kukuba zijolise kulawulo lwedatha enomthamo omkhulu wedatha.
Ukuphucula ukwahlula
I-PostgreSQL sele ivumela ukwahlula ixesha elideImalunga nokugcinwa kwedatha kwiitafile ezahlukeneyo ezikwitafile enye.
Umsebenzisi wedatha akaluboni olu lwakhiwo kwaye oku kwenza ukuba kube nakho ukugcina idatha kwiinkqubo ezahlukeneyo zeefayile ukuze zibe neempawu ezahlukeneyo ngokwedatha. Umzekelo, idatha yakutshanje igcinwe kwi-SSD kwaye idatha yakudala igcinwa kwi-hard drive.
Kwakunokwenzeka ukwahlulahlula kuluhlu lweedatha okanye ngamakhefu. Ngoku kuyenzeka ukwahlulahlulahlula i-hash yesitshixo yokwenza idatha ngokungafaniyo.
Oku kwenza ukuba kube nakho ukusasaza imisebenzi yokufunda kunye nokubhala kwiivenkile ezininzi.
Izitshixo zaseprayimari nezangaphandle, kunye nezalathiso kunye nezinto ezibangela, ngoku zinokubhengezwa kwinqanaba leetafile eziphambili kwaye ziya kubonakala kuzo zonke iitafile zamalungu kwisahlulelo.
PostgreSQL ngoku unokutshintsha idatha yokwahlula ngokuzenzekelayo ukuba isitshixo sokuhambisa sitshintshiwe.
Ukusebenza kokufunda kweetafile ezahluliweyo kuphuculwe ngesicwangciso esitsha sokususa ukwahlulahlula.
Uphawu KHUTHAZA ngoku iyafumaneka kwiitafile ezahluliweyo.
Ukufumaneka kwemicimbi kwiinkqubo ezigciniweyo
Iinkqubo ezigciniweyo ziye zafumaneka kwiPostgreSQL ixesha elide, kodwa azange kwenzeke ukwenza ukuthengiselana apho. Ngoku kunokwenzeka.
Ukuphuculwa kokusebenza
Ngoku imisebenzi emininzi inokwenziwa ngaxeshanye ukusebenzisa amathuba amaninzi eeprosesa zanamhlanje.
Ke ngoko, iitafile ezahluliweyo zinokufundwa ngokudibeneyo, kodwa naxa kukho umbuzo KHETHA kubandakanya igatya UNION .
Ukudalwa kwezalathiso kukwahambelana, kunye neminye imiyalelo yoLwimi Inkcazo yoLwimi (I-DDL), njenge YENZA ISICWANGCISO o YENZA UMBONO OBONAKALAYO.
Yakha ekuhambeni
Umhlanganisi wexesha uyafumaneka. Unokwandisa imibuzo enzima ukuphucula isantya sokwenza. I-PostgreSQL isebenzisa umhlanganisi we-LLVM kule njongo.
Ukuyisebenzisa, kufuneka bayongeze jit = kwi-onal ifayile yoqwalaselo okanye uchaze iseshoni eyahlukileyo SET jit = ivuliwe.
Ukwenza lula = isantya
Akukho sidingo sokuphinda uyibhale yonke itafile xa kusenziwa umnxeba NGANYE ITHEYIBHILE… YONGEZA IKHOLAM ... … Ngexabiso elisisiseko elingelilo i-NULL. Oku kuphucula kakhulu isantya sokuphumeza lo myalelo, ukuba itheyibhile inkulu.
Amava omsebenzisi
Amagama angundoqo ukuphuma kwempahla ngoku babonwa ngumnxibelelanisi welayini yomyalelo (psql) yokugqibezela inkqubo, ukongeza kwi-q.
Ukuze ufumane le nguqulo intsha ungandwendwela eli khonkco lilandelayo.