Tuuina atu o le TimescaleDB 1.7

lomia faasalalau DBMS tatala TimescaleDB 1.7, fuafuaina mo le teuina ma le faʻatulagaina o faʻamaumauga i le tulaga o se faasologa o taimi (vaega o tau faʻamaufaʻailoga i taimi faʻapitoa; o faʻamaumauga e faʻatulagaina taimi ma se seti o tau e fetaui ma lenei taimi). O lenei ituaiga o teuina e sili ona lelei mo faʻaoga e pei o le mataʻituina o faiga, fefaʻatauaʻiga tulaga, faiga mo le aoina o metrics ma le sensor states. Meafaigaluega mo le tuʻufaʻatasia ma le poloketi ua tuʻuina atu tusifana и Prometheus.

O le poloketi TimescaleDB o loʻo faʻatinoina o se faʻaopoopoga i PostgreSQL ma tufatufaina e laiseneina i lalo ole Apache 2.0. Fasi vaega fa'atasi ai ma mea fa'apitoa e maua i lalo ole laisene fa'apitoa Taimi taimi (TSL), e le faʻatagaina suiga, faʻasaina le faʻaogaina o le code i oloa lona tolu ma e le faʻatagaina le faʻaaogaina fua i faʻamaumauga o ao (faʻamaumauga-as-a-auaunaga).

Faatasi ai ma suiga i le TimescaleDB 1.7:

• Faʻaopoopo le lagolago mo le tuʻufaʻatasia ma le DBMS PostgreSQL 12. Lagolago mo le PostgreSQL 9.6.x ma le 10.x ua faʻaumatia (Timescale 2.0 o le a naʻo le PostgreSQL 11+).
• O le amio a fa'afesili ma galuega fa'aopoopo fa'aauau (fa'aopoopoina o fa'amaumauga fa'aauau i le taimi moni) ua suia. O ia fesili o lo'o tu'ufa'atasia ai manatu fa'apitoa ma fa'amaumauga fou e le'i fa'atinoina (muamua, fa'aputuga na o fa'amaumauga ua uma ona fa'atinoina). O le amio fou e fa'atatau i fa'aputuga fa'afou fou na faia; mo fa'amatalaga o lo'o i ai, o le "timescaledb.materialized_only=false" e tatau ona seti i le "ALTER VIEW".
• O nisi o mea faigaluega fa'atonutonu fa'asologa o fa'amaumauga ua tu'uina atu i le Community version mai le fa'asalalauga fa'apisinisi, e aofia ai le agava'a e toe fa'avasega fa'amaumauga ma fa'agasolo faiga fa'avae fa'ate'aina fa'amaumauga (fa'atagaina oe e teu na'o fa'amaumauga o lo'o iai nei ma otometi lava ona tape, fa'aputu pe teu fa'amaumauga ua le toe aoga).

Sei o tatou manatua o le TimescaleDB DBMS e mafai ai ona e faʻaogaina faʻamatalaga SQL atoa e iloilo ai faʻamaumauga faʻapipiʻi, tuʻufaʻatasia le faigofie o le faʻaogaina i totonu o DBMS faʻatasi ma le faʻaogaina ma le gafatia o loʻo iai i faiga faʻapitoa NoSQL. O le fausaga o le teuina e sili ona lelei ina ia mautinoa le maualuga o le saoasaoa o faʻaopoopoga faʻamaumauga. E lagolagoina le faʻaopoopoina o faʻamaumauga o faʻamaumauga, le faʻaogaina o faʻamaufaʻailoga i-memory, toe faʻapipiʻiina o tala faʻasolopito, ma le faʻaogaina o fefaʻatauaiga.

O se vaega taua o le TimescaleDB o lona lagolago mo le vaeluaga otometi o le fa'asologa o fa'amaumauga. E otometi lava ona fa'asoa fa'asoa i luga o laulau vaelua. O vaega e faia e fa'atatau i le taimi (o vaega ta'itasi e teuina fa'amaumauga mo se vaitaimi patino) po'o le fa'atatau i se ki fa'apitoa (mo se fa'ata'ita'iga, fa'amatalaga masini, nofoaga, ma isi). Ina ia fa'amalieina le fa'atinoga, e mafai ona tufatufa laulau vaelua i va'aiga eseese.

Mo su'esu'ega, ose fa'amaumauga tu'ufa'atasi e pei o se laulau tele e ta'ua ole hypertable. O le hypertable o se ata fa'atusa o le tele o laulau ta'itasi e fa'aputuina fa'amaumauga o lo'o sau. O le hypertable e faʻaaogaina e le gata mo fesili ma faʻaopoopoina faʻamatalaga, ae faʻapea foʻi mo gaioiga e pei o le fatuina o faʻasinomaga ma le suia o le fausaga ("ALTER TABLE"), natia le faʻavae vaega maualalo o le faʻamaumauga mai le tagata faʻapipiʻi. Faatasi ai ma se hypertable, e mafai ona e faʻaogaina soʻo se galuega faʻapipiʻi, subqueries, merge operations (JOIN) ma laulau masani, ma galuega faʻamalama.

puna: opennet.ru