fbpx

ʻO kā mākou hana

Hana mākou e like luna hoʻomalu hōkeo ʻikepili Oracle ma:

Milan, Bergamo, Brescia, Varese, ComoCremonaLeccoMantua, PaviaSondrio aka, ke hana nei makou,

AbruzzoAkulaChietiPescaraTeramo

Basilicata : Matera , ʻO Potenza

Calabria : CatanzaroCosenzaCrotoneʻO Reggio Calabria , Vibo Valentia

Campania : AvellinoBeneventoCaserta ,   NapelaSalerno

Emilia Romagna : BolognaʻO Ferrara ,   WahiCesena ,   Modena ,   ParmaPiacenza,   RavennaʻO Reggio EmiliaRimini

Friuli Venezia Giulia : ʻO KeloriaPordenone ,   Trieste , Udine

Lazio : FrosinoneLatinaRietiRomeViterbo

Liguria : GenoaImperia , Mea ʻala ,  Savona

Lombardy : BergamoBresciaComoCremonaLeccoMantua ,   Milan ,   PaviaSondrio , Varese

ʻO MarcheAnconaAscoli picenoʻO MacerataKaumaha au , Urbino

MoliseCampobassoIsernia

Piedmont : AlessandriaAstiʻO Biella,   CuneoNovaraTurinʻO Vercelli

PugliaBariBrindisiFoggia,   LecceTaranto

Sardinia : CagliariʻĀpanaʻO IklesiasnuoroʻO Ogliastra,   OlbiaLuakiniOristanoSasari

SiciliaʻAukakeʻO Caltanissetta , Catania ,   Enna ,   Messina ,   PalermoRagusa ,   SyracuseTrapaniMarsala , ʻO Mazara del vallo,  pantelleria

TuscanyArezzoFlorenceʻO GrossetoLivornoLuccaMassa CarraraPisa ,   PistoiaPratoIā Siena

ʻO Trentino Alto Adige : ʻO BolzanoTrento

UmbriaPerugiaʻO Terni 

Valle d'Aosta : Aosta

VenetoBellunoPadova ,   RovigoʻO TrevisoVeniceVeronaʻO Vicenza

Svizzera: Lugano, Canton of Ticino, bellinzone, Locarno, mendrisio, .

kakau

E hōʻoia no mākou LekaʻElele a e hoʻomau i kēia manawa

*

Postgresql DBA

Ua aʻo ʻo CEO Stefano Fantin i ke code kumu o ka DBMS ʻO Postgresql mai Postgresql version 8 a hiki i Postgresql 9.5, ua hoʻololi mākou i ka version 10 a ma ka version 11 Postgresql version 12 i puka mai. Pūnaewele pūnaewele pūnaewele ke hoʻopukapuka nei i ka manawa a me ke kālā i ka noiʻi a me ka hoʻomohala ma Postgresql 13.

KUHI DBA POSTGRESQL:

Lama Waihona DBA Postgresql 8.0: PITR, Tablespace, Kākoʻo Pūnaewele, Mālama
Lama Waihona DBA Postgresql 8.1: Hōʻailona papa ʻaina, nā pākēkē Bitmap, ʻelua mau lua hana, autovacuum
Lama Waihona DBA Postgresql 8.2: Warm Standby, SQL 2003, Kūkulu Kūʻē Kūʻai Kūʻai, index index Gin
Lama Waihona DBA Postgresql 8.3: Nā hōʻano hou, Asynchronous komit, XML, ʻimi piha ʻo Fulltext, ʻōpili hōʻē
Lama Waihona DBA Postgresql 8.4: Nā hana Windows, CTE, hōkeoʻikepili nā hōʻuluʻulu ʻana, ʻae ʻia no kēlā me kēia kolamu
Lama Waihona DBA Postgresql 9.0: Kūleʻa Hotby, Nā Hoʻomohoke ʻana o nā Koloa, Kāwewe Kūpono, nā Kelepona Kūwila, kahi hale kūʻai
Lama Waihona DBA Postgresql 9.1: Pūnaewele, Pūnaewele, Pūnaewele, Pūnaewele, Nā Kuhi Pūʻulu Haole, Pūnaewele Uwau ʻia, Hoʻomoka ʻo Serialisable.
Lama Waihona DBA Postgresql 9.2: Hōʻike Cascading, Index-Nā kuʻina, pg_stat_statements, Json, Ranges
Lama Waihona DBA Postgresql 9.3: Nā mea kākau moʻolelo kūwaho haole, nā ʻike maka, JSON hana a me nā mea hana, LATERAL
Lama Waihona DBA Postgresql 9.4: ʻO ka hana hou ʻana, nā kau Replication, JSONB -> GIN (Generalized Inverted Index), scalability: Logical Decoding
Lama Waihona DBA Postgresql 9.5: UPSERT, palekana pae pae, hana no BigʻIkepili: ʻO ka index BRIN, algorithm i kapa ʻia "nā kī i hoʻopōkole ʻia", CUBE, ROLLUP, a me GROUPING SET, TABLESAMPLE, Nā ʻIke ʻikepili haole (FDW)

Lama Waihona DBA Postgresql 9.6: ʻO ka hoʻonui ʻia ʻana ma o nā nīnau like, ʻo ka hoʻopaʻa ʻana ma o ka hoʻopili like ʻana a me ka 'postgres_fdw', ʻoi aku ka maikaʻi o ka huli kikokikona me nā ʻōlelo. Nīnau Parallel: Nā hiʻohiʻona kaʻina like, nā hui like, nā hōʻuluʻulu like.
Nā wahi kūʻai, VACUUM a me ka palapala ʻike: pg_visibility extension no ka nānā ʻana i nā palapala ʻike, nā ʻaoʻao ʻaoʻao Frozen i ka palapala ʻike no ka hemo ʻana i ka hakahaka ma nā ʻikepili i hoʻopaʻa mua ʻia, ka hoʻopau ʻia ʻana o ka hana a nā snapshot e kāohi ai i ka lemat meja. Ka hana ʻana a me ka nānā ʻana:
Nā ʻikepili ʻimi i hōʻike ʻia i loko o pg_stat_activity, Ka helu ʻonaʻī wale ʻana no nā māka ʻāpana, hoʻomaikaʻi i ka hoʻomaʻamaʻa ʻana no ka hana o waho. Manaʻoʻōlelo a me ka hoʻokele ʻana: Hōʻike pūnaewele hou i pg_config, pg_blocking_pids, Nā hana pg_get_ * e hoʻi ai ʻo NULL ma ka pololei
mea, pg_notification_queue_usage e nānā i ka leka hoʻomaopopo. Hoʻihoʻi: pg_basebackup i hoʻonui ʻia me nā slot replication, API hou no nā kākoʻo kino wela. ʻO nā hiʻohiʻona ʻē aʻe: Ka hōʻike ʻana i ka holomua o ka holomua, Generic WAL facility, Trigonometric functions in degere.

ʻAʻole wale kēlā mau mea e pili iā mākou e koho iā mākou.

    0/5 (0 Manaʻo)
    0/5 (0 Manaʻo)
    0/5 (0 Manaʻo)

    E ʻike hou aʻe mai ka Pūnaewele Pūnaewele Pūnaewele

    E kau inoa no ka loaʻa ʻana o nā ʻatikala hou loa ma ka leka uila.

    mea kākau avatar
    Keʻena Luna CEO
    👍Keʻena Pūnaewele Pūnaewele | He loea pūnaewele pūnaewele ma Digital Marketing a me SEO. ʻO ka Pūnaewele Pūnaewele he Pūnaewele Pūnaewele. No ka Agenzia Web Online ka holomua ma ka hoʻololi kikohoʻe ma luna o nā kumu o ka Iron SEO version 3. Specialties: System Integration, Enterprise Application Integration, Service Oriented Architecture, Cloud Computing, Data warehouse, business intelligence, Big Data, portals, intranets, Web Application Ka hoʻolālā a me ka hoʻokele ʻana i nā ʻikepili pili a me nā multidimensional Ka hoʻolālā ʻana i nā loulou no ka media kikohoʻe: hoʻohana a me nā Kiʻi. Hāʻawi ka Pūnaewele Pūnaewele Pūnaewele i nā hui i kēia mau lawelawe: -SEO ma Google, Amazon, Bing, Yandex; -Web Analytics: Google Analytics, Google Tag Manager, Yandex Metrica; -Ka hoʻololi ʻana o nā mea hoʻohana: Google Analytics, Microsoft Clarity, Yandex Metrica; -SEM ma Google, Bing, Amazon Ads; - Ke kūʻai aku ʻana i ka Social Media (Facebook, Linkin, Youtube, Instagram).
    ʻO kaʻu pilikino Agile
    Ke hoʻohana nei kēia pūnaewele i nā kuki ʻenehana a me ka hoʻolaha ʻana. Ma ke kaomi ʻana i ka ʻae e ʻae ʻoe i nā kuki profiling āpau. Ma ke kaomi ʻana i ka hōʻole a i ʻole ka X, hōʻole ʻia nā kuki hoʻolaha a pau. Ma ke kaomi ʻana iā customize hiki ke koho i nā kuki profiling e hoʻā.
    Hoʻopili kēia pūnaewele i ka Data Protection Act (LPD), Swiss Federal Law of 25 September 2020, a me ka GDPR, EU Regulation 2016/679, e pili ana i ka pale ʻana i ka ʻikepili pilikino a me ka neʻe manuahi o ia ʻikepili.