Iqela lePostgreSQL libhengeze ukukhutshwa kwePostgreSQL 12, inguqulelo yamva nje yenkqubo yolawulo lwesiseko sedatha evulekileyo.
I-PostgreSQL 12 iye yaphucula kakhulu ukusebenza kwemibuzo - ngakumbi xa isebenza ngomthamo omkhulu wedatha, kwaye iphinde yalungisa ukusetyenziswa kwendawo yediski ngokubanzi.
Iimpawu ezintsha ziquka:
- ukuphunyezwa kwe-JSON Path query language (eyona nxalenye ibalulekileyo yomgangatho we-SQL/JSON);
- ukulungelelaniswa kokuphunyezwa kweentetho zetafile eziqhelekileyo (NGANYE);
- inkxaso yeekholamu ezenziweyo
Uluntu luyaqhubeka nokusebenza ekwandiseni kunye nokuthembeka kwePostgreSQL, ukuphuhlisa inkxaso ye-internationalization, amandla okuqinisekisa, kunye nokubonelela ngeendlela ezilula zokulawula inkqubo.
Olu kukhululwa lubandakanya ukuphunyezwa kwe-interface yeenjini zokugcina iiplagi, ezivumela abaphuhlisi ukuba benze iindlela zabo zokugcina idatha.
Ukuphuculwa kokusebenza
I-PostgreSQL 12 ibandakanya ukuphuculwa kokusebenza okubalulekileyo kunye nokugcinwa kwe-indexing kunye ne-partitioning systems.
Izalathisi ze-B-tree, uhlobo oluqhelekileyo lwe-indexing kwi-PostgreSQL, luphuculwe kwinguqulo ye-12 yomthwalo wemisebenzi ebandakanya ukuguqulwa kwesalathisi rhoqo. Ukusebenzisa i-benchmark ye-TPC-C ye-PostgreSQL 12 ibonise umyinge we-40% yokunciphisa ukusetyenziswa kwendawo kunye nokunyuka ngokubanzi ekusebenzeni kombuzo.
Imibuzo echasene neetheyibhile ezahluliweyo ifumene uphuculo oluqaphelekayo, ngakumbi kwiitheyibhile ezibandakanya amawaka ezahlulelo ezifuna ukusebenza ngeendawo ezilinganiselweyo zoluhlu lwedatha. Ukusebenza kwongezwa kwedatha kwiitheyibhile ezicatshulweyo usebenzisa i-INSERT kunye ne-COPY iphuculwe, kunye nokukwazi ukunamathisela isahlulelo esitsha ngaphandle kokuthintela imibuzo.
I-PostgreSQL 12 yenze uphuculo olongezelelweyo kwisalathiso esinempembelelo ekusebenzeni ngokubanzi, kubandakanya:
- ukunciphisa i-overhead xa uvelisa i-WAL ye-GiST, i-GIN kunye neentlobo zesalathisi ze-SP-GiST;
- ukukwazi ukwenza okubizwa ngokuba zizalathisi zokugquma (INQULUDE igatya) kwizalathisi ze-GiST;
- ukukwazi ukwenza imibuzo "yommelwane okufutshane" (ukukhangela kwe-k-NN) usebenzisa umqhubi womgama (<->) kunye nokusebenzisa i-SP-GiST indexes;
- inkxaso yokuqokelela ixabiso eliqhelekileyo (MCV) amanani-manani usebenzisa CREATE STATISTICS, enceda ukufumana izicwangciso zombuzo ezingcono xa usebenzisa amakholomu amaxabiso angasasazwanga ngokulinganayo.
Ukuhlanganiswa kwe-JIT kusetyenziswa i-LLVM, eyaziswa kwi-PostgreSQL 11, ngoku yenziwe ngokungagqibekanga. Ukuqulunqwa kwe-JIT kuphucula ukusebenza xa kusetyenzwa ngamabinzana APHI namagatya, uluhlu ekujoliswe kulo, i-aggregates, kunye neminye imisebenzi yangaphakathi. Iyafumaneka ukuba uqokelele iPostgreSQL ngeLLVM okanye usebenzisa iphakheji yePostgreSQL eyakhiwe ngeLLVM eyenziwe yasebenza.
Ukuphuculwa kwezakhono zolwimi lweSQL kunye nokuhambelana okusemgangathweni
I-PostgreSQL 12 yazisa ukukwazi ukubuza amaxwebhu e-JSON usebenzisa iindlela zendlela ze-JSON ezichazwe kumgangatho we-SQL/JSON. Imibuzo enjalo inokusebenzisa iindlela ezikhoyo zesalathiso kumaxwebhu agcinwe kwifomathi ye-JSONB ukufumana ngokufanelekileyo idatha.
Inkcazo yetafile eqhelekileyo, eyaziwa ngokuba NGEmibuzo, ngoku ingenziwa ngokuzenzekelayo ngokusebenzisa indawo kwi-PostgreSQL 12, enokuthi incede ukuphucula ukusebenza kwemibuzo emininzi ekhoyo. Kwinguqulelo entsha, inxalenye yokutshintshwa kombuzo WONYE unokuphunyezwa kuphela ukuba ayiphindi, ayinayo imiphumo emibi, kwaye ibhekiselwa kanye kuphela kwinxalenye elandelayo yombuzo.
I-PostgreSQL 12 yazisa inkxaso "yeekholamu ezenziweyo". Ichazwe kumgangatho we-SQL, olu hlobo lwekholamu lubala ixabiso ngokusekelwe kwimixholo yezinye iikholamu kwitheyibhile enye. Kule nguqulo, i-PostgreSQL ixhasa "iikholamu ezenziweyo ezigciniweyo", apho ixabiso elibaliweyo ligcinwe kwidiski.
Ukwenziwa kwamazwe ngamazwe
I-PostgreSQL 12 yandisa inkxaso yokuhlanganiswa kwe-ICU ngokuvumela abasebenzisi ukuba bachaze "ukudibanisa okungagqibekanga" okunokuthi, umzekelo, kuvumele uthelekiso olungenamvakalelo okanye i-accent-insensitive.
Uqinisekiso
I-PostgreSQL yandisa inkxaso yayo kwiindlela zokuqinisekisa ezomeleleyo kunye nezixhasi ezininzi ezibonelela ngokhuseleko olongezelelweyo kunye nokusebenza. Olu khululo lwazisa ufihlo lwecala lomxhasi kunye necala leseva ukwenzela ungqinisiso ngaphezulu kojongano lwe-GSSAPI, kunye nokukwazi kwe-PostgreSQL ukufumana iiseva ze-LDAP xa i-PostgreSQL idityaniswa ne-OpenLDAP.
Ukongeza, i-PostgreSQL 12 ngoku ixhasa ukhetho lokuqinisekiswa kwezinto ezininzi. Umncedisi wePostgreSQL ngoku unokufuna ukuba umxhasi anikezele ngesatifikethi esisebenzayo se-SSL kunye negama lomsebenzisi elihambelanayo usebenzisa i-clientcert=verify-full, kwaye udibanise oku kunye nemfuno yendlela yoqinisekiso eyahlukileyo (umzekelo. scram-sha-256).
Ulawulo
I-PostgreSQL 12 yazisa ukukwazi ukwenza ulwakhiwo olungathinteliyo lwesalathisi usebenzisa i-REINDEX NGOKUQHELEKILEYO umyalelo. Oku kuvumela abasebenzisi ukuba baphephe ixesha lokunciphisa i-DBMS ngexesha elide lokwakhiwa kwakhona kwesalathisi.
Ukongeza, kwi-PostgreSQL 12, unokwenza okanye ukhubaze i-checksums yephepha kwiqela lokuvala usebenzisa i-pg_checksums umyalelo. Ngaphambili, i-checksums yephepha, inqaku elinceda ukungqinisisa ukuthembeka kwedatha egcinwe kwidiski, inokuvulwa kuphela xa iqela le-PostgreSQL laqaliswa kusetyenziswa initdb.
umthombo: linux.org.ru