Ukukhutshwa kwe-TimescaleDB 1.7

ipapashiwe Ukukhutshwa kweDBMS I-TimescaleDB 1.7, eyenzelwe ukugcina kunye nokucubungula idatha ngendlela yochungechunge lwexesha (iziqwenga zamaxabiso eparameter ngamaxesha achaziweyo; irekhodi lenza ixesha kunye neseti yamaxabiso ahambelana neli xesha). Olu hlobo lokugcinwa lufanelekile kwizicelo ezifana neenkqubo zokubeka iliso, iiplatifomu zokurhweba, iinkqubo zokuqokelela i-metrics kunye ne-sensor states. Izixhobo zokudibanisa neprojekthi zinikezelwe IGrafana и Prometheus.

Iprojekthi ye-TimescaleDB iphunyezwa njengokwandiswa kwe-PostgreSQL kunye isasazwa ngu ilayisenisi phantsi kweApache 2.0. Icandelo lekhowudi ezineempawu eziphambili ezifumanekayo phantsi kwelayisenisi yobunini eyahlukileyo Ixesha lexesha (TSL), engavumeli utshintsho, inqanda ukusetyenziswa kwekhowudi kwimveliso yomntu wesithathu kwaye ayivumeli ukusetyenziswa kwamahhala kwiinkcukacha zefu (idatha-njengenkonzo-nkonzo).

Phakathi kotshintsho kwi-TimescaleDB 1.7:

• Inkxaso eyongeziweyo yokudibanisa ne-DBMS IPostgreSQL 12. Inkxaso ye-PostgreSQL 9.6.x kunye ne-10.x iyekisiwe (i-Timescale 2.0 iya kuxhasa kuphela i-PostgreSQL 11+).
• Indlela yokuziphatha kwemibuzo eqhuba imisebenzi edibeneyo (i-aggregation yedatha engenayo eqhubekayo ngexesha lokwenyani) itshintshiwe. Imibuzo elolu hlobo ngoku idibanisa iimbono ezibonakalayo kunye nedatha esanda kufika engekabonakali (ngaphambili, ukuhlanganiswa kwedatha kuphela esele yenziwe). Indlela entsha yokuziphatha isebenza kwiintlanganisela eziqhubekayo ezisanda kwenziwa, kwiimbono ezikhoyo, iparamitha ye-"timescaledb.materialized_only=false" kufuneka imiselwe ngokusetyenziswa kwe-"ALTER VIEW".
• Ezinye izixhobo zolawulo lwedatha ephucukileyo zidluliselwe kwinguqulelo yoLuntu ukusuka kushicilelo lwentengiso, kubandakanywa ukukwazi ukuhlanganisa kwakhona idatha kunye nokusetyenzwa kwemigaqo-nkqubo yokukhutshwa kwedatha engasasebenziyo (ekuvumela ukuba ugcine idatha yangoku kuphela kwaye ucime ngokuzenzekelayo, udibanise okanye ugcine iirekhodi eziphelelwe lixesha).

Masikhumbule ukuba i-TimescaleDB DBMS ikuvumela ukuba usebenzise imibuzo ye-SQL epheleleyo ukuhlalutya idatha eqokelelweyo, ukudibanisa ukukhululeka kokusetyenziswa okuhambelana neeDBMS ezihambelanayo kunye nokulinganisa kunye nobuchule obukhoyo kwiinkqubo ze-NoSQL ezikhethekileyo. Isakhiwo sokugcina siphuculwe ukuqinisekisa isantya esiphezulu sokongeza idatha. Ixhasa ukongezwa kwebhetshi yeeseti zedatha, ukusetyenziswa kwezalathisi ezikwimemori, ukulayishwa okuphindiweyo kwezilayi zembali, kunye nokusetyenziswa kwentengiselwano.

Inqaku eliphambili le-TimescaleDB yinkxaso yayo yokwahlula ngokuzenzekelayo koluhlu lwedatha. Igalelo ledatha lisasazwa ngokuzenzekelayo kuzo zonke iitafile ezahluliweyo. Amacandelo adalwe ngokuxhomekeke kwixesha (icandelo ngalinye ligcina idatha kwixesha elithile) okanye ngokumalunga neqhosha elingenasizathu (umzekelo, i-ID yesixhobo, indawo, njl.). Ukwandisa ukusebenza, iitheyibhile ezahluliweyo zinokusasazwa kwiidiski ezahlukeneyo.

Kwimibuzo, isiseko sedatha esahluliweyo sijongeka njengetafile enye enkulu ebizwa ngokuba yi-hypertable. I-hypertable luphawu olubonakalayo lweetheyibhile ezininzi eziqokelela idatha engenayo. I-hypertable ayisetyenziselwanga kuphela imibuzo kunye nokongeza idatha, kodwa kunye nemisebenzi efana nokudala izalathisi kunye nokutshintsha isakhiwo ("ALTER TABLE"), ukufihla inqanaba elisezantsi lecandelo lesiseko sedatha kumphuhlisi. Ngehypertable, ungasebenzisa nayiphi na imisebenzi edibeneyo, imibuzo ephantsi, ukudibanisa imisebenzi (JOIN) kunye neetafile eziqhelekileyo, kunye nemisebenzi yefestile.

umthombo: opennet.ru